将多维数组中的值插入数据库

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

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

// 创建数据库表
$sql = "CREATE TABLE IF NOT EXISTS my_table (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    value VARCHAR(255) NOT NULL
)";
if ($conn->query($sql) === FALSE) {
    echo "创建表失败: " . $conn->error;
}

// 多维数组
$array = array(
    array("value1"),
    array("value2"),
    array("value3")
);

// 解析多维数组并插入数据库
foreach ($array as $subArray) {
    $value = $subArray[0];
    $sql = "INSERT INTO my_table (value) VALUES ('$value')";
    if ($conn->query($sql) === FALSE) {
        echo "插入数据失败: " . $conn->error;
    }
}

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