MySQL Connection

Connection with MySQL Database
Before accessing database, you must create a connection to the database

Syntax:
mysql_connect(servername,username,password);
where,
servername specifies the server to connect to. Default value is “localhost”
username specifies the username to log in with. Default value is the name of the user that owns the server process. To connect offline we use username “root”.
password specifies the password to log in with. Default is “”

Code:
Creating connection to the database and selecting the required database
<?php
$con = mysql_connect(“localhost”,”root”,”");
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
} else{
mysql_select_db(“test”, $con)
};
?>
Here, we have store connection in a variable called $con and trap error using die function.

Closing connection
The connection will be closed automatically when the script ends. To close the connection before, use the mysql_close() function:
<?php
$con = mysql_connect(“localhost”,”root”,”");
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
} else{
mysql_select_db(“test”, $con)
};
mysql_close($con);
?>