mysqli::$errno
PHP function
Edit on GitHub ✎
Returns the error code for the most recent function call
Description
Oop
intmysqli->errno
Procedural
mysqli_errno(mysqli $mysql): int
Returns the last error code for the most recent MySQLi function call that can succeed or fail.
Parameters
Return Values
An error code value for the last call, if it failed. 0 means no error occurred.
Examples
$mysqli->errno example
Oop
php
<?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("Errorcode: %d\n", $mysqli->errno);
}
/* close connection */
$mysqli->close();
?>Procedural
php
<?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("Errorcode: %d\n", mysqli_errno($link));
}
/* close connection */
mysqli_close($link);
?>Outputs
output
Errorcode: 1193