How to Connect Databse With PHP

Smith · June 23 '09, 07:59 AM (#1)

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.

**mlseim** · June 23 '09, 03:39 PM (#2)

Are you talking about MySQL specifically?

Danny[MLWA] · June 23 '09, 06:05 PM (#3)

PHP I'm assuming MySQL...

PHP Code:


			
<?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.
?>

Smith · June 23 '09, 11:31 PM (#4)

i asked about MySql only. Thank you

**mlseim** · June 24 '09, 03:40 PM (#5)

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

smoseley · June 24 '09, 10:39 PM (#6)

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