PHP MySQL Database Connect

Create a Connection to a MySQL Database In PHP


Before you can access data in a database, you must create a connection to the database.
In PHP, this is done with the mysql_connect() function.

Syntax:

mysql_connect(servername,username,password);  

Servername: Optional. Specifies the server to connect to. Default value is "localhost:3306".

Username: Optional. Specifies the username to log in with. Default value is the name of the user that owns                                  the server process.

Example

In the following example we store the connection in a variable ($con) for later use in the script. The "die" part will be executed if the connection fails:
<?php
$con = mysql_connect("localhost","john","a1b2c3");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// code here
?> 

Password: Optional. Specifies the password to log in with. Default is "".

Closing a 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","john","a1b2c3");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

mysql_close($con);
?>