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 sqlstate returned by the last connection attemptphp ibm db2 函数 returns the last connection error message and sqlcode valuephp ibm db2 函数 returns a string containing the last sql statement error messagephp eio 函数 returns string describing the last error associated with a request resourcephp informix 函数 returns error code of last informix callphp json 函数 returns the error string of the last json encode or json decode callphp maxdb 函数 returns the error code from last connect 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 socket 函数 returns the last error on the socketphp sqlite 函数 returns the textual description of an error codephp stomp 函数 returns a string description of the last connect errorphp gearmanclient returns an error string for the last error encounteredphp mysqli stmt returns the error code for the most recent statement callphp mysqli stmt returns a string description for last statement errorphp mysqli returns the error code from last connect callphp mysqli returns a string description of the last connect errorphp mysqli returns a string description of the last errorphp mysqlnduhconnection returns a string description of the last error
关注编程学问公众号