Home Yellow Pages Movies Classifieds Jokes Jobs Free Hosting Videos




MySQL Connect

Connecting to a MySQL Database : Before you can access and work with 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);

Parameter Description

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.

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

Note: There are more available parameters, but the ones listed above are the most important.

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","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
?>
Closing a Connection

The connection will be closed as soon as the script ends. To close the connection before, use the mysql_close() function.

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

Back to Home
BizHat.com   Bookmark   Astrology   Chat Room   Classifieds   Computer   Downloads   Directory   Dating   Domain Tools   Education   eCards   Finance   Forums   Freelance Work   Free Hosting   Free Mail   Gallery   Games   Guest Book   Greeting Cards   Ham Radio   Health   Home Business   Hosting Tutorials   Hosting Directory   India   Jobs   Jokes   Kerala   Matrimonial   Music   Movies   News   News Letter   Recipes   Real Estate   Search   SMS   Tourist Guide   Top 100 Sites   Vote Us   Yellow Pages   Arthunkal Church   Site Map  

Google