Taking only the last record

Question

I’m using this code to get the data between the current time and time registered in the comic

$sql = "SELECT * FROM acessos WHERE hora > :hora GROUP BY username";
$sql = $pdo->prepare($sql);
$sql->bindValue(":hora", date('H:i:s', strtotime("-1 minutes")));
$sql->execute();
$contagem = $sql->rowCount();

while($row = $sql->fetch()) {
    $teste = $row['username'].', ';
}

But the problem that’s only getting the last record, and I couldn’t solve

Answer 1

Use the function fetchAll instead of fetch

$sql = 'SELECT * FROM acessos WHERE hora > :hora GROUP BY username';
$statement = $pdo->prepare($sql);
$statement->bindValue(":hora", date('H:i:s', strtotime('-1 minutes')));
$statement->execute();

$resultado = $statement->fetchAll(PDO::FETCH_ASSOC);

//Mostra resultados
var_dump($resultado);

References:

http://php.net/manual/en/pdostatement.fetch.php http://php.net/manual/en/pdostatement.fetchall.php