R E D

NAME	SIZE	PERMISSION
API	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
backup	[ DIR ]	drwxr-xr-x
file	[ DIR ]	drwxr-xr-x
mpdf	[ DIR ]	drwxr-xr-x
multiple_dropdown-master	[ DIR ]	drwxr-xr-x
page	[ DIR ]	drwxr-xr-x
plugin	[ DIR ]	drwxr-xr-x
server	[ DIR ]	drwxr-xr-x
template	[ DIR ]	drwxr-xr-x
vendor	[ DIR ]	drwxr-xr-x
.DS_Store	11.98 KB	-rwxr-xr-x
.gitattributes	66 B	-rwxr-xr-x
.htaccess	89 B	-rwxr-xr-x
Addcouse.php	3.71 KB	-rwxr-xr-x
Category.php	3.34 KB	-rwxr-xr-x
EditCouse.php	3.54 KB	-rwxr-xr-x
ErrReport.php	3.8 KB	-rwxr-xr-x
FormDetail.php	3.72 KB	-rwxr-xr-x
Formtest.php	8.69 KB	-rwxr-xr-x
FormtestEdit.php	3.73 KB	-rwxr-xr-x
LICENSE	1.05 KB	-rwxr-xr-x
ManageCouse.php	4.55 KB	-rwxr-xr-x
Quiz.php	9.4 KB	-rwxr-xr-x
Quiz_bak.php	9.08 KB	-rwxr-xr-x
StudyCouse.php	4.15 KB	-rwxr-xr-x
StudyViewCouse.php	4.16 KB	-rwxr-xr-x
ViewCouseMe.php	1.83 KB	-rwxr-xr-x
ViewsCouse-ok.php	1.84 KB	-rwxr-xr-x
ViewsCouse.php	4.15 KB	-rwxr-xr-x
composer.json	164 B	-rwxr-xr-x
composer.lock	64.38 KB	-rwxr-xr-x
connect.php	283 B	-rwxr-xr-x
couse.php	3.93 KB	-rwxr-xr-x
cousenew.php	3.93 KB	-rwxr-xr-x
dashboard.php	3.58 KB	-rwxr-xr-x
get_amphure.php	266 B	-rwxr-xr-x
get_district.php	265 B	-rwxr-xr-x
index.php	3.96 KB	-rwxr-xr-x
login.php	1.54 KB	-rwxr-xr-x
logout.php	149 B	-rwxr-xr-x
register.php	1.53 KB	-rwxr-xr-x
reset.php	1.54 KB	-rwxr-xr-x
setting.php	4.38 KB	-rwxr-xr-x
subject.php	3.33 KB	-rwxr-xr-x
test.js	1.04 KB	-rwxr-xr-x
verify.php	1.28 KB	-rwxr-xr-x

Code Editor : Quiz_bak.php

<?php
try {
    require_once("server/server.php");
    if (!isset($_SESSION["lms-login"])) {
        $helper = array_keys($_SESSION);
        foreach ($helper as $key) {
            unset($_SESSION[$key]);
        }
        header("location: login");
    } else {
        $id = $_SESSION["lms-ID"];
        $query = $db->query("SELECT * FROM user WHERE ID = '$id'");
        if ($query->rowCount() == 0) {
            $helper = array_keys($_SESSION);
            foreach ($helper as $key) {
                unset($_SESSION[$key]);
            }
            header("location: login");
        } else {
            $data = $query->fetch(PDO::FETCH_ASSOC);
            $_SESSION["lms-ID"] = $data["ID"];
            $_SESSION["lms-name"] = $data["name"];
            $_SESSION["lms-avatar"] = $data["avatar"];
            $_SESSION["lms-email"] = $data["email"];
            $_SESSION["lms-status"] = $data["status"];
            $_SESSION["lms-verify"] = $data["verify"];
            $userID = $data["ID"];
            $query = $db->prepare("SELECT * FROM status WHERE userID = '$userID'");
            $arr = array();
            if ($query->execute()) {
                while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                    array_push($arr, $row);
                }
            }
            $_SESSION["lms-allow"] =  $arr;
        }
    }
?>
    <!DOCTYPE html>
    <html lang="en">

<body>

<?php require_once("page/nav.php") ?>
        <?php require_once("page/sidebar.php") ?>
        <link rel="stylesheet" href="page/Quiz/index.css">

<?php
        $id_test = $_GET['id'];
        $type_use = $_GET['type'];
        $type = $_GET['type'];

if($type == "before"){
            $type = "ก่อนเรียน";
        }else{
            $type = "หลังเรียน";
        }

//get course name
        $query = $db->query("SELECT * FROM `couse` WHERE `ID` = '$id_test'");
        $data = $query->fetch(PDO::FETCH_ASSOC);
        $name_test = $data['Unitname'];

<div class="container-fluid p-0 m-0">
            <div class="body-content">
                <h4 class="text-center  my-3">คุณต้องทำแบบทดสอบ <?php echo $type; ?> ของ <?php echo $name_test; ?></h4> 
                <form id="question-test">
                    <?php
                        //count question
                        $query = $db->query("SELECT * FROM `questions` WHERE `couse` = '$id_test' ORDER BY 'no_question' ASC");
                        // $data = $query->fetch(PDO::FETCH_ASSOC);
                        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                    ?> 
                    <div class="main_card">
                        <div class="card" style="width: 50%;position: relative;">
                            <div class="question-box">
                                <input type="hidden" name="id_test" value="<?php echo $id_test; ?>">
                                <input type="hidden" name="no_question" value="<?php echo $row['no_question']; ?>">
                                <input type="hidden" name="user" value="<?php echo $_SESSION['lms-ID']; ?>">
                                <input type="hidden" name="type" value="<?php echo $type_use; ?>">
                        
                                <h3><?php echo $row['question_text']; ?></h3>
                                
                                <div class="answer-options" id="answer-options">
                                    <?php
                                    //get choice
                                    $query2 = $db->query("SELECT * FROM `choices` WHERE `no_couse` = '$id_test' AND `no_question` = '$row[no_question]'");
                                    while ($data = $query2->fetch(PDO::FETCH_ASSOC)) {
                                    ?>
                                    <label>
                                        <input type="radio" name="answer" value="<?php echo $data['no_choice']; ?>">
                                        <?php echo $data['choice_text']; ?>
                                    </label>
                                    <?php } ?>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php } ?>
                </form>
                <?php if($query->rowCount() > 0){?>
                <div class="row">
                    <div class="col-12 alert" align="right">
                        <button type="button" class="btn btn-primary col-2" onclick="nextQuestion()">ทำแบบทดสอบก่อนเรียน</button>
                    </div>
                </div>
                <?php } else {?>
                    <div class="alert alert-danger">ไม่พบแบบทดสอบก่อนเรียน!</div>
                <?php } ?>
            </div>
        </div>

</body>

</html>
<?php } catch (PDOException $exception) {
    echo $exception->getMessage();
    exit;
}
?>

${this.title}

Code Editor : Quiz_bak.php