How to connect to a database ?

How to connect to a database ?

I think there is a missing part in your login page PHP script that makes users unable to connect or login to your web page. In order for a user to connect to a database or access data from a database, you must first need to establish a connection to the database itself. Since you are using PHP, it can be done using the function “mysql_connect()”. Below is the function’s correct syntax.

• mysql_connect(servername,username,password);

Where servername is the name of the server you want to connect to. The default is localhost:3306. Below is an example of how to create a connection to the database using PHP.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)

  die('Could not connect: ' . mysql_error());
  }

// some code
?>

The connection automatically closes when the script ends. Or, if you want to close the connection before the script terminates, you may use the function “mysql_close()”. See below for the example.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

mysql_close($con);
?>