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 : Formtest.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"];
            if (!in_array($_SESSION["lms-status"], array("teacher", "Admin"))) {
                header("Location: index");
            }
            $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;
        }
    }
    if(isset($_GET['ID']) && $_GET['type'] == 'delete'){
        $sql = 'DELETE FROM `couse` WHERE `ID` = "'.$_GET['ID'].'"';
        $result = $db->query($sql);
        if($result){
            echo '<script>alert("ลบข้อมูลสำเร็จ!")</script>';
        }
    }
?>
    <!DOCTYPE html>
    <html lang="en">

<body>

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

<h1 class="text-center  my-3">เลือกคอร์สเพื่อสร้างแบบทดสอบ</h1>
                <div class="row">
                    <?php
                    $query = $db->query("SELECT * FROM couse where userID = '$userID'");
                    foreach ($query as $row) {
                        $query2 = $db->query("SELECT * FROM lesson WHERE couseID = '" . $row['ID'] . "' ");
                        $lessonCount = $query2->rowCount();

$query3 = $db->query("SELECT * FROM `questions` WHERE `couse` = '" . $row['ID'] . "' ");
                        $questionCount = $query3->rowCount();

// get user name and avatar
                        $query4 = $db->query("SELECT * FROM user WHERE ID = '" . $row['userID'] . "' ");
                        $user = $query4->fetch(PDO::FETCH_ASSOC);

$name_user = $user['name'];
                        $avatar_user = $user['avatar'];

?>
                        <div class="col-md-4 col-lg-3 pb-4">
                            <a href="ManageCouse?ID=<?php echo $row['ID'] ?>">
                                <div class="card" style="width: 100%">

<img src="<?php echo $row['filetitle'] ?>" class="card-img-top" alt="...">
                                    <div class="card-body">
                                        <div class="title"><?php echo $row['Unitname'] ?>
                                            <span> <a href="EditCouse?id=<?php echo $row['ID'] ?>
"> <i class="fa-regular fa-pen-to-square text-primary"></i></a></span>

</div>
                                        <div class="detail"><span>
                                                <?php
                                                $input = $row['detail'];
                                                $limited_input = mb_substr($input, 0, 50, 'UTF-8');
                                                echo $limited_input;
                                                if (strlen($input) > 50) {
                                                    echo '...';
                                                }
                                                ?></span></div>

<div class="count_text">
                                            <span class="text-muted">บทเรียนทั้งหมด <?php echo $lessonCount ?> บท</span>
                                            <span class="text-muted">แบบฝึกหัด ก่อนเรียน-หลังเรียน <?php echo $questionCount ?> ข้อ</span>
                                        </div>
                                        <div class="profile-buttom">
                                                   <img src="<?php echo $avatar_user ?>"  width="30px" alt="">
                                                    <span><?php echo $name_user ?></span>
                                        </div>
                                        
                <div class="statistics">
                    <div class="star">
                        <i class="fa-solid fa-star" style="color: #ffc107;"></i>
                        <span>0</span>
                    </div>
                    <div class="comment">
                        <i class="fa-solid fa-comment" style="color: #6c757d;"></i>
                        <span>0</span>
                    </div>
                    <div class="user">
                        <i class="fa-solid fa-user" style="color: #0d6efd;"></i>
                        <span>0</span>
                    </div>
                </div>
                <div align="right">
                    <a href="?ID=<?php echo $row['ID'];?>&type=delete" onclick="return confirm('ยืนยันการลบข้อมูล!');" class="btn btn-danger">ลบคอร์ส</a>
                </div>
                                        <div class="bottom">
                                            <div class="right"><a href="FormtestEdit?ID=<?php echo $row['ID'] ?>">จัดการแบบทดสอบ</a></div>
                                        </div>
                                    </div>
                                </div>
                            </a>
                        </div>
                    <?php } ?>
                </div>

</div>
        </div>

<?php require_once("page/footer.php") ?>
        <?php if (isset($_SESSION["lms-AuthToken"])) { ?>
            <script type="text/javascript">
                localStorage.setItem("AuthToken", "<?= $_SESSION["lms-AuthToken"] ?>")
            </script>
        <?php } else { ?>
            <script type="text/javascript">
                localStorage.removeItem("AuthToken")
            </script>
        <?php } ?>

</body>

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

${this.title}

Code Editor : Formtest.php