PHP mysqli_commit() commits the current transaction for the used database connection.
Syntax
bool mysqli_commit(connection);
Parameter | Description |
---|---|
Connection : | Required parameter. The MySQL connection to be used. |
Return Values : | Returns TRUE on success or FALSE on failure. |
<?php $con = mysqli_connect("localhost","user","password","db"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // set autocommit to off mysqli_autocommit($con, FALSE); $insert_member_sql = "INSERT INTO members (id, username) VALUES('$id', '$username')"; mysqli_query($con, $insert_member_sql); $insert_member_sql = "INSERT INTO members (id, username) VALUES('$id', '$username')"; mysqli_query($con, $insert_member_sql); // commit transaction mysqli_commit($con); // close database connection mysqli_close($con); ?>