   #PHP Manual Improved MySQL Extension mysqli_affected_rows
   mysqli_bind_param

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                               mysqli_autocommit

   (PHP 5 CVS only)
   mysqli_autocommit -- Turns on or off auto-committing 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().
   ______________________________________________________________________

   Prev                 Home              Next
   mysqli_affected_rows  Up  mysqli_bind_param
