DB_common::rollback() – Rolls back the current transaction


mixed rollback ( )


Rolls back the current transaction.

Return value

integer - DB_OK on success or a DB_Error object on failure


Possible PEAR_Error values
Error code Error message Reason Solution
every other error code   Database specific error Check the database related section of PHP-Manual to detect the reason for this error.


This function can not be called statically.

When using MySQL as your DBMS, transactions can only be used when the tables in question use the InnoDB format.


Using rollback()

// Once you have a valid DB object named $db...


$db->query('INSERT INTO blah (a) VALUES (11)');

$res =& $db->query('SELECT b FROM blue');
if (
DB::isError($res)) {
$res->getMessage() . "\n";
while (
$res->fetchInto($rowDB_FETCHMODE_ORDERED)) {
    if (
$row[0] == 'problem') {

$db->query('DROP TABLE blah');
Formats input so it can be safely used as a literal (Previous) Sets the default fetch mode (Next)
Last updated: Sat, 16 Feb 2019 — Download Documentation
Do you think that something on this page is wrong? Please file a bug report.
View this page in:
  • English

User Notes:

There are no user contributed notes for this page.