使用PDO语句获取受影响的行数和最后插入的ID

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

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

// 插入语句
$sqlInsert = 'INSERT INTO users (name, email) VALUES (:name, :email)';
$stmtInsert = $pdo->prepare($sqlInsert);
$stmtInsert->execute(['name' => 'John Doe', 'email' => 'john@example.com']);

// 更新语句
$sqlUpdate = 'UPDATE users SET email = :email WHERE id = :id';
$stmtUpdate = $pdo->prepare($sqlUpdate);
$stmtUpdate->execute(['email' => 'newemail@example.com', 'id' => 1]);

$affectedRows = $stmtUpdate->rowCount();
$lastInsertId = $pdo->lastInsertId();