SANGKRIT

Connecting Database

You need to connect MySQL database before assessing it. This is done by mysql_connect function.

You should know the following terms before getting connected to MySQL server:

Name of the server. The default server name is localhost. Username and Password.

<?php

$con = mysql_connect(“localhost”,”Admin”,”1234″);

*above given server name, username and password are just examples. Practically you have to give your own server name, user name and password

$con = mysql_connect(“server name”, “username”, “password”);*
if (!$con)

{
die(‘Could not connect: ‘ . mysql_error());
}

?>

After the script ends, the connection will get closed automatically. In case if you want to close MySQL database connection before the script ends, then follow the following code:

<?php

$con = mysql_connect(“localhost”,”Admin”,”1234″);

if (!$con)

{

die(‘Could not connect: ‘ . mysql_error());

}

mysql_close($con);

?>

You may not need to create a database or user account if you are using MySQL server in a hosted environment, and if they supplied you with a username and database name.

Leave a Reply