在PHP PDO中获取上次执行的查询

<?php
// 连接到数据库
$dsn = "mysql:host=localhost;dbname=mydb";
$username = "username";
$password = "password";
$pdo = new PDO($dsn, $username, $password);

// 插入数据
$stmt = $pdo->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
$stmt->execute(["John Doe", "john.doe@example.com"]);

// 获取上次执行的查询中自增主键的值
$lastInsertId = $pdo->lastInsertId();

echo "Last insert ID: " . $lastInsertId;
?>