带有多个值的数组到Mysql (php)

<?php
// 假设我们有一个数组，每个元素都是一个待插入数据库的记录
$records = [
    ['name' => 'Alice', 'age' => 25],
    ['name' => 'Bob', 'age' => 30],
    ['name' => 'Charlie', 'age' => 35]
];

// 构建SQL语句
$sql = "INSERT INTO users (name, age) VALUES ";

$values = [];
foreach ($records as $record) {
    $values[] = "('" . implode("', '", array_map('mysqli_real_escape_string', $record)) . "')";
}

$sql .= implode(', ', $values);

// 连接数据库并执行SQL语句
$db = new mysqli('localhost', 'username', 'password', 'database');
if ($db->connect_error) {
    die('Connect Error (' . $db->connect_errno . ') ' . $db->connect_error);
}

if ($db->query($sql) === TRUE) {
    echo "Records inserted successfully";
} else {
    echo "Error: " . $sql . "<br>" . $db->error;
}

$db->close();
?>

<?php
// 假设我们有一个数组，每个元素都是一个待插入数据库的记录
$records = [
    ['name' => 'Alice', 'age' => 25],
    ['name' => 'Bob', 'age' => 30],
    ['name' => 'Charlie', 'age' => 35]
];

// 连接数据库
$db = new mysqli('localhost', 'username', 'password', 'database');
if ($db->connect_error) {
    die('Connect Error (' . $db->connect_errno . ') ' . $db->connect_error);
}

foreach ($records as $record) {
    // 构建SQL语句
    $sql = "INSERT INTO users (name, age) VALUES ('" . mysqli_real_escape_string($db, $record['name']) . "', " . intval($record['age']) . ")";

    // 执行SQL语句
    if ($db->query($sql) === FALSE) {
        echo "Error: " . $sql . "<br>" . $db->error;
        break;
    }
}

echo "Records inserted successfully";

$db->close();
?>