Php Code To Detect When Mysql Db Is Down? a way to create a var if db is down

[snlildude87 0]

Recently, I recoded a part of my site so that it uses a MySQL database to store information instead of on a text file. Because my site receives a lot of traffic and it's on a shared hosting environment, the DB could potentially go down. Since I don't want to lose my visitors, I want to know if there is a way to tell when the MySQL DB is down. I know that I could add a die function along with the mysql_connect function:

mysql_connect("localhost", "username", "passwordl") or die("Something here.");

I want it to do more than just print a line stating the problem--I want it to store a variable. Is there a way to do such thing?

Thanks!

[HmmZ 0]

id say this:

 

db.php

$sql_conn = mysql_connect("host","user","pass");if(!$sql_conn){$db_status = 0;} else {$db_status = 1;}

Checks if a mysql connection was established, stored as a "0" or "1"

 

Next step would be further developing that variable in the page where you want to show the status:

 

Any other page

include("db.php");#if db is onlineif($db_status=="1"){$db_status = "<img src='images/online.gif' border='0'>";}#else db is downelse {$db_status = "<img src='images/offline.gif' border='0'>";}print "Database Status: $db_status";

configure it to your own liking, once db.php is included you can make the $db_status variable anything you want

 

Enjoy!

[snlildude87 0]

Hmm, I'll try that, and I'll post the status.Thanks for the help!

[snlildude87 0]

Another question -> another postI have another question. Is there a way for MySQL and PHP to continue executing if the MySQL DB goes down?

[HmmZ 0]

when you perform mysql querys and other things that call for the database, you seem to be always using die()?

not needed, just store the query or whatever it is your using in a variable and check the query with an if...else statement.

 

Instead of using:

mysql_query("SELECT * FROM table") or die(mysql_error());

you should do:

$qry = mysql_query("SELECT * FROM table");

if(!$qry){$db_status = 0;} else {$db_status = 1;}

 

Continued from where i left off

 

Hope this helps.

[snlildude87 0]

Right, but say the database is down...will the rest of my script still execute or will it stop right there?

[Unregistered 015 0]

If you used this:$qry = mysql_query("SELECT * FROM table");if(!$qry){$db_status = 0;} else {$db_status = 1;}[/code]then the part in else {} will execute and everything below that.Unless, you put some exit code in that else statement, of course.

[snlildude87 0]

If you used this:

 

$qry = mysql_query("SELECT * FROM table");

 

if(!$qry){$db_status = 0;} else {$db_status = 1;}[/code]

 

then the part in else {} will execute and everything below that.

 

Unless, you put some exit code in that else statement, of course.

216145[/snapback]

Gotcha. So the rest will continue to execute.

 

Thanks!