Autocommit – MySQLi Functions

Syntax :

Description :

It used to turns on or off auto-committing on database modifications done by MySQL operation like  INSERT, UPDATE ,DELETE , SELECT etc.

Parameter :

• connection – This is a Required parameter. It is a link identifier returned by mysqli_connect() function.
• mode – Whether to turn on auto-commit or not on database operations.

Output :

It Returns

• TRUE on success.
• FALSE on failure.

mysqli_autocommit() –  MySQLi Functions Example in Procedural style  :

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tutorialmines";
$conn = new mysqli($servername, $username, $password, $dbname);

/* checking connection status */
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected to database successfully. <br>";

/* SELECT autocommit current state */
if ($result = mysqli_query($conn, "SELECT @@autocommit")) {
$row = mysqli_fetch_row($result);
echo "Autocommit current state is : ". $row[0];
mysqli_free_result($result);
}
/* turn autocommit off */
mysqli_autocommit($conn, FALSE);

if ($result = mysqli_query($conn, "SELECT @@autocommit")) {
$row = mysqli_fetch_row($result);
echo "<br>Autocommit is set to FALSE now : ". $row[0];
mysqli_free_result($result);
}

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

if ($result = mysqli_query($conn, "SELECT @@autocommit")) {
$row = mysqli_fetch_row($result);
echo "<br>Autocommit is set to TRUE again : ". $row[0];
mysqli_free_result($result);
}

$conn->close();
?>

Output of above code in the browser is as below: