ingres_errsqlstate

(PECL ingres >= 1.1.0)
Get the last SQLSTATE error code generated
string ingres_errsqlstate ([ resource $link ] )

Returns a string containing the last SQLSTATE, or NULL if no error has occurred.

If a link resource is passed to ingres_errsqlstate(), it returns the last error recorded for the link. If no link is passed, then ingres_errsqlstate() returns the last error reported using the default link.

The function, ingres_errsqlstate(), should always be called after executing any database query. Calling another function before ingres_errsqlstate() is called will reset or change any error message from the last Ingres function call.

Parameters:
link

The connection link identifier

Returns:

Returns a string containing the last SQLSTATE, or NULL if no error has occurred.

Examples:
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() -

ingres_error() -

ingres_next_error() -

doc_php
2016-02-24 16:16:58
Comments
Leave a Comment

Please login to continue.