downloads | documentation | faq | getting help | mailing lists | licenses | wiki | reporting bugs | php.net sites | conferences | my php.net

search for in the

ibase_wait_event> <ibase_set_event_handler
[edit] Last updated: Fri, 17 May 2013

view this page in

ibase_trans

(PHP 5)

ibase_transInizia una transazione

Descrizione

int ibase_trans ([ int $trans_args [, int $link_identifier ]] )

Inizia una transazione.



ibase_wait_event> <ibase_set_event_handler
[edit] Last updated: Fri, 17 May 2013
 
add a note add a note User Contributed Notes ibase_trans - [3 notes]
up
1
chAlx
1 year ago
Note that on some platforms ibase_trans($dbh), ibase_trans(IBASE_DEFAULT, $dbh) and ibase_trans($dbh, IBASE_DEFAULT) are not the same, but will run without errors in most cases.
up
1
jon at tgpsolutions dot com
10 years ago
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.
up
-2
Aaron Brundle
7 years ago
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);

 
show source | credits | stats | sitemap | contact | advertising | mirror sites