使用php pdo将多个数据保存到数据库

$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'username';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo '数据库连接失败：' . $e->getMessage();
}

$sql = 'INSERT INTO users (name, email) VALUES (:name, :email)';

$stmt = $pdo->prepare($sql);

foreach ($users as $user) {
    $stmt->bindParam(':name', $user['name']);
    $stmt->bindParam(':email', $user['email']);
    
    $stmt->execute();
}

$pdo = null;