dump_debug_info

In this article, we will focus on the mysqli_error() and mysqli_report() functions in PHP, which are used to capture and manage error details for a MySQLi connection. We will provide you with an overview of these functions, how they work, and examples of their use.

Introduction to the mysqli_error() and mysqli_report() functions

The mysqli_error() and mysqli_report() functions are built-in functions in PHP that are used to capture error details for a MySQLi connection. Important: mysqli_report() allows you to configure how MySQLi handles errors (such as throwing exceptions or logging them), while mysqli_error() retrieves the error message from the last MySQLi operation. Note that mysqli_report() is global and affects all subsequent MySQLi calls in the script. These functions are essential for debugging MySQLi connections and monitoring connection status in modern PHP applications.

How to use the mysqli_error() and mysqli_report() functions

Using the mysqli_error() and mysqli_report() functions is very simple. You just need to call them on a valid MySQLi connection object. Here is an example:

How to use mysqli_error() and mysqli_report()?

<?php
// Configure error reporting behavior (global for this script)
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

try {
    $mysqli = mysqli_connect("localhost", "username", "password", "database");
} catch (mysqli_sql_exception $e) {
    die('Connection failed: ' . $e->getMessage());
}

// execute queries using the connection

// Check for errors after operations
if (mysqli_error($mysqli)) {
    echo 'Error details: ' . mysqli_error($mysqli);
}

mysqli_close($mysqli);
?>

In this example, we call the mysqli_connect() function to connect to a MySQL database with a username and password. We verify the connection before proceeding, then execute queries using the connection. Finally, we call mysqli_error() to capture any error details. The function returns a string containing the error message, or an empty string if no error occurred. We check the return value to ensure the operation succeeded. By default, error messages are returned directly in PHP, but you can also enable the MySQL general log on the server side to capture all queries and errors in a dedicated log file. You can verify the output by checking the PHP error log or the MySQL server log after execution.

Advanced usage

The mysqli_error() function can also be used in more advanced scenarios. For example, you can use the function to capture error details for specific MySQLi connections. Here is an example:

Advanced usage of PHP mysqli_error()

<?php
$mysqli1 = mysqli_connect("localhost", "username", "password", "database1");
$mysqli2 = mysqli_connect("localhost", "username", "password", "database2");

if ($mysqli1 === false || $mysqli2 === false) {
    die('Connection failed: ' . mysqli_connect_error());
}

// execute queries using the first connection

if (mysqli_error($mysqli1)) {
    echo 'Error details for connection 1: ' . mysqli_error($mysqli1);
}

// execute queries using the second connection

if (mysqli_error($mysqli2)) {
    echo 'Error details for connection 2: ' . mysqli_error($mysqli2);
}

mysqli_close($mysqli1);
mysqli_close($mysqli2);
?>

In this example, we create two MySQLi objects and connect to two different MySQL databases with a username and password. We can then execute queries using each connection. Finally, we call mysqli_error() for each connection to capture error details. Warning: Debug logging can cause significant performance overhead and may expose sensitive information. Always remove or disable these calls in production environments.

Conclusion

In conclusion, the mysqli_error() and mysqli_report() functions are useful tools for debugging MySQLi connections and seeing the status of the connection. By understanding how to use these functions and their advanced usage scenarios, you can take advantage of this feature to create powerful and flexible MySQLi queries in your PHP scripts.

Practice