|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg ibase_trans
Begin a transaction
(PHP 4, PHP 5)
Begins a transaction.
Note:
The behaviour of this function has been changed in PHP 5.0.0. The first call to ibase_trans() will not return the default transaction of a connection. All transactions started by ibase_trans() will be rolled back at the end of the script if they were not committed or rolled back by either ibase_commit() or ibase_rollback().
Note:
In PHP 5.0.0. and up, this function will accept multiple trans_args and link_identifier arguments. This allows transactions over multiple database connections, which are committed using a 2-phase commit algorithm. This means you can rely on the updates to either succeed in every database, or fail in every database. It does NOT mean you can use tables from different databases in the same query! If you use transactions over multiple databases, you will have to specify both the link_id and transaction_id in calls to ibase_query() and ibase_prepare(). 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 |
