PHP mysqli_autocommit()Functions
Examples
Turn off auto-commit, do some queries, 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 "Connection to MySQL 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 "Connection to MySQL 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_autocommit() function turns on or off auto-commit for database modifications.
Tip:Please see themysqli_commit() function, used to commit the current transaction for the specified database connection. Please see themysqli_rollback()function, used to roll back the current transaction.
Syntax
mysqli_autocommit(connection,mode);
| Parameters | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use. |
| mode | Required. If set to FALSE, it turns off auto-commit. If set to TRUE, it turns on auto-commit (committing any pending queries). |
Technical Details
| Return value: | Returns TRUE on success, or FALSE on failure. |
|---|---|
| PHP Version: | 5+ |
PHP MySQLi Reference Manual Other Extensions