PDO::commit

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)

PDO::commit — 锟结交一锟斤拷锟斤拷锟斤拷

说锟斤拷

PDO::commit ( void ) : bool

锟结交一锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟接凤拷锟截碉拷锟皆讹拷锟结交模式直锟斤拷锟铰次碉拷锟斤拷 PDO::beginTransaction() 锟斤拷始一锟斤拷锟铰碉拷锟斤拷锟斤拷为止锟斤拷

锟斤拷锟斤拷值

锟缴癸拷时锟斤拷锟斤拷 TRUE锟斤拷 锟斤拷锟斤拷锟斤拷失锟斤拷时锟斤拷锟斤拷 FALSE锟斤拷

锟斤拷锟斤拷

Example #1 锟结交一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

<?php
/* 锟斤拷始一锟斤拷锟斤拷锟今，关憋拷锟皆讹拷锟结交 */
$dbh->beginTransaction();

/* 锟斤拷全锟叫伙拷全锟睫的伙拷锟斤拷锟较诧拷锟斤拷锟斤拷屑锟铰硷拷锟揭慈拷锟斤拷锟斤拷耄慈拷锟斤拷锟斤拷锟斤拷耄� */
$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,
    ));
}

/* 锟结交锟斤拷锟斤拷 */
$dbh->commit();

/* 锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟接凤拷锟截碉拷锟皆讹拷锟结交模式 */
?>

Example #2 锟结交一锟斤拷DDL锟斤拷锟斤拷

<?php
/*  锟斤拷始一锟斤拷锟斤拷锟今，关憋拷锟皆讹拷锟结交 */
$dbh->beginTransaction();

/* Change the database schema */
$sth = $dbh->exec("DROP TABLE fruit");

/* 锟斤拷锟斤拷锟斤拷锟捷匡拷芄锟� */
$dbh->commit();

/* 锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟接凤拷锟截碉拷锟皆讹拷锟结交模式 */
?>

Note: 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷库都锟斤拷锟斤拷使锟斤拷DDL锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟斤拷锟斤拷锟襟，讹拷锟斤拷锟斤拷一些锟斤拷锟斤拷锟斤拷MySQL锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷DDL锟斤拷锟斤拷锟斤拷远锟斤拷峤伙拷锟斤拷锟�

锟轿硷拷