(PHP 5, PHP 7)
mysqli::$error -- mysqli_error — Returns a string description of the last error
Object oriented style
Procedural style
Returns the last error message for the most recent MySQLi function call that can succeed or fail.
linkProcedural style only: A link identifier returned by mysqli_connect() or mysqli_init()
A string that describes the error. An empty string if no error occurred.
Example #1 $mysqli->error example
Object oriented style
<?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();
?>
Procedural style
<?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);
?>
The above examples will output:
Errormessage: Unknown system variable 'a'