PHP和MYSQLi - 使用循环和存储在数组中绑定参数？

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 准备SQL语句
$sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES (?, ?, ?)";
$stmt = $conn->prepare($sql);

// 绑定参数
$stmt->bind_param("sss", $firstname, $lastname, $email);

// 设置参数并执行
$firstname = "John";
$lastname = "Doe";
$email = "john@example.com";
$stmt->execute();

// 使用循环绑定参数并执行
$guests = array(
    array("Jane", "Doe", "jane@example.com"),
    array("Bob", "Smith", "bob@example.com"),
    array("Alice", "Johnson", "alice@example.com")
);

foreach ($guests as $guest) {
    $firstname = $guest[0];
    $lastname = $guest[1];
    $email = $guest[2];
    $stmt->execute();
}

echo "新记录插入成功";

// 关闭连接
$stmt->close();
$conn->close();
?>