<?php
$transaction = new Transaction();
try {
  $transaction->add($query1);
  $transaction->add($query2);
  $transaction->add($query3);
  // all three queries must be executed successfully
  $transaction->execute();
}
catch (DatabaseException $e) {
  $transaction->rollback();
  throw;
}
?>