mixed commit (
)
Commits the current transaction.
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 commit()
<?php
// Once you have a valid DB object named $db...
$db->autoCommit(false);
$db->query('CREATE TABLE blah (a integer)');
$db->commit();
$db->query('INSERT INTO blah (a) VALUES (11)');
$res =& $db->query('SELECT a FROM blah');
if (DB::isError($res)) {
echo $res->getMessage() . "\n";
}
while ($res->fetchInto($row, DB_FETCHMODE_ORDERED)) {
echo $row[0] . "\n";
}
$res->free();
$db->query('DROP TABLE blah');
$db->commit();
?>