You can use both mysql and mysqli extension for executing SQL queries. Here is a tutorial on how to connect both the extensions to a database.
Create a file named config.php where you will connect to the database. Put the following code in it:
$mysqli = new mysqli("localhost", "username", "password", "db");
... [READ MORE]
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$bd = mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("db",$bd) or die(mysql_error());
?>
Check whether mysqli connection is made or not in php
This function helps to check whether connection the mysql server has been made or not.
... [READ MORE]
Here is the code:
if ($mysqli->ping()) {
echo ("Our connection is ok!n");
} else {
printf ("Error: %sn", $mysqli->error);
}
The $mysqli variable is a connection made via mysqli function.
Know more about mysqli ping function here.