如何将多维数组转换为mysql表

<?php
// 多维数组示例
$multiDimensionalArray = [
    [
        'name' => 'John',
        'age' => 25,
        'email' => 'john@example.com'
    ],
    [
        'name' => 'Jane',
        'age' => 30,
        'email' => 'jane@example.com'
    ]
];

// 连接数据库
$servername = 'localhost';
$username = 'your_username';
$password = 'your_password';
$dbname = 'your_database';

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 遍历多维数组并构建插入语句
foreach ($multiDimensionalArray as $row) {
    $keys = array_keys($row);
    $values = array_values($row);
    $placeholders = implode(',', array_fill(0, count($values), '?'));

    $stmt = $conn->prepare("INSERT INTO your_table (" . implode(',', $keys) . ") VALUES ($placeholders)");
    $stmt->execute($values);
}

// 关闭数据库连接
$conn = null;
?>