PHP mysqli_commit()Function
Example
Turn off auto-commit, do some queries, and then commit the queries:
<?php
// Assume database username: root, password: 123456, database: EXAMPLE
$con=mysqli_connect("localhost","root","123456","EXAMPLE");
if (mysqli_connect_errno($con))
{
echo "MySQL connection failed: ". mysqli_connect_error();
}
// Turn off auto-commit
mysqli_autocommit($con,FALSE);
// Insert some values
mysqli_query($con,"INSERT INTO websites (name, url, alexa, country)
VALUES ('Baidu','https://www.baidu.com/','4','CN')");
// Commit the transaction
mysqli_commit($con);
// Close the connection
mysqli_close($con);
?>
// Assume database username: root, password: 123456, database: EXAMPLE
$con=mysqli_connect("localhost","root","123456","EXAMPLE");
if (mysqli_connect_errno($con))
{
echo "MySQL connection failed: ". mysqli_connect_error();
}
// Turn off auto-commit
mysqli_autocommit($con,FALSE);
// Insert some values
mysqli_query($con,"INSERT INTO websites (name, url, alexa, country)
VALUES ('Baidu','https://www.baidu.com/','4','CN')");
// Commit the transaction
mysqli_commit($con);
// Close the connection
mysqli_close($con);
?>
Definition and Usage
The mysqli_commit() function commits the current transaction for the specified database connection.
Tip:Please seemysqli_autocommit()function, used to turn on or off auto-commit of database modifications. Please seemysqli_rollback()function, used to roll back the current transaction.
Syntax
mysqli_commit(connection);
| Parameter | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use. |
Technical Details
| Return value: | Returns TRUE on success, or FALSE on failure. |
|---|---|
| PHP Version: | 5+ |
PHP MySQLi Reference Manual Other Extensions