random.php

<?php
include 'dbreq.php';
//requête du droit de l'user
$droit = $bdd->prepare("SELECT * FROM user WHERE pseudo = ?");
$droit->execute(array($_SESSION['pseudo']));
$droituser = $droit-> fetch();

// 12 random games
$req = $bdd->query('SELECT * FROM games ORDER BY RAND() LIMIT 12');
?>
<?php 
include 'intro.php';
include 'menu.php';
// if ($droituser['droit']=="premium" || $droituser['droit']=="admin"){
//         include 'chat.php';
// }
?>

<div class="container-fluid">
<div class="row">
<?php
while ($donnees = $req->fetch())
{
?>


<div class="col-sm-12 col-md-6 col-lg-4 col-xl-3 text-center">
<a href='jeu.php?id=<?php //add id to get the rigth jeu.php 
        echo htmlspecialchars($donnees['id']);
?>'>

<img class= "m-2 border border-white rounded-lg" src="

        <?php
                //img from db
                echo htmlspecialchars('data:image/jpeg;base64,'.base64_encode( $donnees['cover'] )); 
        ?>
        " alt="
        <?php
                //nom from db
                echo htmlspecialchars($donnees['nom']); 
        ?>
        "></a>
</div>
<?php
} 
// end while for comment
$req->closeCursor();
?>
</div>
</div>
<?php 
include 'outro.php';
?>