$IdQCM = $_GET["idQCM"]; echo $IdQCM; $_SESSION["idQCM"] = $IdQCM; } else { if (isset($_SESSION["idQCM"])) { $IdQCM = $_SESSION["idQCM"]; echo $IdQCM; } else { echo "erreur ! "; } } ?> </h1> <p><div id="texte"> <?php $qcms = fetchQuestion($link, $IdQCM); //var_dump($qcms); //afficheQcm($qcms); afficheQuestion($qcms, $link); ?> <br /> <form method="link" action="CreaQuestion.php"> <input type="submit" value="Ajouter une question"></form> <form method="link" action="AnnulQCM.php"> <input type="submit" value="Annuler / Tout supprimer"></form> <form method="link" action="index.php"> <input type="submit" value="Sauvegarder et partir"></form> </div></p> </body> </html> <?php function fetchQuestion($link, $IdQCM)
function dbOrAPI($qid, $db) { $sql = 'SELECT is_answered, favorite_count, answer_count, view_count, score, fetch_time, accepted_answer_id, question_id FROM cr_badge WHERE question_id = :qid;'; $stmt = $db->prepare($sql); $result = $stmt->execute(array(':qid' => $qid)); if ($result) { $row = $stmt->fetch(PDO::FETCH_ASSOC); if (!$row) { return fetchQuestion($qid, $db); } if (!$row['question_id']) { return fetchQuestion($qid, $db); } $time = $row['fetch_time']; if ($time < time() - 3600) { // if time was updated more than one hour ago // fetch data again fetchQuestion($qid, $db); } else { useData($row); } } else { return showError($stmt->errorInfo()); } }