PDO::commit – Commit a Transaction in PHP

PDO::commit() commits the current database transaction, returning the connection to autocommit mode until the next call to PDO::beginTransaction().

Parameters

This function takes no parameters.

Return value

Returns TRUE on success or FALSE on failure.

Example

<?php
/* Start a transaction, disable autocommit */
$dbh->beginTransaction();

/* Insert multiple rows atomically */
$sql = 'INSERT INTO fruit (name, colour, calories) VALUES (?, ?, ?)';
$sth = $dbh->prepare($sql);
foreach ($fruits as $fruit) {
    $sth->execute(array($fruit->name, $fruit->colour, $fruit->calories));
}

/* Commit the changes */
$dbh->commit();
/* Now the connection returns to autocommit mode */
?>