用于填充MySQL表的PHP脚本

<?php
// 连接到MySQL数据库
$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "myusername";
$password = "mypassword";
$db = new PDO($dsn, $username, $password);

// 准备SQL插入语句
$stmt = $db->prepare("INSERT INTO users (name, email) VALUES (:name, :email)");

// 填充数据
$data = [
    ['name' => 'John Doe', 'email' => 'john.doe@example.com'],
    ['name' => 'Jane Smith', 'email' => 'jane.smith@example.com'],
    // 更多数据...
];

// 执行插入操作
foreach ($data as $row) {
    $stmt->execute($row);
}

echo "数据已成功插入到MySQL表中！";
?>