php - 如何返回我在同一查询中创建/或之前创建的记录

Question

如何返回我在同一查询中创建的记录。

我尝试了$row[Password]，但它不起作用。请帮忙

$sql = "SELECT COUNT(*) FROM characters WHERE GUID=:GUID";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':GUID', $_GET['GUID'], PDO::PARAM_INT);
    $stmt->bindColumn(4, $charactername);
$stmt->execute();
$res = $stmt->fetchColumn();
if($res == 1) {
    echo "Already created";
}


if(!$res){
        $sql = "INSERT INTO characters (GUID,Charactername,Password) VALUES (:GUID,:Charactername,FLOOR( 1000 + ( RAND( ) *8999 ) ))";
        $stmt= $pdo->prepare($sql);
        $stmt->bindParam(':GUID', $_GET['GUID'], PDO::PARAM_INT);
        $stmt->bindParam(':Charactername', $_GET['Charactername'], PDO::PARAM_INT);                 
        $stmt->execute();
        echo " THIS password created with FLOOR";
}

Answer 1

在$stmt->execute();之后使用$stmt->lastInsertId();来获取插入的记录ID，然后再进行一次查询来选择记录。