如何生成MySQL INSERT语句以使用数组中的多行填充表格

<?php
// 假设已经连接到了MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 要插入的数据数组
$data = array(
    array("name" => "John", "age" => 25),
    array("name" => "Jane", "age" => 30),
    array("name" => "Bob", "age" => 35)
);

// 生成INSERT语句的多个部分
$columns = implode(", ", array_keys($data[0]));
$values = array();
foreach ($data as $row) {
    $rowValues = "'" . implode("', '", $row) . "'";
    $values[] = "($rowValues)";
}

// 拼接成完整的INSERT语句
$insertStatement = "INSERT INTO table_name ($columns) VALUES " . implode(", ", $values);

// 执行INSERT语句
mysqli_query($connection, $insertStatement);

// 关闭数据库连接
mysqli_close($connection);
?>