Slectionner 10 questions par jour par uttilisateurs QCM

$id_user = $_SESSION['id'];

$id_user

<?php
// Fichier : qcm.class.php
class qcm{
 public $id_q;
 private $bdd = NULL;
 
 /**
 * Constructeur de la class.
 * On lui passe l'objet $bdd en paramètre
 */
 function __construct($oBdd = NULL){
    $this->bdd = $oBdd;
  }
  
  /**
  * Permet d'exécuter une requête
  * $sql @string : requete sql
  * $datas @array (par défaut = NULL) : array des paramètres de la requete
  * $fetch : par défaut est à true.
  * Pour une requête de type INSERT / DELETE ou UPDATE .. mettre ce paramètre à false lors de l'appel de la fonction
  * return @array si la variable $fetch = true
  */
  private function queryExec($sql,$datas=NULL,$fetch=true){
    $result = NULL;
    try{
      $requete = $this->bdd->prepare($sql) ;
      $requete->execute($datas) ;
      $result = $fetch ? $requete->fetchAll() : NULL;
    }catch(Exception $e){
      // en cas d'erreur :
       echo " Erreur ! ".$e->getMessage();
       echo " Les datas : " ;
      print_r($datas);
    }
    return $result;
  }
  
  
  /**
  * Recupère la liste de TOUTES tes questions
  * (fonction non utilisée actuellement)
  * return @array
  */
  public function get_all_questions(){
    $sql = "SELECT * FROM questions ORDER BY id";
    return $this->queryExec($sql);
  }
  
  /**
  * Récupère une question en fonction de son id
  * return @array
  */
  public function get_question_by_id($id){
    $sql = "SELECT * FROM questions WHERE id =:id ORDER BY id";
    $datas = array(":id"=>$id);
    $result = $this->queryExec($sql,$datas);
    return !empty($result) ? $result[0] : NULL;
  }
  /**
  * Compte le nombre de questions d'un user en fonction de la date
  */
  public function get_nb_rep_user($id_user,$date = NULL){
    $now = $date ? $date : date('Y-m-d');
    $sql = "SELECT COUNT(id) AS NB 
            FROM info_user
            WHERE id_user = :id_user
              AND date_rep = :now ";
    $datas = array(':id_user'=>$id_user,':now'=>$now);
    $result = $this->queryExec($sql,$datas);
    return !empty($result) ? $result[0]['NB'] : 0;
  }
  /**
  * Récupère une question aléatoire (directement en sql )
  */
  public function get_random_question(){
	$sql = "SELECT * FROM questions 
           WHERE id NOT IN (
              SELECT question_fait
              FROM info_user
              WHERE id_user = :id_user
             )
           ORDER BY RAND() LIMIT 1";
		$datas = array(':id_user'=>$id_user);
		$result = $this->queryExec($sql,$datas);
    return !empty($result) ? $result[0] : NULL;
  }
  
  /**
  * Récupère les réponses aléatoire (directement en sql )
  * return @array
  */
  public function get_reponses_by_id_question($id_question = NULL){
   $return = array();
   
   if($id_question){
    $sql = "SELECT * FROM reponse WHERE id_question =:id_question ORDER BY RAND()";
    $datas = array(":id_question"=>$id_question);
    $result = $this->queryExec($sql,$datas);
    foreach($result as $R){
     $return[$R['id']] = $R;
    }
   }
   return $return;
  }
  
  /**
  * Vérifie si la réponse donnée est la bonne
  * retourne true si vrai .. sinon false
  */
  public function check_if_good_answer($rep_user,$id_question){
    $q = $this->get_reponses_by_id_question($id_question);
    return ($q[$rep_user]['correct'] == 1) ? true : false;
  }
  
  
//fin de la class
}

?>

<?php
session_start();
//Affichage des erreurs PHP
error_reporting(E_ALL);
ini_set('display-errors','on');


