Connecting to a remote database

[Anon]

I am running my own database for a webpage that I have. The php script connects via an IP addess. It works fine, but I am scared that if something happens to the box that is running the database crashes, I will have a horrible looking webpage because of MySQL errors.

I was wondering if there is a way to build an if statement that goes something like this:

$link = mysql_connect(...)
if ($link == TRUE)
{
..
...
...
}
else
{
print "No database access right now";
}

Any suggestions would be greatly appreciated!

Thanks,

Adam Cavaliere

[rwilkerson]

Something like this works great for me:

$dsn = dsnConnect ( 'datasource' ); // call function to access database

if ( !$dsn ) { // no connection was made
include 'error.php';
die ( 'Database is currently unavailable'); // throw error
}

[Anon]

What I do is something similar to this:

function db_crash() {
die("Database is down at the moment");
}

$link = mysql_connect(...) or db_crash();

Takes care of everything on one line 🙂
And you can customize the db_crash() function to do whatever you need it to do.

-JoshB