|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  ibase_trans
Begin a transaction
(PHP 4, PHP 5)
Code Examples / Notes » ibase_transjon
When using transactions, you must execute queries using the transaction identifier as the link_identifier in ibase_query. Example: $db = ibase_connect( ... ); $tr = ibase_trans(); $result = ibase_query($tr, $sql1); $result = ibase_query($tr, $sql2); ibase_rollback($tr); You must use ibase_query($tr, $sql1). Calling ibase_query($db, $sql1) will not allow you to roll back - it will be commited when the script finishes executing. aaron brundle
Example of using ibase_trans with ibase_prepare and ibase_execute: $dbh = ibase_connect( ... ); $sql = " ... "; $trans = ibase_trans( IBASE_DEFAULT,$dbh ); $sth = ibase_prepare( $trans, $sql ); $res = ibase_execute( $sth, $params_if_any ); if ($res == false) { //log failure if you want } ibase_commit($trans); //free if needed ibase_free_query($sth); unset($res); |
Change Language
ibase_add_user ibase_affected_rows ibase_backup ibase_blob_add ibase_blob_cancel ibase_blob_close ibase_blob_create ibase_blob_echo ibase_blob_get ibase_blob_import ibase_blob_info ibase_blob_open ibase_close ibase_commit_ret ibase_commit ibase_connect ibase_db_info ibase_delete_user ibase_drop_db ibase_errcode ibase_errmsg ibase_execute ibase_fetch_assoc ibase_fetch_object ibase_fetch_row ibase_field_info ibase_free_event_handler ibase_free_query ibase_free_result ibase_gen_id ibase_maintain_db ibase_modify_user ibase_name_result ibase_num_fields ibase_num_params ibase_param_info ibase_pconnect ibase_prepare ibase_query ibase_restore ibase_rollback_ret ibase_rollback ibase_server_info ibase_service_attach ibase_service_detach ibase_set_event_handler ibase_timefmt ibase_trans ibase_wait_event |
