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
mysqli::$errno
mysqli_errno
(PHP 5, PHP 7, PHP 8)
mysqli::$errno -- mysqli_errno — Returns the error code for the most recent function call
Descrizione
Stile orientato agli oggetti
Stile procedurale
Returns the last error code for the most recent MySQLi function call that can succeed or fail.
Elenco dei parametri
-
link -
Solo nello stile procedurale: un identificatore restituito da mysqli_connect() o mysqli_init()
Valori restituiti
An error code value for the last call, if it failed. zero means no error occurred.
Esempi
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
Vedere anche:
- mysqli_connect_errno() - Returns the error code from last connect call
- mysqli_connect_error() - Returns a description of the last connection error
- mysqli_error() - Returns a string description of the last error
- mysqli_sqlstate() - Returns the SQLSTATE error from previous MySQL operation
add a note
User Contributed Notes 1 note
erwin at transpontine dot com ¶
11 years ago
