PHP MySQLi mysqli_error_list()

mysqli_error_list()

The mysqli_error_list() function returns a list of errors for the most recent function call on a specific connection. Each error in the list contains the error number, description, and SQL state.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

// Intentionally incorrect query to populate the error list
mysqli_query($connection, "SELECT * FROM non_existent_table");

$errors = mysqli_error_list($connection);

// NOTE: The mysqli_error_list function returns an array of all errors.
// Because we used print_r() inside <pre> tags, we will see a nicely 
// formatted array structure on the screen, which contains the error number (errno), 
// the SQL state (sqlstate), and the text description (error) all at once.
if (!empty($errors)) {
    echo "<pre>";
    print_r($errors); echo "<br>";
    echo "</pre>";
} else {
    echo "No errors found.";
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is very useful when executing complex operations where multiple errors can occur simultaneously. Instead of a single description, we get a clear list. Test it at home like this:

It returns an empty array if there are no errors.

Each element in the list is an associative array with the keys: errno, error, and sqlstate.

Useful when developing advanced error logging systems.