mysqli_autocommit(3) [php man page]

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)

MYSQLI_ROLLBACK(3)							 1							MYSQLI_ROLLBACK(3)

mysqli::rollback - Rolls back current transaction

       Object oriented style

SYNOPSIS

       bool mysqli::rollback ([int  $flags], [string  $name])

DESCRIPTION

       Procedural style
       bool mysqli_rollback (mysqli  $link, [int  $flags], [string  $name])

	Rollbacks the current transaction for the database.

PARAMETERS

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

	      o $flags
		- A bitmask of MYSQLI_TRANS_COR_* constants.

	      o $name
		- If provided then ROLLBACK/*name*/ is executed.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

CHANGELOG

       +--------+-------------------------------------+
       |Version |				      |
       |	|				      |
       |	|	      Description	      |
       |	|				      |
       +--------+-------------------------------------+
       | 5.5.0	|				      |
       |	|				      |
       |	|  Added $flags and $name parameters. |
       |	|				      |
       +--------+-------------------------------------+
EXAMPLES

       Example #1

	      mysqli::rollback example

	      Object oriented style

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

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

	      /* disable autocommit */
	      $mysqli->autocommit(FALSE);

	      $mysqli->query("CREATE TABLE myCity LIKE City");
	      $mysqli->query("ALTER TABLE myCity Type=InnoDB");
	      $mysqli->query("INSERT INTO myCity SELECT * FROM City LIMIT 50");

	      /* commit insert */
	      $mysqli->commit();

	      /* delete all rows */
	      $mysqli->query("DELETE FROM myCity");

	      if ($result = $mysqli->query("SELECT COUNT(*) FROM myCity")) {
		  $row = $result->fetch_row();
		  printf("%d rows in table myCity.
", $row[0]);
		  /* Free result */
		  $result->close();
	      }

	      /* Rollback */
	      $mysqli->rollback();

	      if ($result = $mysqli->query("SELECT COUNT(*) FROM myCity")) {
		  $row = $result->fetch_row();
		  printf("%d rows in table myCity (after rollback).
", $row[0]);
		  /* Free result */
		  $result->close();
	      }

	      /* Drop table myCity */
	      $mysqli->query("DROP TABLE myCity");

	      $mysqli->close();
	      ?>

	      Procedural style

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

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

	      /* disable autocommit */
	      mysqli_autocommit($link, FALSE);

	      mysqli_query($link, "CREATE TABLE myCity LIKE City");
	      mysqli_query($link, "ALTER TABLE myCity Type=InnoDB");
	      mysqli_query($link, "INSERT INTO myCity SELECT * FROM City LIMIT 50");

	      /* commit insert */
	      mysqli_commit($link);

	      /* delete all rows */
	      mysqli_query($link, "DELETE FROM myCity");

	      if ($result = mysqli_query($link, "SELECT COUNT(*) FROM myCity")) {
		  $row = mysqli_fetch_row($result);
		  printf("%d rows in table myCity.
", $row[0]);
		  /* Free result */
		  mysqli_free_result($result);
	      }

	      /* Rollback */
	      mysqli_rollback($link);

	      if ($result = mysqli_query($link, "SELECT COUNT(*) FROM myCity")) {
		  $row = mysqli_fetch_row($result);
		  printf("%d rows in table myCity (after rollback).
", $row[0]);
		  /* Free result */
		  mysqli_free_result($result);
	      }

	      /* Drop table myCity */
	      mysqli_query($link, "DROP TABLE myCity");

	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      0 rows in table myCity.
	      50 rows in table myCity (after rollback).

SEE ALSO

       mysqli_begin_transaction(3), mysqli_commit(3), mysqli_autocommit(3), mysqli_release_savepoint(3).

PHP Documentation Group 													MYSQLI_ROLLBACK(3)