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