You can also find the error codes for for example MySQL 5.5 here: http://dev.mysql.com/doc/refman/5.5/en/error-handling.html
(PHP 5, PHP 7, PHP 8)
mysqli::$errno -- mysqli_errno — Returns the error code for the most recent function call
Stile orientato agli oggetti
Stile procedurale
Returns the last error code for the most recent MySQLi function call that can succeed or fail.
linkSolo nello stile procedurale: un identificatore restituito da mysqli_connect() o mysqli_init()
An error code value for the last call, if it failed. zero means no error occurred.
Example #1 $mysqli->errno example
Stile orientato agli oggetti
<?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();
?>Stile procedurale
<?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);
?>I precedenti esempi visualizzeranno:
Errorcode: 1193
You can also find the error codes for for example MySQL 5.5 here: http://dev.mysql.com/doc/refman/5.5/en/error-handling.html