INGRES_ERRSQLSTATE(3) 1 INGRES_ERRSQLSTATE(3)
ingres_errsqlstate - Get the last SQLSTATE error code generated
SYNOPSIS
string ingres_errsqlstate ([resource $link])
DESCRIPTION
Returns a string containing the last SQLSTATE, or NULL if no error has occurred.
If a $link resource is passed to ingres_errsqlstate(3), it returns the last error recorded for the link. If no link is passed, then
ingres_errsqlstate(3) returns the last error reported using the default link.
The function, ingres_errsqlstate(3), should always be called after executing any database query. Calling another function before
ingres_errsqlstate(3) is called will reset or change any error message from the last Ingres function call.
PARAMETERS
o $link
- The connection link identifier
RETURN VALUES
Returns a string containing the last SQLSTATE, or NULL if no error has occurred.
EXAMPLES
Example #1
Get the last SQLSTATE error code generated
<?php
$link = ingres_connect($database, $user, $password);
$result = ingres_query($link, "select * from table");
$error_sqlstate = ingres_errsqlstate($link);
if (!is_null($error_sqlstate)) {
echo "An error occurred - " . $error_sqlstate;
}
?>
SEE ALSO
ingres_errno(3), ingres_error(3), ingres_next_error(3).
PHP Documentation Group INGRES_ERRSQLSTATE(3)