PHP Manual
PrevNext

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.

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 */
$sth->rollBack();

/* Database connection is now back in autocommit mode */
?>
PrevHomeNext
PDO::prepareUpPDO::setAttribute