|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  odbc_error
Get the last error code
(PHP 4 >= 4.0.5, PHP 5)
Examples ( Source code ) » odbc_error
Code Examples / Notes » odbc_errorsergio sartori
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! aaronbair
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(...); sunil_limje
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! |
Change Language
odbc_autocommit odbc_binmode odbc_close_all odbc_close odbc_columnprivileges odbc_columns odbc_commit odbc_connect odbc_cursor odbc_data_source odbc_do odbc_error odbc_errormsg odbc_exec odbc_execute odbc_fetch_array odbc_fetch_into odbc_fetch_object odbc_fetch_row odbc_field_len odbc_field_name odbc_field_num odbc_field_precision odbc_field_scale odbc_field_type odbc_foreignkeys odbc_free_result odbc_gettypeinfo odbc_longreadlen odbc_next_result odbc_num_fields odbc_num_rows odbc_pconnect odbc_prepare odbc_primarykeys odbc_procedurecolumns odbc_procedures odbc_result_all odbc_result odbc_rollback odbc_setoption odbc_specialcolumns odbc_statistics odbc_tableprivileges odbc_tables |
