DB_common::rollback() -- Rolls back the current transaction
Описание
Rolls back the current transaction.
Возвращаемое значение
integer - DB_OK on success
or a DB_Error object on failure
Заметка
Эта функция не должна вызываться статически.
When using MySQL as your DBMS, transactions can only be used when the
tables in question use the InnoDB format.
Пример
Пример 35-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();
?>
|
|
