Can You Store PHP Errors in a Database Instead of a Log File?

Can PHP Errors Be Written to a Database Instead of an Error Log File?

PHP errors are typically logged to the standard error_log file, but it may be desirable to have them stored in a database instead for easier tracking and analysis. While this is not directly possible without creating a custom error handler, it can be achieved with a single global change.

Implementing a Custom Error Handler

The key to controlling how errors are handled is to create a custom error handler. This can be done using the set_error_handler() function, which takes a callback function as its argument. The callback function should have the following signature:

function error_handler($errno, $errstr, $errfile, $errline) {}

Inside the callback function, you can determine how each error should be handled, including whether to log it to a database.

Example Error Logging to MySQL

The following code shows an example of a custom error handler that logs PHP errors to a MySQL database:

function myErrorHandler($errno, $errstr, $errfile, $errline)
{
    // Establish connection to MySQL database
    $conn = mysqli_connect("hostname", "username", "password", "database");

    // Prepare SQL query to log error
    $query = "INSERT INTO error_log (number, string, file, line) VALUES (?, ?, ?, ?)";
    $stmt = mysqli_prepare($conn, $query);

    // Bind parameters to SQL query
    mysqli_stmt_bind_param($stmt, "isss", $errno, $errstr, $errfile, $errline);

    // Execute SQL query to log error
    mysqli_stmt_execute($stmt);

    // Close database connection
    mysqli_close($conn);

    // Don't execute PHP internal error handler
    return true;
}

// Set user-defined error handler
$old_error_handler = set_error_handler("myErrorHandler");

After setting the user-defined error handler, all PHP errors will be routed through your custom error handling logic, including logging to the MySQL database.

The above is the detailed content of Can You Store PHP Errors in a Database Instead of a Log File?. For more information, please follow other related articles on the PHP Chinese website!