在PDO中使用prepared_insert时在中验证是否成功创建了行

<?php
try {
    // 创建PDO实例
    $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'username', 'password');

    // 准备SQL语句
    $stmt = $pdo->prepare('INSERT INTO users (username, email) VALUES (:username, :email)');

    // 绑定参数
    $stmt->bindParam(':username', $username);
    $stmt->bindParam(':email', $email);

    // 设置参数值
    $username = 'john_doe';
    $email = 'john@example.com';

    // 执行SQL语句
    $success = $stmt->execute();

    if ($success) {
        // 获取最后插入行的ID
        $lastInsertId = $pdo->lastInsertId();
        echo "Row inserted successfully with ID: " . $lastInsertId;
    } else {
        echo "Failed to insert row.";
    }
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>

if (!$success) {
    $errorInfo = $stmt->errorInfo();
    echo "Error: " . $errorInfo[2];
}