/*
function debug($var,$title=NULL){
 echo "<pre><br>-------------------------<br>";
 if($title){
  echo "<b><u> **** ".$title." **** </b></u>:<br>";
 }
 if(is_array($var)){
  print_r($var);
 }else{
  echo $var;
 }
 echo "<br>-------------------------<br></pre>";
}
*/
//-------------------------------------------------------------------//
//connexion à la BDD
//-------------------------------------------------------------------//
require_once ('cobdd.php');

// on oblige l’utilisateur a ce connecter 
if(!isset($_SESSION['id']))
{
	header('Location: connex.php');
}
// définir la variable $id_user

$id_user = $_SESSION['id'];

//-------------------------------------------------------------------//
// Require de la class et instanciation
//-------------------------------------------------------------------//
require_once ('qcm.class.php');
$oQcm = new qcm($bdd);
if(isset($_GET['go_quiz'])){
//-------------------------------------------------------------------//
//récupération PROPRE des variables AVANT de les utiliser
//-------------------------------------------------------------------//
$rep_user = !empty($_POST['reponse']) ? $_POST['reponse'] : NULL;
$id_q     = !empty($_POST['id_q']) ? $_POST['id_q'] : NULL;

//-------------------------------------------------------------------//
// recup de la question
//-------------------------------------------------------------------//
$a_questions = $id_q ? $oQcm->get_question_by_id($id_q) : $oQcm->get_random_question($id_user);
//debug($a_questions,'a_questions');

$id_question = !empty($id_q) ? $id_q : (!empty($a_questions) ? $a_questions['id'] : NULL) ;
//debug($id_question,'id_question'); 

// enregistrer informations user
if(isset($id_question))
{
	$id_user = $_SESSION['id'];
	$req_insert_info = $bdd->prepare('INSERT INTO info_user(id_user, question_fait, tempo)VALUES(?, ?, NOW())');
	$req_insert_info->execute(array($id_user, $id_question));
	
}
//-------------------------------------------------------------------//
// recup des réponses de la question
//-------------------------------------------------------------------//
$a_rep = $oQcm->get_reponses_by_id_question($id_question);
 //debug($a_rep,'a_rep'); 
 
//-------------------------------------------------------------------//
// On vérifie la réponse
//-------------------------------------------------------------------// 
  if($rep_user && $id_q) {
   $verif_rep = $oQcm->check_if_good_answer($rep_user,$id_q);
   //debug($verif_rep,'verif_rep'); 
   if($verif_rep){
	
    echo "Bravo bonne réponse !</br></br>";
    echo "<a href='index.php?go_quiz=1' rel="nofollow noopener noreferrer" target="_blank">Retour</a>";
   }else{
    echo "Mauvaise réponse</br></br>";
    echo "<a href='index.php?go_quiz=1' rel="nofollow noopener noreferrer" target="_blank">Retour</a>";
   }
  }
  
  //le temps des tests
  if(!empty($_POST)){
    //debug($_POST,' Variables POST ');
  }
}
?>

<!doctype html>
<html lang="fr">
<head>
  <meta charset="utf-8">
  <title>Page Quiz</title>
  <link rel="stylesheet" href="style.css">
</head>
<body>
<?php 
if(isset($_SESSION['id']))
{

?>
<a href="deco.php" rel="nofollow noopener noreferrer" target="_blank">Se déconnecter</a></br></br>
 <?php
}
 if(isset($_GET['go_quiz'])){
	 if(!$id_q && !empty($a_questions)){
	   echo "<h3>".$a_questions['question']."</h3>
		   <form method='POST' action=''>
		   <!-- champ caché contenant l'id de la question aléatoire -->
		   <input type='hidden' name='id_q' value='".$id_question."'>";
	   if(!empty($a_rep)){   
		 foreach($a_rep as $Q){
		   echo "<input type='radio' id='".$Q['id']."' name='reponse' value='".$Q['id']."'/> 
				 <label for='".$Q['id']."'>".$Q['reponse']."</label></br>";
		 }
	   }
	  echo"</br></br>";
	  echo"<input type='submit' name='ok' value='Valider' />";
	  echo "</form>";
	 }
 }else{
?>
<a href='index.php?go_quiz=1' rel="nofollow noopener noreferrer" target="_blank">Commencer le quiz du jour !</a>
<?php
}
?>
 </body>
