按多维数组中的键检索值并保存到数据库中

<?php
// 连接到腾讯云数据库
$servername = "your_servername";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建表
$sql = "CREATE TABLE IF NOT EXISTS data (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    key_name VARCHAR(30) NOT NULL,
    value VARCHAR(255) NOT NULL,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";
$conn->query($sql);

// 多维数组示例
$data = array(
    "key1" => "value1",
    "key2" => array(
        "subkey1" => "subvalue1",
        "subkey2" => "subvalue2"
    )
);

// 递归函数，用于解析多维数组并保存到数据库
function saveToDatabase($data, $parentKey = "") {
    global $conn;
    
    foreach ($data as $key => $value) {
        if (is_array($value)) {
            // 如果值是数组，则递归调用函数
            $newKey = ($parentKey == "") ? $key : $parentKey . "->" . $key;
            saveToDatabase($value, $newKey);
        } else {
            // 如果值不是数组，则保存到数据库
            $newKey = ($parentKey == "") ? $key : $parentKey . "->" . $key;
            $sql = "INSERT INTO data (key_name, value) VALUES ('$newKey', '$value')";
            $conn->query($sql);
        }
    }
}

// 调用函数保存数据到数据库
saveToDatabase($data);

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