mysqli::$error

mysqli_error

(PHP 5, PHP 7)

mysqli::$error -- mysqli_error — Returns a string description of the last error

说明

面向对象风格

string $mysqli->error;

过程化风格

mysqli_error ( mysqli $link ) : string

Returns the last error message for the most recent MySQLi function call that can succeed or fail.

参数

link

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

返回值

A string that describes the error. An empty string if no error occurred.

范例

Example #1 $mysqli->error example

面向对象风格

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if (!$mysqli->query("SET a=1")) {
    printf("Errormessage: %s\n", $mysqli->error);
}

/* 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")) {
    printf("Errormessage: %s\n", mysqli_error($link));
}

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

以上例程会输出：

Errormessage: Unknown system variable 'a'

参见

相关文章
php ibm db2 函数 returns a string containing the last sql statement error messagephp eio 函数 returns string describing the last error associated with a request resourcephp enchant 函数 returns the last error of the current spelling sessionphp informix 函数 returns error message of last informix callphp json 函数 returns the error string of the last json encode or json decode callphp maxdb 函数 returns a string description of the last connect errorphp maxdb 函数 returns a string description of the last errorphp maxdb 函数 returns a string description for last statement errorphp sqlsrv 函数 returns error and warning information about the last sqlsrv operation performedphp stomp 函数 returns a string description of the last connect errorphp gearmanclient returns an error string for the last error encounteredphp mysqli stmt returns a list of errors from the last statement executedphp mysqli stmt returns a string description for last statement errorphp mysqli stmt returns sqlstate error from previous statement operationphp 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 a string description of the last error
关注编程学问公众号