如何在php中将数组值作为键值对插入到数据库表中

<?php
$servername = "数据库服务器地址";
$username = "用户名";
$password = "密码";
$dbname = "数据库名";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

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

<?php
$data = array(
    'column1' => 'value1',
    'column2' => 'value2',
    'column3' => 'value3',
    // 添加更多的键值对...
);
?>

<?php
$table = '表名';
$columns = implode(',', array_keys($data));
$values = "'" . implode("','", array_values($data)) . "'";

$sql = "INSERT INTO $table ($columns) VALUES ($values)";
?>

<?php
if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

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