php向数据库插入数组

<?php
// 数据库连接配置
$host = 'localhost';
$dbname = 'mydatabase';
$username = 'root';
$password = '';

try {
    // 创建PDO实例
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 要插入的数据数组
    $data = [
        ['name' => 'Alice', 'age' => 25],
        ['name' => 'Bob', 'age' => 30],
        ['name' => 'Charlie', 'age' => 35]
    ];

    // 准备SQL语句
    $stmt = $pdo->prepare("INSERT INTO users (name, age) VALUES (:name, :age)");

    // 循环插入数据
    foreach ($data as $row) {
        $stmt->bindParam(':name', $row['name']);
        $stmt->bindParam(':age', $row['age']);
        $stmt->execute();
    }

    echo "数据插入成功！";
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>