R E D

NAME	SIZE	PERMISSION
index.css	5.86 KB	-rwxr-xr-x
index.js	0 B	-rwxr-xr-x
index.php	6.72 KB	-rwxr-xr-x

Code Editor : index.php

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

<h1 class="text-center  my-3">คอร์สเรียน</h1>
        <div class="row">
            <?php
            $query = $db->query("SELECT * FROM couse");
            foreach ($query as $row) {
                $id_couse = $row['ID'];
                $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">

<img src="<?php echo $row['filetitle'] ?>" class="card-img-top" alt="...">
                        <div class="card-body" style="cursor: context-menu !important">
                            <div class="title">
                                <a href="StudyCouse?id=<?php echo $id_couse ?>">
                                    <?php echo $row['Unitname'] ?>
                                </a>
                            </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>
                            
                            <li><a href="<?php echo $row['value']; ?>" target="_blank" style="color:blue;">เอกสารประกอบการเรียน</a></li>
                            <li><a href="<?php echo $row['value_media']; ?>" target="_blank" style="color:blue;">สื่อนวัตกรรม</a></li>
                            <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>
                                    <?php
                                    $query6 = $db->query("SELECT * FROM bookcouse WHERE cid = '$id_couse' ");
                                    $userCount = $query6->rowCount();
                                    ?>
                                    <span><?php echo $userCount ?></span>
                                </div>
                            </div>

<div class="btn-buttom">
                                <?php
                                // check user is access couse
                                //SELECT * FROM `bookcouse` WHERE `cid` = 5 AND `student` = 11
                                $query5 = $db->query("SELECT * FROM bookcouse WHERE cid = '$id_couse' AND student = '" . $_SESSION["lms-ID"] . "' ");
                                $isAccess = $query5->rowCount();
                                if ($isAccess > 0) {
                                    // Check if you have done the test before studying or not.
                                    $count_quiz = $db->query("SELECT * FROM `questions` WHERE `couse` = '$id_couse' ");
                                    $query6 = $db->query("SELECT * FROM `user_answers` WHERE `couse` = '$id_couse' AND `user_id` = '" . $_SESSION["lms-ID"] . "' and `type_quiz` = 'before' ");
                                    $isTest = $query6->rowCount();
                                    if ($isTest > 0) {
                                        echo '<a href="StudyCouse?id=' . $id_couse . '" class="btn btn-success btn-block" style=" color: white; "><f class="fa-solid fa-book"></f> เรียนคอร์สนี้</a>';
                                    } else {
                                        echo '<a href="Quiz?id=' . $id_couse . '&type=before" class="btn btn-info btn-block" style=" color: white; "><f class="fa-solid fa-book"></f> เริ่มต้นเรียนคอร์สนี้</a>';
                                    }
                                } else {
                                ?>
                                    <a href="StudyCouse?id=<?php echo $id_couse ?>" class="btn btn-danger btn-block disabled" style=" color: white; ">
                                        <f class="fa-solid fa-lock"></f> ไม่มีสิทธิ์เข้าเรียน
                                    </a>
                                <?php } ?>
                            </div>

</div>
                    </div>

</div>
            <?php } ?>
        </div>

</div>
</div>

${this.title}

Code Editor : index.php