Let's see how to connect to the MySQL Database with PHP. PHP comes with MySQL extension (API) to access MySQL DB. This extension is deprecated as of PHP 5.5.0, and will be removed in the future. So for higher versions of PHP we should go for the MySQLi or PDO_MySQL extension. We'll see the connection process with both MySQL and MySQLi extensions here.
1. Connect to DB with MySQL Extension
The connection is a two step process. First we should use
mysql_connect() function to connect to the database. Next we should select the database with the function
Syntax for mysql_select_db()
If we want to connect to the localhost server then we use,
<?php //connect to mysql server $con = mysql_connect("localhost","root","") or die('Error: ' . mysql_error()); //$con is the mysql_handler //select db name mysql_select_db("db_employee", $con); ?>Example 2
Instead of the server name we can use the ip address of the server like this,
<?php $con = mysql_connect("127.0.0.1","admin","user001") or die('Error: ' . mysql_error()); mysql_select_db("db_employee", $con); ?>
2. Connect to DB with MySQLi Extension
The MySQLi is the improved version of the MySQL extension and is designed to work with MySQL version 4.1.13 or above. We'll see how to use this extension for connecting the MySQL DB.
Here the process is even more simpler. There is no need to use two functions similar to the above example, one for connecting the server and another for selecting the database name. With the single
mysqli_connect() function, we can accomplish both the tasks.
<?php $con = mysqli_connect("localhost","root","user1","db_student") or die("Error " . mysqli_error($con)); ?>
Note: If you use MySQL Database version 4.1.3 or above, then it is strongly recommended that you use MySQLi extension.