コード例 #1
0
ファイル: visuCreaQCM.php プロジェクト: ThomasGille/Ulysse
    $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)
コード例 #2
0
ファイル: index.php プロジェクト: Zomis/CodeReview-Shield
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());
    }
}