File: //home/bibuzptr/elearning.bibu-edu.us/student/grades.php
<?php
session_start();
include_once("../includes/db_connect.php");
$expld_url = $_SERVER["REQUEST_URI"];//explode("/", $_SERVER["REQUEST_URI"]);
if($_GET['fbclid']){
$url= $expld_url;
$pos = strpos($url, "?");
$url = substr($url, 0, $pos);
}else{
$url= $expld_url;
}
$expld_url = explode("/", $url);
$url = end($expld_url);
if(!empty($url)){
$lb=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM courses WHERE url='$url'"));
$courseid=$lb["id"];
$catid=$lb["category"];
$catdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM categories WHERE id='$catid'"));
}else{
header("Location:../");
}
//check student logged in
if(isset($_SESSION["OpenUniS^###DHSG"])){
$email = $_SESSION["OpenUniS^###DHSG"];
$chkuser = mysqli_query($con,"SELECT * FROM students WHERE email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$stdid = $row["id"];
$studentid=$stdid;
$id = $row["id"];
$name = $row["name"];
$admno = $row["admno"];
$icon = $row["icon"];
}
}
?>
<!doctype html>
<html class="no-js" lang="zxx">
<head>
<meta charset="utf-8">
<meta http-equiv="x-ua-compatible" content="ie=edge">
<title><?php echo $lb['title'] ?> | Breakthrough International Bible College & University</title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="shortcut icon" type="image/x-icon" href="https://www.elearning.bibu-edu.us/img/favicon.ico">
<!-- Place favicon.ico in the root directory -->
<!-- CSS here -->
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/bootstrap.min.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/animate.min.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/aos.min.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/magnific-popup.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/icofont.min.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/slick.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/swiper-bundle.min.css">
<link rel="stylesheet" href="https://www.elearning.bibu-edu.us/student/css/style.css">
<script>
// On page load or when changing themes, best to add inline in `head` to avoid FOUC
if (localStorage.getItem("theme-color") === "dark" || (!("theme-color" in localStorage) && window.matchMedia("(prefers-color-scheme: dark)").matches)) {
document.documentElement.classList.add("is_dark");
}
if (localStorage.getItem("theme-color") === "light") {
document.documentElement.classList.remove("is_dark");
}
</script>
</head>
<body class="body__wrapper">
<!-- pre loader area start -->
<div id="back__preloader">
<div id="back__circle_loader"></div>
<div class="back__loader_logo">
<img loading="lazy" src="https://www.elearning.bibu-edu.us/assets/img/logo.png" alt="Preload">
</div>
</div>
</div>
<!-- pre loader area end -->
<main class="main_wrapper overflow-hidden">
<?php include_once("includes/header.php") ?>
<!-- theme fixed shadow -->
<div>
<div class="theme__shadow__circle"></div>
<div class="theme__shadow__circle shadow__right"></div>
</div>
<!-- theme fixed shadow -->
<!-- breadcrumbarea__section__start -->
<div class="breadcrumbarea">
<div class="container">
<div class="row">
<div class="col-xl-12">
<div class="breadcrumb__content__wraper" data-aos="fade-up">
<div class="breadcrumb__title">
<h2 class="heading"><li><?php echo $lb['title'] ?></li></h2>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- breadcrumbarea__section__end-->
<div class="blogarea__2">
<div class="container">
<div class="row">
<div class="col-xl-3 col-lg-3 col-md-12">
<?php include_once("includes/aside.php") ?>
</div>
<div class="col-xl-9 col-lg-9">
<div class="blogarae__img__2 course__details__img__2 dashboard__inner sticky-top" data-aos="fade-up">
<img style="max-height:150px; object-fit:contain" loading="lazy" src="https://www.elearning.bibu-edu.us/course-images/<?php echo $lb['courseimage'] ?>" alt="<?php echo $lb['title'] ?>">
</div>
<div class="blog__details__content__wraper dashboard__inner sticky-top">
<div class="course__button__wraper" data-aos="fade-up">
<div class="course__button">
<a target="_blank" href="https://www.elearning.bibu-edu.us/academic-programs/<?php echo $catdetails["url"] ?>"><?php echo $catdetails['name'] ?></a>
</div>
</div>
<div class="course__details__heading" data-aos="fade-up">
<h3>Grades</h3>
</div>
<div class="course__details__price" data-aos="fade-up">
<table id="dataTable12" class="table table-striped table-nowrap mb-2">
<thead>
<th>Unit</th>
<th>Lesson</th>
<th>Question</th>
<th>Student Score / Max Score</th>
<th>Date Graded</th>
</thead>
<tbody>
<?php
$assq=mysqli_query($con,"SELECT quizanswer.*,lessons.lessontitle,units.unittitle,docquizs.docmarks,docquizs.docessay FROM quizanswer,lessons,units,docquizs WHERE quizanswer.quizid=docquizs.id AND quizanswer.lessonid=lessons.id AND lessons.unitid=units.id AND quizanswer.marks!='' AND studentid='$studentid' AND lessonid IN (SELECT lessons.id FROM lessons, units WHERE lessons.unitid=units.id AND units.courseid='$courseid') ORDER BY quizanswer.id DESC");
while($aq=mysqli_fetch_assoc($assq)){
?>
<tr>
<td><?php echo $aq["unittitle"] ?></td>
<td><?php echo $aq["lessontitle"] ?></td>
<td><?php echo $aq["docessay"] ?></td>
<td><?php echo $aq["marks"]."/".$aq["docmarks"] ?></td>
<td><?php echo date("d/m/Y",strtotime($aq["gradedon"])) ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- footer__section__start -->
<?php include_once("includes/footer.php") ?>
<!-- footer__section__end -->
</main>
<!-- JS here -->
<script src="https://www.elearning.bibu-edu.us/student/js/vendor/modernizr-3.5.0.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/vendor/jquery-3.6.0.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/popper.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/bootstrap.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/isotope.pkgd.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/slick.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/jquery.meanmenu.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/ajax-form.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/wow.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/jquery.scrollUp.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/imagesloaded.pkgd.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/jquery.magnific-popup.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/waypoints.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/jquery.counterup.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/plugins.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/swiper-bundle.min.js"></script>
<script src="https://www.elearning.bibu-edu.us/student/js/main.js"></script>
<script>
// On page load or when changing themes, best to add inline in `head` to avoid FOUC
if (localStorage.getItem("theme-color") === "dark" || (!("theme-color" in localStorage) && window.matchMedia("(prefers-color-scheme: dark)").matches)) {
document.getElementById("light--to-dark-button")?.classList.add("dark--mode");
}
if (localStorage.getItem("theme-color") === "light") {
document.getElementById("light--to-dark-button")?.classList.remove("dark--mode");
}
</script>
<?php mysqli_close($con) ?>
</body>
</html>