(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)
Commits a transaction
public bool PDO::commit ( void )
Commits a transaction, returning the database connection to autocommit mode until the next call to PDO::beginTransaction() starts a new transaction.
Returns:
Returns TRUE
on success or FALSE
on failure.
Examples:
Committing a basic transaction
<?php /* Begin a transaction, turning off autocommit */ $dbh->beginTransaction(); /* Insert multiple records on an all-or-nothing basis */ $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(); /* Database connection is now back in autocommit mode */ ?>
Committing a DDL transaction
<?php /* Begin a transaction, turning off autocommit */ $dbh->beginTransaction(); /* Change the database schema */ $sth = $dbh->exec("DROP TABLE fruit"); /* Commit the changes */ $dbh->commit(); /* Database connection is now back in autocommit mode */ ?>
See also:
Transactions and auto-commit - commit
Please login to continue.