PHP.nl

mysql_errno

mysql_errno

Returns the numerical value of the error message from previous MySQL operation

Waarschuwing: > mysqli_errno``PDO::errorCode

int **mysql_errno** resource $link_identifier

Returns the error number from the last MySQL function.

Errors coming back from the MySQL database backend no longer issue warnings. Instead, use to retrieve the error code. Note that this function only returns the error code from the most recently executed MySQL function (not including and ), so if you want to use it, make sure you check the value before calling another MySQL function. mysql_errno``mysql_error``mysql_errno

Returns the error number from the last MySQL function, or (zero) if no error occurred. 0

Voorbeeld: example

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");

if (!mysql_select_db("nonexistentdb", $link)) {
    echo mysql_errno($link) . ": " . mysql_error($link). "\n";
}

mysql_select_db("kossu", $link);
if (!mysql_query("SELECT * FROM nonexistenttable", $link)) {
    echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
}
?>
1049: Unknown database 'nonexistentdb'
1146: Table 'kossu.nonexistenttable' doesn't exist

mysql_errorMySQL error codes