PDO->rollBack()

Rolls back a transaction ()

PDO {
  bool rollBack();
}

Rolls back the current transaction, as initiated by PDO->beginTransaction(). It is an error to call this method if no transaction is active.

If the database was set to autocommit mode, this function will restore autocommit mode after it has rolled back the transaction.

Some databases, including MySQL, automatically issue an implicit COMMIT when a database definition language (DDL) statement such as DROP TABLE or CREATE TABLE is issued within a transaction. The implicit COMMIT will prevent you from rolling back any other changes within the transaction boundary.

Return Values

Returns TRUE on success or FALSE on failure.

Examples

Example 1769. Roll back a transaction

The following example begins a transaction and issues two statements that modify the database before rolling back the changes. On MySQL, however, the DROP TABLE statement automatically commits the transaction so that none of the changes in the transaction are rolled back.

copy to clipboard

<?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()

<?php //run this on your latest PHP let me know if it doesn't fail //to test this program u must run it twice at the same time in ie. two terminals //this program suposedly creates a new dbase with table name NodeNames and one field in it named NodeName //it then begins a transaction then attempts to read an element 'zTest' of field 'NodeName' which obv. doesn't exist, ignoring the returned errors //then it writes it(since it wasn't there) //then decides to rollBack the transaction and eventually try a new one //because rollBack doesn't really work(apparently) for some unknown reason, beginTransaction fails saying 'There is already an active transaction' $db = new PDO('sqlite:demlinks6.3sql',''/*user*/,''/*pwd*/); $db->exec('CREATE TABLE \'NodeNames\' ("NodeName" VARCHAR(10));'); $db->beginTransaction(); $getter="zTest"; $pgn = $db->prepare('SELECT * FROM \'NodeNames\' WHERE "NodeName" = :node13'); $pgn->bindParam(":node13", $getter, PDO::PARAM_STR); //read $pgn->execute();//execute above SELECT $ar=$pgn->FetchAll();//get array of results $writter="zTest"; $pnn=$db->prepare('INSERT INTO \'NodeNames\' ("NodeName") VALUES (:node14)'); $pnn->bindParam(":node14", $writter, PDO::PARAM_STR); //write $pnn->execute();//write it! echo "waiting..."; usleep(2000000); echo "done\n"; $db->rollBack();//this doesn't do it's job $db->beginTransaction();//here it fails, when running this program twice at the same time; 'There is already an active transaction' //unreachable: $db->commit(); ?>

PDO->rollBack()

Rolls back a transaction ()

Return Values

Examples

Example 1769. Roll back a transaction

Code Examples / Notes » pdo_rollback

Change Language