</html>

  /**
  * Compte le nombre de questions d'un user en fonction de la date
  */
  public function get_nb_rep_user($id_user,$date = NULL){
    $now = $date ? $date : tempo('Y-m-d');
    $sql = "SELECT COUNT(id) AS NB 
            FROM info_user
            WHERE id_user = :id_user
              AND tempo = :now ";
    $datas = array(':id_user'=>$id_user,':now'=>$now);
    $result = $this->queryExec($sql,$datas);
    return !empty($result) ? $result[0]['NB'] : 0;
  }

$id_user = htmlspecialchars($_SESSION['id']);

 
      /**
	*	Enregistrement dans la base de données des questions faites
	*/ 
	  public function get_info_user_question($rep_user,$id_q) {
	  $sql = "INSERT INTO info_user(id_user =:id_user, question_fait =:question_fait, tempo =: tempo)";
	  $datas = array(":id_user"=>$id_user,":question_fait"=>$id_question,":tempo"=>NOW());
	  $result = $this->queryExec($sql,$datas);
	  return !empty($result) ? $result[0]['NB'] : 0;
  }

$id_user  = !empty($_SESSION['id']) ? $_SESSION['id'] : NULL;

 
/**
  * Compte le nombre de questions d'un user en fonction de la date
  */
  public function get_nb_rep_user($id_user,$date = NULL){
    $now = $date ? $date : date('Y-m-d');
    $sql = "SELECT COUNT(id) AS NB 
            FROM info_user
            WHERE id_user = :id_user
              AND  DATE_FORMAT(tempo,'%Y-%m-%d') = :now 
             GROUP BY id_user";
    $datas = array(':id_user'=>$id_user,':now'=>$now);
    $result = $this->queryExec($sql,$datas);
    return !empty($result) ? $result[0]['NB'] : 0;
  }

  /**
  * Récupère une question aléatoire (directement en sql )
  */
  public function get_random_question(){
	$id_user  = !empty($_SESSION['id']) ? $_SESSION['id'] : NULL;
	$sql = "SELECT * FROM questions 
           WHERE id NOT IN (
              SELECT question_fait
              FROM info_user
              WHERE id_user = :id_user
             )
           ORDER BY RAND() LIMIT 1";
		$datas = array(':id_user'=>$id_user);
		$result = $this->querySelect($sql,$datas);
    return !empty($result) ? $result[0] : NULL;
  }

( ! ) Fatal error: Uncaught Error: Call to private method bdd::querySelect() from context 'qcm' in C:\wamp64\www\quizz\qcm.class.php on line 69
( ! ) Error: Call to private method bdd::querySelect() from context 'qcm' in C:\wamp64\www\quizz\qcm.class.php on line 69

<?php
session_start();
include ('cobdd.php');
$nbrQ = $bdd->query('SELECT * FROM questions');
$nbrQ->fetch();
$nbr = $nbrQ->rowCount();
$id_question = mt_rand(1, $nbr);


$req_questions = $bdd->prepare('SELECT * FROM questions WHERE id = ?');
$req_questions->execute(array($id_question));
$Q = $req_questions->fetch();

$req_reponse = $bdd->prepare('SELECT * FROM reponse WHERE id_question = ? ORDER BY RAND()');
$req_reponse->execute(array($id_question));

$verification_succee = $bdd->prepare('SELECT * FROM reponse WHERE id = ?');

?>


<!doctype html>
<html lang="fr">
<head>
  <meta charset="utf-8">
  <title>Page Quiz</title>
  <link rel="stylesheet" href="style.css">
</head>
<body>
<?php 
	
