Create a database connection file in php mysql

Whenever you are working on a project you might need to create a database connection and select a database.

Here i am going to show you a simple way to create your connection file "connect.php"

First create a file and save it as "connect.php"

<br /><br /><?php<br /><br />//code for connect.php<br /><br />$host = "localhost"; // replace this with your host, default is localhost<br /><br />$user = "username"; // replace with the mysql username<br /><br />$pass = "password"; // replace with the mysql password<br /><br />$db_name = "mydb";<br /><br /><br />mysql_connect($host,$user,$pass) or die("<br />Cannot connect to host.....".mysql_error());<br /><br />mysql_select_db($db_name) or die("<br />Cannot connect to Database.....".mysql_error());<br /><br />?><br />

Now save this file.
Now just include this file on top of your any other php script.
No need to write code each time.
ex. create a new file called "data.php" and include "connect.php" in that file on top as

<br /><br /><?php<br />include "connect.php";<br /><br />// your remaining database related code here<br />?><br /><br />

Have nice time.