mysqli_autocommit

(PHP 5 CVS only)

mysqli_autocommit -- Turns on or off auto-commiting database modifications

Description

bool mysqli_autocommit ( object link, bool mode)

mysqli_autocommit() is used to turn on or off auto-commit mode on queries for the database connection represented by the link resource.

Returns TRUE on success or FALSE on failure.

Note: mysqli_autocommit() doesn't work with non transactional table types (like MyISAM or ISAM).

To determine the current state of autocommit use the SQL command 'SELECT @@autocommit'.

Example 1. Using the mysqli_autocommit function

Procedural style:

<?php

    /* Open a connection */
    $link = mysqli_connect("localhost", "user", "pass", "mydb");
    
    /* Turn on autocommit */
    mysqli_autocommit($link, true);

    /* determine current autocommit status */
    if ($result = mysqli_query($link, "SELECT @@autocommit")) {
        $row = mysqli_fetch_row($result);
        mysqli_free_result($result);
        printf ("Autocommit is %d\n", $row[0]);
    }

    /* close connection */
    mysqli_close($link);
?>

Object oriented style:

<?php

    /* Open a connection */
    $mysql = mysqli_connect("localhost", "user", "pass", "mydb");
    
    /* Turn on autocommit */
    $mysql->autocommit(true);

    /* determine current autocommit status */
    if ($result = $mysql->query($link, "SELECT @@autocommit")) {
        $row = $result->fetch_row($result);
        printf ("Autocommit is %d\n", $row[0]);
        $result->free();
    }

    /* close connection */
    $mysql->close();
?>

The above examples would produce the following output:
Autocommit is 1

See also mysqli_commit(), mysqli_rollback().