prepare('SELECT * FROM Qcm WHERE numQcm= ?'); $stmt->bindParam(1, $_GET['numQcm']); $resultQuestion = $stmt->execute(); $qcmRow = $resultQuestion->fetchArray(); $stmt = $db->prepare('SELECT * FROM QcmQuestion WHERE numQuestion= ? AND numQcm=?'); $stmt->bindParam(1, $_GET['numQuestion']); $stmt->bindParam(2, $_GET['numQcm']); $resultQuestion = $stmt->execute(); $questionRow = $resultQuestion->fetchArray(); $stmt = $db->prepare('SELECT reponse FROM QcmReponse WHERE numQuestion= ? AND numQcm=?'); $stmt->bindParam(1, $_GET['numQuestion']); $stmt->bindParam(2, $_GET['numQcm']); $resultQuestion = $stmt->execute(); while($r = $resultQuestion->fetchArray(SQLITE3_NUM)){ $reponseRow[] = $r[0]; } $stmt = $db->prepare('SELECT count(*) FROM QcmReponse WHERE numQuestion= ? AND numQcm=?'); $stmt->bindParam(1, $_GET['numQuestion']); $stmt->bindParam(2, $_GET['numQcm']); $resultQuestion = $stmt->execute(); $countRow = $resultQuestion->fetchArray(); while($r = $resultQuestion->fetchArray(SQLITE3_NUM)){ $reponseRow[] = $r[0]; } $stmt = $db->prepare('SELECT * FROM QcmCorrection WHERE numQuestion= ? AND numQcm=?'); $stmt->bindParam(1, $_GET['numQuestion']); $stmt->bindParam(2, $_GET['numQcm']); $resultQuestion = $stmt->execute(); $correctRow = $resultQuestion->fetchArray(); ?>

Ajouter une question(QCM)










prepare('SELECT reponse FROM QcmReponse WHERE numQcm=? AND numQuestion=? AND numReponse=?'); $stmt->bindParam(1, $_GET['numQcm']); $stmt->bindParam(2, $_GET['numQuestion']); $stmt->bindParam(3, $i); $resultQuestion = $stmt->execute(); $repRow = $resultQuestion->fetchArray(); ?> prepare('SELECT reponse,points FROM QcmReponse WHERE numQcm=? AND numQuestion=? AND numReponse=?'); $stmt->bindParam(1, $_GET['numQcm']); $stmt->bindParam(2, $_GET['numQuestion']); $stmt->bindParam(3, $i); $resultQuestion = $stmt->execute(); $repRow = $resultQuestion->fetchArray(); ?>