mysqli::$error_list

mysqli_error_list

(PHP 5 >= 5.4.0, PHP 7)

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

说明

面向对象风格

array $mysqli->error_list;

过程化风格

mysqli_error_list ( mysqli $link ) : array

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", "");

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

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

/* close connection */
$mysqli->close();
?>

过程化风格

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

/* check connection */
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));
}

/* close connection */
mysqli_close($link);
?>

以上例程会输出：

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

)

参见

相关文章
php ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp maxdb 函数 returns the error code from last connect callphp maxdb 函数 returns the number of warnings from the last query for the given linkphp mssql 函数 returns the last message from the serverphp session pgsql 函数 returns number of errors and last error messagephp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp sybase 函数 returns the last message from the serverphp mongodb driver monitoring commandstartedevent returns the database on which the command was executedphp mongodb driver monitoring commandstartedevent returns the server on which the command was executedphp mongodb driver monitoring commandsucceededevent returns the server on which the command was executedphp mysqli stmt returns the total number of rows changed deleted or inserted by the last executed statementphp mysqli stmt returns a list of errors from the last statement executedphp mysqli returns the error code from last connect callphp mysqli returns a string description of the last connect errorphp mysqli returns a list of errors from the last command executedphp mysqli returns a string description of the last errorphp mysqli returns the number of warnings from the last query for the given linkphp mysqlnduhconnection returns the number of warnings from the last query for the given linkphp soapclient returns the soap headers from the last requestphp soapclient returns the soap headers from the last response
关注编程学问公众号