用MSSQL和PHP在数据库中同时保存数组键和值

<?php
// 连接数据库
$serverName = "localhost";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 准备数据
$arrayData = array(
    "key1" => "value1",
    "key2" => "value2",
    "key3" => "value3"
);

// 保存数组的键和值到数据库
foreach ($arrayData as $key => $value) {
    $sql = "INSERT INTO array_data (key, value) VALUES (?, ?)";
    $params = array($key, $value);
    $stmt = sqlsrv_query($conn, $sql, $params);
    if ($stmt === false) {
        die(print_r(sqlsrv_errors(), true));
    }
}

// 关闭数据库连接
sqlsrv_close($conn);
?>