DB_common::rollback() -- Rolls back the current transaction
Beschreibung
Rolls back the current transaction.
Rückgabewert
integer - DB_OK on success
or a DB_Error object on failure
Hinweise
Diese Methode kann nicht
statisch aufgerufen werden.
When using MySQL as your DBMS, transactions can only be used when the
tables in question use the InnoDB format.
Beispiel
Beispiel 39-1. Using rollback()
<?php
// Once you have a valid DB object named $db...
$db->autoCommit(false);
$db->query('INSERT INTO blah (a) VALUES (11)');
$res =& $db->query('SELECT b FROM blue');
if (DB::isError($res)) {
echo $res->getMessage() . "\n";
}
while ($res->fetchInto($row, DB_FETCHMODE_ORDERED)) {
if ($row[0] == 'problem') {
$db->rollback();
}
}
$res->free();
$db->query('DROP TABLE blah');
$db->commit();
?>
|
|
