odbc_error()
(PHP 4 >= 4.0.5, PHP 5, PHP 7)
Get the last error code
说明
odbc_error([resource $connection_id]): string
Returns a six-digit ODBC state, or an empty string if there has been no errors.
参数
- $connection_id
ODBC 连接标识符,详见odbc_connect()。
返回值
If$connection_idis specified, the last state of that connection is returned, else the last state of any connection is returned.
This function returns meaningful value only if last odbc query failed(i.e.odbc_exec() returned FALSE
).
参见
odbc_errormsg()
Get the last error messageodbc_exec()
Prepare and execute an SQL statement
Using IBM DB2 V7.1 and MS SQL Server 7 ODBC database connections. Print the result of odbc_error() or odbc_errormsg() after each call to an odbc_ function that gives no error and, sooner or later, you'll get garbage instead of a blank string!
On persistent connections, a failed T-SQL will allow odbc_error and odbc_errormsg to return the error, but a subsequent successful T-SQL will not clear the error. Is it a bug?
If you use an argument, make sure its the CONNECTION_ID and not the RESULT_ID. Testing the result can return a null string or sometimes a garbage string. # -- Example code -- $rs = odbc_exec($dbc, $sql); #this is wrong but won't error out until #you demo the page for a client! if (odbc_error($rs)) die(...); #these work if (odbc_error()) die(...); if (odbc_error($dbc)) die(...);
I have use this function, its very simple and cute. with IBM DB2 <?php // you must set the connection first if (odbc_error()) { echo odbc_errormsg($conn); } // if you want to show the perfect error message // then format it using string functions. ?> Have a good day!