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: CODE 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!

Reply

id say this:

db.php


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


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

Enjoy!

 

 

 

Reply

Hmm, I'll try that, and I'll post the status.

Thanks for the help!

Reply

Another question -> another post

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

Reply

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.

Reply

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

Reply

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.

Reply

Gotcha. So the rest will continue to execute.

Thanks!

Reply