PHP MySQLi mysqli_sqlstate() - Standardized Error Codes

mysqli_sqlstate()

The mysqli_sqlstate() function returns the SQLSTATE code for the last executed operation. This code consists of five characters. The string "00000" means that the operation did not trigger any errors.

EXAMPLE

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

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

if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Attempt to create a table that already exists in the database to intentionally trigger an error
$table = "CREATE TABLE test (id INT)";

if (!mysqli_query($connection, $table)) {
    // NOTE: mysqli_sqlstate() returns a standardized 5-character ANSI SQL code.For a "Table already exists" 
    // error, this function will return the code 42S01. The advantage is that this code is consistent across 
    // MySQL, Oracle, and SQL Server, which facilitates application portability.
    echo "SQLSTATE error: " . mysqli_sqlstate($connection);
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: Unlike mysqli_error(), which returns an error description in a human-readable format, SQLSTATE codes are standardized according to ANSI SQL and ODBC standards. This allows your application to more easily recognize specific types of errors, regardless of the language settings on the server.

Returns a five-character string (e.g., "42S01").

The code "00000" indicates success with no errors.

Standardized according to ANSI SQL and ODBC specifications.