demo/assets/php/orders.php

<?php
$sql = 'SELECT `id_user`, `fullname`, `email`, 
`login`, `password`, `role`, `phone` FROM `users`';
$sth = $dbh->prepare($sql, [PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY]);
$sth->execute([]);
$red = $sth->fetchAll();

?>