Timeout with mysql

dwolchon

I have a php file on my web server (Apache on linux) accessing a mysql server. On the off chance that the mysql server crashes and someone visits the site, I want to be able to write custom error pages explaining what is wrong, instead of those "Warning: blah blah" messages showing up on the page. I do now want to use connection_timeout() because it will not be supported in later versions of php. What can I do to find out if the script timed out looking for the server?

bastien

http://www.php.net/manual/en/features.connection-handling.php

may help

bastien

dwolchon

I checked that out, but it is not helpful. How does the connection_status() function know which mysql connection to report the status of? If I had multiple connections to different mysql servers, how would the function know which connection I was referring to?

jackansi

You can also try "or die ()" after your query. I think this would terminate your scripts execution as well, which may or may not be a good thing.

There is also the fact that just about everything in php can be bool as well as what its really intendend to do. Now I never tried it, but an "if" should work for you.

if ($dbq = mysql_query("select * from table")) {
echo "it worked";
}
else {
echo "it failed";
}

Taken another way:

if ($dbq = mysql_query("select * from table")) {
require('./dbsuccess.php');
}
else {
require('./dbfail.php');
}

You can then use the $dbq results just as if it was done without the "if"

Best of luck,
JackANSI