ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
<- v5:userguide:learn_multidatabase:connections|Multiple Connections ^ v5:userguide:userguide_index|List Of Tutorials ^  ->
~~NOTOC~~
====== Synchronizing Transactions ======
In databases that support transactions, we can use smart transactions to synchronize the transactional status of multiple connections. 

Note that the commonly used table format **//MyIsam//** in MySQL is not a transactional table and cannot be controlled in this way.

<code php>
include 'adodb/adodb.inc.php';  # load code common to ADOdb
$conn1 = adoNewConnection('mysqli');  # create a mysql connection
$conn2 = adoNewConnection('oci8');  # create a oracle connection
 
$conn1->connect($server, $userid, $password, $database);
$conn2->connect(false, $ora_userid, $ora_pwd, $oraname);

$conn1->startTrans();
$conn2->startTrans();

$conn1->Execute('insert ...');
$conn2->Execute('update ...');
</code>
 We now check the status of both connections using the [[v5:reference:connection:hasFailedtrans|hasFailedTrans()]] method before committing the transaction. This will indicate if any of the executed statements has failed to complete.
<code php>
if (!$conn1->hasFailedTrans()
&& !$conn2->hasFailedTrans())
{
    $conn1->completeTrans();
    $conn2->completeTrans();
}
</code> 
<WRAP info center 300px>
**End Of Lesson**
</WRAP>