PHP database pdo--03, using the ErrorInfo method to get PDO error message

When you actually use PDO to perform operations on a database, errors such as incorrect SQL statements can occur.

Two ways to report errors are given in the PDO object

$pdo->errorcode (); ---> Get the error code (it's a number)

$pdo->errorinfo (); ---> Get error messages (arrays)

The ErrorInfo method can be used directly in practical applications.

You can perform an error check on the PDO object after you have finished executing the SQL statement

if ($res= = =false        ) {$errMS$pdo-errorinfo (        ); Echo ' Error code: '. $errMS [0]. ' <br/> '. ' Error number: '. $errMS [1]. ' <br/> '. ' Error message: '. $errMS [2]. ' <br/> ';    }

$errMS = $pdo->errorinfo ();

$errMS is an array

$errMS [0] corresponds to the error code and $PDO->errorcode (); Same

$errMS [1] for error numbers

$errMS [2] Error details that correspond to MySQL console

PHP database pdo--03, using the ErrorInfo method to get PDO error message