PDO::rollBack

(no version information, might be only in CVS)

PDO::rollBack --  Rolls back a transaction

说明

bool PDO::rollBack ( void )

警告

本函数是实验性的。本函数的行为,包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随 PHP 以后的发布而改变。使用本函数风险自担。

When issued against databases that support transactions, PDO::rollBack() rolls back any work in progress 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.

例子 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 */
?>

参见

PDO::beginTransaction()
PDO::commit()