Database alive?

Anon

Hi All,

I have apache and PHP running on one system and Mysql on another system, which are far from each other. Now i want to check whether the connection to Database is fine or not. In case i am unable to reach database, i want to redirect users for a static page. Please let me know how to check connection. I heard about mysql_ping. But it is very unclear.

Thanks in advance.

Anon

$c = mysql_connect(...);
if ( !$c ) {
// do redirection
}
// proceed with normal code

Anon

I used the following code...but even then i got the error message ...

code

<?php
$user="u";$host="h";$password="p";
$c = mysql_connect($host,$user,$password);
if($c)
{
echo("Connected");
}
else
{
echo("No connection");
}
?>

After 2 or 3 minutes i get the following error.
Warning: Can't connect to MySQL server on 'h' (145) in /home/users/www/test.php on line 3

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'h' (145) in /home/users/www/test.php on line 3

No connection

Is there a way not to print Warning?

Thanks

Anon

Can't you set the error reporting level somehow?

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