Redirect when mysql server is down

[Anon]

Hi,

I'd like to redirect my script to a HTML document when the MySQL server is down, without displaying the PHP error messages, such as "Can't connect to the database".
Basically, I want my visitors to see a nice HTML page instead of this PHP strange messages 🙂

I try "or die", but it doesn't work.

Anyone could help me ?

Thanx.

[Anon]

Use "@" in front of the function name, and the function dies returning null instead of error message.

From the manual, http://www.php.net/manual/html/features.error-handling.html

"All PHP expressions can also be called with the "@" prefix, which turns off error reporting for that particular expression. If an error occurred during such an expression and the track_errors feature is enabled, you can find the error message in the global variable $php_errormsg. "

[Anon]

Use something like this:

$link_id = @mysql_connect("host","user","pass") or die(header("Location: error.php?error=database"));

This has to be put at the before any headers are sent, though, before in your page. It'll redirect to an error page when it can't connect. You can have a generic error page, or customize it based on the $error that is passed to it.

---John Holmes...

[Anon]

..of if you've sent the header already..

$link_id = @mysql_connect("host","user","pass");
if (!$link_id) {
$errortype="database";
include "error.php";
exit;
}

[Anon]

many thanks for your help :-))
Ben