realtebo realtebo - 1 year ago 47
PHP Question

new mysqli(): how to intercept an 'unable to connect' error?

I'm doing this (yes, I'm using wrong connection data, it's to force a connection error )

26 try {
27 $connection = new mysqli('localhost', 'my_user', 'my_password', 'my_db') ;
28 } catch (Exception $e ) {
29 echo "Service unavailable";
30 exit (3);
31 }

But PHP is doing this php_warning:

mysqli::mysqli(): (28000/1045): Access denied for user 'my_user'@'localhost' (using password: YES)

In the example I'm using wrong connection data to force a connection error, but in the real world the database could be down, or the network could be down... etc..

Question: Is there a way, without suppressing warnings, to intercept a problem with the database connection ?

Answer Source

You need to tell mysqli to throw exceptions:


try {
     $connection = new mysqli('localhost', 'my_user', 'my_password', 'my_db') ;
} catch (Exception $e ) {
     echo "Service unavailable";
     echo "message: " . $e->message;   // not in live code obviously...

Now you will catch the exception and you can take it from there.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download