用PDO将XML文件导入mySQL

<?php
$xml = simplexml_load_file('data.xml'); // 解析XML文件

$dsn = 'mysql:host=localhost;dbname=test;charset=utf8';
$username = 'root';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password); // 连接数据库

    // 创建数据表
    $pdo->exec("CREATE TABLE IF NOT EXISTS xml_data (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(50),
        age INT,
        email VARCHAR(50)
    )");

    // 插入数据
    $stmt = $pdo->prepare("INSERT INTO xml_data (name, age, email) VALUES (?, ?, ?)");

    foreach ($xml->person as $person) {
        $stmt->execute([$person->name, $person->age, $person->email]);
    }

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