<?php
// 數(shù)據(jù)庫(kù)連接配置
$dsn = 'mysql:host=localhost;dbname=test';
$username = 'root';
$password = '';

try {
    // 創(chuàng)建PDO對(duì)象
    $pdo = new PDO($dsn, $username, $password);

    // 數(shù)據(jù)準(zhǔn)備
    $data = [
        ['name' => '張三', 'age' => 20],
        ['name' => '李四', 'age' => 25],
        ['name' => '王五', 'age' => 30],
    ];

    // 開(kāi)啟事務(wù)
    $pdo->beginTransaction();

    // 預(yù)處理插入語(yǔ)句
    $stmt = $pdo->prepare('INSERT INTO users (name, age) VALUES (:name, :age)');

    // 執(zhí)行批量插入
    foreach ($data as $item) {
        $stmt->bindValue(':name', $item['name']);
        $stmt->bindValue(':age', $item['age']);
        $stmt->execute();
    }

    // 提交事務(wù)
    $pdo->commit();

    echo "批量插入成功！";
} catch (PDOException $e) {
    // 回滾事務(wù)
    $pdo->rollBack();

    echo "插入失敗：" . $e->getMessage();
}

<?php
// 數(shù)據(jù)庫(kù)連接配置
$dsn = 'mysql:host=localhost;dbname=test';
$username = 'root';
$password = '';

try {
    // 創(chuàng)建PDO對(duì)象
    $pdo = new PDO($dsn, $username, $password);
  
    // 數(shù)據(jù)準(zhǔn)備
    $data = [
        ['id' => 1, 'name' => '張三'],
        ['id' => 2, 'name' => '李四'],
        ['id' => 3, 'name' => '王五'],
    ];
  
    // 開(kāi)啟事務(wù)
    $pdo->beginTransaction();
  
    foreach ($data as $item) {
        // 預(yù)處理更新語(yǔ)句
        $stmt = $pdo->prepare('UPDATE users SET name = :name WHERE id = :id');
        $stmt->bindValue(':name', $item['name']);
        $stmt->bindValue(':id', $item['id']);
        $stmt->execute();
    }
  
    // 提交事務(wù)
    $pdo->commit();
  
    echo "批量更新成功！";
} catch (PDOException $e) {
    // 回滾事務(wù)
    $pdo->rollback();
  
    echo "更新失敗：" . $e->getMessage();
}