php and database

Hello everyone,

I am new in PHP. I want to know how to establish connection between PHP and any database, Please guide me if you can...

In Anticipation....

 

All right nice info from that site
but can anybody let me know something in your own language for the same topic ?

Thanks.

 

well... is simple. to estabish a mysql connection use:

PHP:

mysql_connect("server","username","password")


to select a database:

PHP:

mysql_select_db("db_name");


to perform a mysql query:

PHP:

mysql_query("query string");


 

First you need to make a database from your admin panel. (hope you know to do that)

Then the following script would give the basic concept of connecting:

PHP:

<?php

$username = "your_db_username";
$password = "your_db_password";
$database = "your_database_name";
$host = "your_host_address";

$db_handle = mysql_connect($host, $username, $password);
$db_found = mysql_select_db($database, $db_handle);

if($db_found){
     print "Auuraah You sucessfully connected!";
     mysql_close($db_handle);
}else{
     print "ahh Try Again!!";
}
?>