The commit() / mysqli_commit() function commits the current transaction for the specified database connection.
PHP MySQL commit() Example
<?php
$host= "localhost";
$username= "root";
$password = "";
$db_name = "demo_db";
$mysqli = mysqli_connect($host, $username, $password, $db_name);
// Check connection
if ($mysqli->connect_errno) {
printf("connection failed: %s\n", $mysql_connection->connect_error());
exit();
}
// Turn autocommit off
$mysqli -> autocommit(FALSE);
// Insert some values
$mysqli -> query("INSERT INTO Students (FirstName,LastName,Age)
VALUES ('Tony','stark',35)");
$mysqli -> query("INSERT INTO Students (FirstName,LastName,Age)
VALUES ('Ram','Jadhav',33)");
// Commit transaction
if (!$mysqli -> commit()) {
echo "Commit transaction failed";
exit();
}
$mysqli -> close();
?>
Let's understand the above PHP script.
The mysqli_connect() function opens a new connection to the MySQL server:
$host= "localhost";
$username= "root";
$password = "";
$db_name = "demo_db";
$mysqli = mysqli_connect($host, $username, $password, $db_name);
Turn off auto-commit:
// Turn autocommit off
$mysqli -> autocommit(FALSE);
SQL insert queries:
// Insert some values
$mysqli -> query("INSERT INTO Students (FirstName,LastName,Age)
VALUES ('Tony','stark',35)");
$mysqli -> query("INSERT INTO Students (FirstName,LastName,Age)
VALUES ('Ram','Jadhav',33)");
Commit the transaction:
// Commit transaction
if (!$mysqli -> commit()) {
echo "Commit transaction failed";
exit();
}
Close connection:
$mysqli -> close();
Comments
Post a Comment