commitTrans

The function commitTrans() commits a granular transaction. This function is not part of the smart transaction set, you must verify that all transactional statements within the transaction scope have completed correctly.

$conn->beginTrans();
 
$ok = $conn->execute($sql);
 
if ($ok) 
    $ok = $conn->execute($sql2);
 
if (!$ok) 
    $conn->rollbackTrans();
else 
    $conn->commitTrans();