新的mysqli():如何拦截“无法连接"错误? [英] new mysqli(): how to intercept an 'unable to connect' error?
问题描述
我正在这样做(是的,我使用了错误的连接数据,这将导致连接错误)
try {
$connection = new mysqli('localhost', 'my_user', 'my_password', 'my_db') ;
} catch (Exception $e ) {
echo "Service unavailable";
exit (3);
}
但是PHP正在这样做php_warning:
But PHP is doing this php_warning:
mysqli :: mysqli():(28000/1045):用户'my_user'@'localhost'的访问被拒绝(使用密码:是)
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 ?
推荐答案
您需要告诉mysqli抛出异常:
You need to tell mysqli to throw exceptions:
mysqli_report(MYSQLI_REPORT_STRICT);
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...
exit;
}
现在,您将捕获异常,然后可以从那里接收异常.
Now you will catch the exception and you can take it from there.
这篇关于新的mysqli():如何拦截“无法连接"错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!