Hi all this is Smith,
Can any one tell me how to connect a database with PHP. I need basic steps and program code to connect database in PHP.

Are you talking about MySQL specifically?

PHP I'm assuming MySQL...

PHP How do I post PHP blocks?

<?php
$host = ''; //Hostname prob localhost
$user = ''; //Username for database
$pass = ''; //Password for database
$db = ''; //The Database Name...

// This will determine if the DB conection was successful....
if(connectMySQL($host,$user,$pass,$db) != FALSE)
    { // If its successful....
    echo('Good to go!');
    } else { // If not, then halt the script but not before we let the user know.
    echo('We got some problems!');
    die();
    }
////////
//
//
//
//
// Put your content here!
//
//
//
//
////////

// Put your functions at the bottom.
function conntectMySQL($host,$user,$pass,$db)
    { // This function combines the MySQL connect and DB select functions built-into php.
    $link = mysql_connect($host, $user, $pass);
    if(isset($link))
        {
        $db_sel = mysql_select_db($db);
        if(isset($db_sel))
            {
            return $db_sel;
            } else {
            return FALSE;
            }
        } else {
        return FALSE;
        }
    }

mysql_close(); // ALWYAS ALWAYS ALWAYS RUN THIS AT THE END OF THE SCRIPT.
?>

i asked about MySql only. Thank you

Smith ...
Danny has the correct answer to your question.
If that's not what you wanted, let us know.

Research PEAR MDB2 - it's the best database connection component available for PHP. It's equivalent to Perl DBI.