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

by

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.

More Related Contents:

  1. Commands out of sync; you can’t run this command now
  2. Object of class mysqli_result could not be converted to string
  3. SELECT COUNT(*) AS count – How to use this count
  4. Mysqli update throwing Call to a member function bind_param() error [duplicate]
  5. mysqli bind_param() expected to be a reference, value given
  6. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  7. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  8. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  9. Call to a member function execute() on boolean in [duplicate]
  10. Mysql No connection could be made because the target machine actively refused it
  11. SSL operation failed with code 1: dh key too small
  12. Can’t pass mysqli connection in session in php
  13. PHP Fatal error: Call to undefined function mysqli_stmt_get_result()
  14. how to bind multiple parameters to MySQLi query [closed]
  15. mysqli ignoring the first row in a table
  16. Returning Multiple Rows with MySqli and Arrays
  17. How to connect to MySQL database in PHP using mysqli extension?
  18. mySQLi prepared statement unable to get_result()
  19. Bind Param with array of parameters
  20. mysqli_select_db() expects parameter 1 to be mysqli, string given
  21. What does the mysqli_error() expects parameter 1 to be mysqli, null given mean?
  22. Mysqli prepared statement column with variable [duplicate]
  23. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  24. Using PHP to execute multiple MYSQL Queries
  25. Mysqli prepared statements build INSERT query dynamically from array
  26. Call to undefined function mysqli_result::num_rows()
  27. Is using prepared statements necessary? [duplicate]
  28. How to run multiple insert query in SQL using PHP in one go?
  29. mysqli persistent connection
  30. Create mysql trigger via PHP?

Leave a Comment