if(isset($_POST['ok']))
{
	$r = $req_reponse->fetch();
if($_POST['reponse'])
{
	$verification_succee->execute(array($_POST['reponse']));
	$V_S = $verification_succee->fetch();
	if($V_S['correct'] == !NULL)
	{
		echo "Bravo bonne réponse !";
	}
	else
	{
		echo "Mauvaise réponse !";
	}
}	
	
}else{	
	
	
?>

<h3><?= $Q['question'] ?></h3>
<?php
while($r = $req_reponse->fetch()){
?>
<form method="POST">
	<input type="radio" id="<?= $r['id'] ?>" name="reponse" value="<?= $r['id'] ?>" /> <label for="<?= $r['id'] ?>"><?= $r['reponse'] ?></label></br>
<?php
}
?>
</br></br>
	<input type="submit" name="ok" value="Valider" />
</form>
<?php
	}
?>

</body>
</html>

<?php
session_start();
include ('cobdd.php');

if(!isset($_SESSION['id']))
{
	header('Location: connex.php');
}

$id_user  = !empty($_SESSION['id']) ? $_SESSION['id'] : NULL;

$nbrQ = $bdd->query('SELECT * FROM questions');
$nbrQ->fetch();
$nbr = $nbrQ->rowCount();
$id_question = mt_rand(1, $nbr);


$req_questions = $bdd->prepare('SELECT * FROM questions WHERE id = ?');
$req_questions->execute(array($id_question));
$Q = $req_questions->fetch();

$req_reponse = $bdd->prepare('SELECT * FROM reponse WHERE id_question = ? ORDER BY RAND()');
$req_reponse->execute(array($id_question));

$verification_succee = $bdd->prepare('SELECT * FROM reponse WHERE id = ?');

$req_q_fait = $bdd->prepare('INSERT INTO info_user(id_user,question_fait,point,tempo) VALUES(:id_user , :id_question , :point, NOW())');

?>


<!doctype html>
<html lang="fr">
<head>
  <meta charset="utf-8">
  <title>Page Quiz</title>
  <link rel="stylesheet" href="style.css">
</head>
<body>
<?php 
	
if(isset($_POST['ok']))
{
	$r = $req_reponse->fetch();
	if($_POST['reponse'])
	{
		$verification_succee->execute(array($_POST['reponse']));
		$V_S = $verification_succee->fetch();
			if($V_S['correct'] == !NULL)
			{
				$point = 1;
				$req_q_fait->execute(array(":id_user"=>$id_user,":id_question"=>$id_question,":point"=>$point));
				echo "Bravo bonne réponse !";
			}
			else
			{
				$point = 0;
				$req_q_fait->execute(array(":id_user"=>$id_user,":id_question"=>$id_question,":point"=>$point));
				echo "Mauvaise réponse !";
			}
	}	
	
}else{	
?>

<h3><?= $Q['question'] ?></h3>
<?php
while($r = $req_reponse->fetch()){
?>
<form method="POST">
	<input type="radio" id="<?= $r['id'] ?>" name="reponse" value="<?= $r['id'] ?>" /> <label for="<?= $r['id'] ?>"><?= $r['reponse'] ?></label></br>
<?php
}
?>
</br></br>
	<input type="submit" name="ok" value="Valider" />
</form>
<?php
	}
?>

</body>
</html>

$req_questions = $bdd->prepare("SELECT * FROM questions NOT IN ('SELECT question_fait FROM info_user WHERE id_user = :id_user') ORDER BY RAND()");
$req_questions->execute(array(":id_user"=>$id_user));
$Q = $req_questions->fetch();

$req_questions = $bdd->prepare("SELECT * FROM questions NOT IN (SELECT question_fait FROM info_user WHERE id_user = :id_user) ORDER BY RAND()");
$req_questions->execute(array(":id_user"=>$id_user));
$Q = $req_questions->fetch();

( ! ) Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'NOT IN ('SELECT question_fait FROM info_user WHERE id_user = :id_user') ORDER BY' à la ligne 1 in C:\wamp64\www\quizz\index.php on line 23
( ! ) PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'NOT IN ('SELECT question_fait FROM info_user WHERE id_user = :id_user') ORDER BY' à la ligne 1 in C:\wamp64\www\quizz\index.php on line 23