PDO::rollBack – Rolling Back a Transaction in PHP
The article explains how the PHP PDO::rollBack() method aborts the current transaction, restores autocommit mode when needed, outlines its parameter‑less signature, return values, and provides a complete code example demonstrating transaction handling and rollback behavior.
PDO::rollBack() is a PHP method that rolls back the current database transaction and, if the database was in autocommit mode, restores autocommit after the rollback.
If the database is set to autocommit, the method will re‑enable it after rolling back. Some databases (e.g., MySQL) perform an implicit commit when DDL statements such as DROP TABLE are executed inside a transaction, which cannot be rolled back.
Parameters
This method takes no parameters.
Return value
Returns TRUE on success or FALSE on failure.
Example
beginTransaction();
/* Change database schema and data */
$sth = $dbh->exec("DROP TABLE fruit");
$sth = $dbh->exec("UPDATE dessert SET name = 'hamburger'");
/* Detect error and roll back changes */
$dbh->rollBack();
/* At this point the connection returns to autocommit mode */
?>Laravel Tech Community
Specializing in Laravel development, we continuously publish fresh content and grow alongside the elegant, stable Laravel framework.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.