What is the best way to repeat the same query without copying and pasting?

Question

I have a query and I will need to use it twice, once I will use the fetchCollum and another I will use the fetch(PDO::FETCH_ASSOC). That said, I can’t apply a fetch and then apply another fetch, for example:

$tokenHash = $query->fetchColumn(10);
    if($query->rowCount() === 0 || (hash_equals($tokenHash, $tokenGet) === FALSE)):
        echo 'Token Inválido!';
        header( "refresh:10;url=listarDados.php" );
        exit;
    else:
        $row = $query->fetch(PDO::FETCH_ASSOC);

He ends up returning me as boolean false.And to not have to do everything again and simply copy and paste, there is an alternative to repeat the same query only to use different fetch’s?

Answer 1

The simplest way is to store the result of the query (in $row) and use it in several places. fetch() will return all the fields chosen in the query when comparing/manipulating just specify which one, as in if $tokenHash was exchanged for $row['tokenHash'] (check if this is the correct field name)

$row = $query->fetch(PDO::FETCH_ASSOC);

if($query->rowCount() === 0 || (hash_equals($row['tokenHash'], $tokenGet) === FALSE)){
    echo 'Token Inválido!';
    header( "refresh:10;url=listarDados.php" );
    exit;
}   

If you wish to use the fetchColumn() and have used a prepared consultation just call the méotod execute() again and do the fetch(), the code stays that way:

$row = $query->fetchColumn(10);
if($query->rowCount() === 0 || (hash_equals($tokenHash, $tokenGet) === FALSE)){
    echo 'Token Inválido!';
    header( "refresh:10;url=listarDados.php" );
    exit;
}else{
    $query->execute();
    $row = $query->fetch(PDO::FETCH_ASSOC);
}