MYSQLI_AUTOCOMMIT(3)							 1						      MYSQLI_AUTOCOMMIT(3)

mysqli::autocommit - Turns on or off auto-committing database modifications

       Object oriented style

SYNOPSIS

       bool mysqli::autocommit (bool  $mode)

DESCRIPTION

       Procedural style
       bool mysqli_autocommit (mysqli  $link, bool  $mode)

	Turns on or off auto-commit mode on queries for the database connection.

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

PARAMETERS

	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

	      o $mode
		- Whether to turn on auto-commit or not.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

NOTES

       Note

	       This function doesn't work with non transactional table types (like MyISAM or ISAM).

EXAMPLES

       Example #1

	      mysqli::autocommit example

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* turn autocommit on */
	      $mysqli->autocommit(TRUE);

	      if ($result = $mysqli->query("SELECT @@autocommit")) {
		  $row = $result->fetch_row();
		  printf("Autocommit is %s
", $row[0]);
		  $result->free();
	      }

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

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      if (!$link) {
		  printf("Can't connect to localhost. Error: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* turn autocommit on */
	      mysqli_autocommit($link, TRUE);

	      if ($result = mysqli_query($link, "SELECT @@autocommit")) {
		  $row = mysqli_fetch_row($result);
		  printf("Autocommit is %s
", $row[0]);
		  mysqli_free_result($result);
	      }

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

	      The above examples will output:

	      Autocommit is 1

SEE ALSO

       mysqli_begin_transaction(3), mysqli_commit(3), mysqli_rollback(3).

PHP Documentation Group 												      MYSQLI_AUTOCOMMIT(3)