mysqli::$error_list

mysqli_error_list

(PHP 5 >= 5.4.0)

mysqli::$error_list -- mysqli_error_list — Returns a list of errors from the last command executed

说明

面向对象风格

array $mysqli->error_list ;

过程化风格

array mysqli_error_list ( mysqli $link )

Returns a array of errors for the most recent MySQLi function call that can succeed or fail.

参数

link: 仅以过程化样式：由 mysqli_connect() 或 mysqli_init() 返回的链接标识。

返回值

A list of errors, each as an associative array containing the errno, error, and sqlstate.

范例

Example #1 $mysqli->error_list example

面向对象风格

  <?php
$mysqli  = new  mysqli ( "localhost" ,  "nobody" ,  "" );

 
 if ( mysqli_connect_errno ()) {
     printf ( "Connect failed: %s\n" ,  mysqli_connect_error ());
    exit();
}

if (! $mysqli -> query ( "SET a=1" )) {
     print_r ( $mysqli -> error_list );
}

 
 $mysqli -> close ();
 ?>

过程化风格

  <?php
$link  =  mysqli_connect ( "localhost" ,  "my_user" ,  "my_password" ,  "world" );

 
 if ( mysqli_connect_errno ()) {
     printf ( "Connect failed: %s\n" ,  mysqli_connect_error ());
    exit();
}

if (! mysqli_query ( $link ,  "SET a=1" )) {
     print_r ( mysqli_error_list ( $link ));
}

 
 mysqli_close ( $link );
 ?>

以上例程会输出：

Array
(
    [0] => Array
        (
            [errno] => 1193
            [sqlstate] => HY000
            [error] => Unknown system variable 'a'
        ))

参见

mysqli_connect_errno() - Returns the error code from last connect call
mysqli_connect_error() - Returns a string description of the last connect error
mysqli_error() - Returns a string description of the last error
mysqli_sqlstate() - Returns the SQLSTATE error from previous MySQL operation