PHP Guide  

PHP Tutorials
Introduction
Variables
String Functions
Date Functions
Date Validation
Phone Validation
E-mail Validation
Using Cookies
Session Variables
Functions
Sending Emails
Connecting to MySQL
Using PHPMyAdmin
Simple MySQL Queries
PHP Tips

Connecting to MySQL database:

It is always a good practice to write the connection string for the database in a separate file and call it on each page where the the database is required. To know how to call the file see PHP Tips (Server Side Includes).

So we first create a file where we assign the values for your server, the database you want to connect,the user name and the password to variables. Let us save this file as conn.php

Now we can call

The syntax to connect to the server or Opening a database connectivity is

For the above example we would write

$strDB=mysql_connect($strServer,$struser,$strPwd);

To connect to the database the syntax is

mysql_select_db("Database Name",$strDB)

For the above example we would write

$database=mysql_select_db("strDatabase",$strDB)

The syntax for closing the Database connection is

mysql_close(Result Connection ID)

For the above example we would write

mysql_close($strDB)

On a whole the code would look like this

conn.php