从多维数组中选择数组并保存到db表中

<?php
// 多维数组示例
$multiArray = array(
    array('John', 'Doe', 25),
    array('Jane', 'Smith', 30),
    array('Tom', 'Brown', 35)
);

// 选择条件：年龄大于等于30岁的数组
$selectedArrays = array();
foreach ($multiArray as $array) {
    if ($array[2] >= 30) {
        $selectedArrays[] = $array;
    }
}

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

// 创建数据库表
$sql = "CREATE TABLE IF NOT EXISTS selected_arrays (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    age INT NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "数据库表创建成功";
} else {
    echo "创建数据库表失败: " . $conn->error;
}

// 将选择的数组插入数据库表中
foreach ($selectedArrays as $array) {
    $firstName = $array[0];
    $lastName = $array[1];
    $age = $array[2];

    $sql = "INSERT INTO selected_arrays (first_name, last_name, age)
            VALUES ('$firstName', '$lastName', $age)";

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

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