Php/docs/function.ingres-errsqlstate

来自菜鸟教程
跳转至:导航、​搜索

ingres_errsqlstate

(PECL ingres >= 1.1.0)

ingres_errsqlstateGet the last SQLSTATE error code generated


说明

ingres_errsqlstate ([ resource $link ] ) : string

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.


参数

link
The connection link identifier


返回值

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


范例

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;}?>

参见