PHP mysqli_commit() Function

PHP mysqli_commit() commits the current transaction for the used database connection.

Syntax

bool mysqli_commit(connection);

mysqli_commit() Function Parameter

ParameterDescription
Connection :Required parameter. The MySQL connection to be used.

mysqli_commit() Function Return Value

Return Values :Returns TRUE on success or FALSE on failure.

mysqli_commit() Function Example

<?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);
?>