Standard Connect

R4v

This probaly seems silly but im still learning php (trying to). The following is what I have been using to connect to database.. just wondering if there is standard (most used) format to follow.

Thanks in advance.

/* Mysql details. */
$conf['mysql_host'] = "somehost";
$conf['mysql_user'] = "someuser";
$conf['mysql_pass'] = "somepass";
$conf['mysql_db'] = "test";

/* Connect to database. */
mysql_connect ($conf['mysql_host'], $conf['mysql_user'], $conf['mysql_pass']); 
mysql_select_db($conf['mysql_db']);

shonuff

Here's how I do it... (the following is included in my "functions" file)

// Connection info
<?php
    $db_host     = "********";
    $db_login    = "********";
    $db_password = "********";
    $db_name     = "********";

// Nifty error function    

function showerror()
{
die("Error " . mysql_errno() . " : " . mysql_error());
 }
?>

Typical usage...

<?php
// Open db connection
if (!($conn = mysql_connect($db_host, $db_login, $db_password)))
   die("***Cannot connect to database:" . mysql_error());

// Selecting my database
if (!(mysql_select_db($db_name, $conn)))
   die("***Cannot select database:" . mysql_error());

$query = "SELECT blah blah FROM blah ORDER BY blah LIMIT blah";

// Run the query
if (!($result = @ mysql_query($query, $conn)))
   die("***Error running query:" . mysql_error());

// Closing db connection
if (!(mysql_close($conn)))
   die("***Error closing database:" . mysql_error());
?>

Something along those lines...

R4v

Thanks for that, it seems more complete. I like this..

// Nifty error function

function showerror()

🙂