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.

Set parameter $ok to true to commit, false to rollback the transaction.

Return bool true if successful.

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