MySQL Connect Files in PHP

Your website can have several PHP pages that all access your MySQL database. One time saving idea is to store your connection code in a separate file, and then include the file where needed.

For example, we can use the SQL code below to login to our MySQL database. Let's save this code in a file called datalogin.php.

<?php
// Connects to Our Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
?>

Now, whenever we need to connect to our database, we just include this line in our PHP file:

//MySQL Database Connect
include 'datalogin.php';

You can learn more about including files, and connecting to MySQL from PHP in the other tutorials on our website.