如何通过PHP中的prepare语句使用多个update查询来存储数组中的值？

<?php
// 假设数组名为$data，包含多个键值对
$data = array(
    'key1' => 'value1',
    'key2' => 'value2',
    'key3' => 'value3'
);

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 构建prepare语句
$sql = "UPDATE table_name SET column1 = ? WHERE id = ?";
$stmt = $conn->prepare($sql);

// 遍历数组，执行多个update查询
foreach ($data as $key => $value) {
    // 绑定参数
    $stmt->bind_param("si", $value, $key);

    // 执行查询
    $stmt->execute();
}

// 关闭prepare语句和数据库连接
$stmt->close();
$conn->close();
?>