PDO为多个INSERT语句从数组和单个值生成绑定占位符

$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com'),
    array('Bob', 'Johnson', 'bob@example.com')
);

$dbh = new PDO($dsn, $username, $password);

$stmt = $dbh->prepare("INSERT INTO users (first_name, last_name, email) VALUES (?, ?, ?)");

foreach ($data as $row) {
    $stmt->execute($row);
}

$first_name = 'John';
$last_name = 'Doe';
$email = 'john@example.com';

$dbh = new PDO($dsn, $username, $password);

$stmt = $dbh->prepare("INSERT INTO users (first_name, last_name, email) VALUES (?, ?, ?)");

$stmt->bindParam(1, $first_name);
$stmt->bindParam(2, $last_name);
$stmt->bindParam(3, $email);

$stmt->execute();