Hi guys,
Today, we will see about mysql database connection in php.
In the world of web development, data plays a key role. To give best experience to the users, we need to keep track of user steps to make comfortable. Definitely we need to store data related to users.
<?php
$servername = "localhost"; //your servername
$username = "username"; // your db username
$password = "password"; // your db password
$database_name = "database_name"; // your db name
// connect to the server
$conn = new mysqli($servername,$username,$password,$database_name);
//check whether it is connected or not.
if($conn->connect_error)
{
echo "Not Connected";
}
else
{
echo "Successfully Connected";
}
?>
In this way, we will connect to the MySQL Server using PHP.
Thanks for taking your valuable time for reading my post, if you have any queries , please leave a comment and will respond. If you find this post useful, please share it.
Social Profile : LinkedIn
Have a Nice Day!
Top comments (2)
Hi, rather than mysqli, I would prefer using PDO. php.net/manual/en/pdo.connections.php
It would be much easier to migrate from MySQL to another DB if needed. It is used in all frameworks like Laravel, Symfony etc.
Hi there,
Yeah I agree with you, but for beginners that will be little bit confusion, as a newbie, the above approach will be much simpler.
Thanks for your response!