Mastering PHP 7

Error handling

Handling errors around mysqli is relatively easy as we can use a simple try...catch block, as follows:

<?phpmysqli_report(MYSQLI_REPORT_ALL);try {   $mysqli = new mysqli('127.0.0.1', 'root', 'mL08e!Tq', 'sakila');} catch (Throwable $t) {   exit($t->getMessage());}

Ideally, we would want to use mysqli_sql_exception for more targeted MySQL exceptions-only handling:

<?phpmysqli_report(MYSQLI_REPORT_ALL);try {  $mysqli = new mysqli('127.0.0.1', 'root', 'mL08e!Tq', 'sakila');} catch (mysqli_sql_exception $e) {  exit($e->getMessage());}

We can pass one of the following report levels to the mysqli_report() function:

• MYSQLI_REPORT_INDEX: This reports if a bad index or no index at all was used in a query
• MYSQLI_REPORT_ERROR: This reports ...