PEAR Manual
Prev |  | Next

# DB_common::commit()

DB_common::commit() -- Commits the current transaction

## Synopsis

``mixed commit` ()`

## Description

Commits the current transaction.

## Return value

integer - `DB_OK` on success or a DB_Error object on failure

## Throws

Table 33-1. 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.

## Note

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.

## Example

Example 33-1. 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();
    ?>

## See

rollback(), autoCommit()

Prev | Home | Next
DB_common::autoPrepare() | Up | DB_common::createSequence()