PDO::rollBack
(no version information, might be only in CVS)
PDO::rollBack --
Rolls back a transaction
Description
bool
PDO::rollBack ( void )
| Warning |
This function is
EXPERIMENTAL. The behaviour of this function, the
name of this function, and anything else documented about this
function may change without notice in a future release of PHP.
Use this function at your own risk. |
When issued against databases that support transactions,
PDO::rollBack() rolls back any work in progress and
and returns the connection state to autocommit mode.
You must issue PDO::beginTransaction() to set the
connection state to manual commit mode before issuing
PDO::rollBack() has any effect.
Examples
Example 1. Roll back a transaction
<?php
/* Begin a transaction, turning off autocommit */
$dbh->beginTransaction();
/* Change the database schema and data */
$sth = $dbh->exec("DROP TABLE fruit");
$sth = $dbh->exec("UPDATE dessert
SET name = 'hamburger'");
/* Recognize mistake and roll back changes */
$dbh->rollBack();
/* Database connection is now back in autocommit mode */
?>
|
|
See Also
| PDO::beginTransaction() |
| PDO::commit() |