File: /home/bibuzptr/elearning.bibu-edu.us/current/student/learn.php
<?php
ob_start();
session_start();
include_once('../includes/db_connect.php');
$today = date('Y-m-d');
$now = date('Y-m-d H:i:s');
$year = date("Y");
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)){
$studentid = $row["id"];
$name = $row["name"];
$admno = $row["admno"];
$icon = $row["icon"];
}
$courseid=$_GET["course"];
$lessonid=$_GET["lesson"];
$lessonid1=$lessonid;
$lb=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM courses WHERE id='$courseid'"));
$le=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM lessons WHERE id='$lessonid'"));
$unitid=$le["unitid"];
$unitid1=$le["unitid"];
$unitdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM units WHERE id='$unitid'"));
$courseid=$unitdetails["courseid"];
$unittitle=$unitdetails["unittitle"];
$thenextid=mysqli_fetch_assoc(mysqli_query($con,"SELECT lessons.id AS nextid FROM lessons,units WHERE lessons.id>'$lessonid' AND lessons.unitid=units.id AND units.courseid='$courseid' ORDER BY lessons.id ASC LIMIT 1"))["nextid"];
if($thenextid!=""){
$thenextid=$thenextid;
}else{
$thenextid="0";
}
$theprevid=mysqli_fetch_assoc(mysqli_query($con,"SELECT lessons.id AS nextid FROM lessons,units WHERE lessons.id<'$lessonid' AND lessons.unitid=units.id AND units.courseid='$courseid' ORDER BY lessons.id ASC LIMIT 1"))["nextid"];
if($theprevid!=""){
$theprevid=$theprevid;
}else{
$theprevid="0";
}
//$course
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM mycourses WHERE courseid='$courseid' AND studentid='$studentid'"))>0){
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM unitlearning WHERE unitid='$unitid' AND studentid='$studentid'"))<1){
mysqli_query($con,"INSERT INTO unitlearning(unitid,studentid,courseid) VALUES('$unitid','$studentid','$courseid')");
}
}else{
header("Location:dashboard/");
}
$catid=$lb["category"];
$catdetails=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM categories WHERE id='$catid'"));
}
else{
header("Location:../login.php");
}
?>
<!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 Open 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="../assets/img/logo.png">
<!-- Place favicon.ico in the root directory -->
<!-- CSS here -->
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/animate.min.css">
<link rel="stylesheet" href="css/aos.min.css">
<link rel="stylesheet" href="css/magnific-popup.css">
<link rel="stylesheet" href="css/icofont.min.css">
<link rel="stylesheet" href="css/slick.css">
<link rel="stylesheet" href="css/swiper-bundle.min.css">
<link rel="stylesheet" href="css/plugins_plyr.css">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.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="../assets/img/logo.png" alt="Preload">
</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 -->
<!-- tution__section__start -->
<div class="tution sp_bottom_100 sp_top_50">
<div class="container-fluid full__width__padding">
<div class="row">
<div class="col-xl-4 col-lg-12 col-md-12 col-sm-12 col-12" data-aos="fade-up">
<div class="accordion content__cirriculum__wrap" id="accordionExample">
<?php
$num=0;
$listunits=mysqli_query($con,"SELECT * FROM units WHERE courseid='$courseid' ORDER by id ASC");
while($lu=mysqli_fetch_assoc($listunits)){
$unitid=$lu["id"];
$num++;
if($num=="1"){
$show="show";
}else{
$show="";
}
?>
<div class="accordion-item">
<h2 class="accordion-header" id="heading<?php echo $unitid ?>">
<button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapse<?php echo $unitid ?>" aria-expanded="true" aria-controls="collapse<?php echo $unitid ?>">
<?php echo $lu["unittitle"] ?>
</button>
</h2>
<div id="collapse<?php echo $unitid ?>" class="accordion-collapse collapse <?php echo $show ?>" aria-labelledby="heading<?php echo $unitid ?>" data-bs-parent="#accordionExample">
<div class="accordion-body">
<?php
$listlessons=mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid'");
while($ll=mysqli_fetch_assoc($listlessons)){
$lessonid=$ll["id"];
?>
<div class="scc__wrap">
<div class="scc__info">
<?php
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM learningprogress WHERE lessonid='$lessonid' AND studentid='$studentid'"))>0){
?>
<i class="fa fa-check"></i>
<h5> <a href="learn?lesson=<?php echo $lessonid ?>&&course=<?php echo $courseid ?>"><span><?php echo $ll["lessontitle"] ?></span></a></h5>
</div>
<div class="scc__meta">
<a href="learn?lesson=<?php echo $lessonid ?>&&course=<?php echo $courseid ?>"><span class="question"><i class="icofont-eye"></i> click to open</span></a>
</div>
<?php }else{ ?>
<i class="fa fa-spinner"></i>
<h5> <a title="You have to read previous lessons and click next at the bottom of the page"><span><?php echo $ll["lessontitle"] ?></span></a></h5>
</div>
<div class="scc__meta">
<a title="You have to read previous lessons and click next"><span class="question"><i class="fa fa-lock"></i></span></a>
</div>
<?php } ?>
</div>
<?php } ?>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<div class="col-xl-8 col-lg-12 col-md-12 col-sm-12 col-12" data-aos="fade-up">
<div class="lesson__content__main dashboard__inner">
<h2 class="heading"><li><?php echo $lb['title'] ?></li></h2>
<?php
// $lessonsdone=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) as theprogress FROM learningprogress WHERE studentid='$studentid' AND courseid='$courseid'"))["theprogress"];
$lessonsdone=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(learningprogress.id) as theprogress FROM learningprogress,units WHERE learningprogress.studentid='$studentid' AND units.courseid='$courseid' AND learningprogress.unitid=units.id"))["theprogress"];
$listlessons=mysqli_query($con,"SELECT lessons.* FROM lessons,units WHERE lessons.unitid=units.id AND units.courseid='$courseid'");
$nooflessons=mysqli_num_rows($listlessons);
$percentdone=number_format($lessonsdone/$nooflessons*100,2);
?>
<div class="progress-stip">
<div class="progress-bar bg-success progress-bar-striped active-stip" role="progressbar" aria-valuenow="<?php echo $percentdone ?>"
aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $percentdone ?>%"></div><?php echo $percentdone ?>%
</div>
<div class="lesson__content__wrap">
<h3>
<?php
echo $le["lessontitle"]
?>
</h3>
</div>
<div class="plyr__video-embed rbtplayer about__text__5">
<p style="margin-top:30px"> </p>
<p>
<?php echo $le["lessondesc"] ?>
</p>
<hr>
<div style="min-height:600px;max-height: 1000px; overflow-y: scroll;" class="introduct-video">
<p><?php
if($le["lessonlink"]!=""){ ?>
<iframe style="height:600px" width="100%" src='<?php echo $le["lessonlink"] ?>' title="Diploma In Curriculum Development" allowfullscreen>
</iframe>
<?php }else{
echo $le["lessonnotes"];
}
?></p>
<p>
<?php
if($le["lessonvideo"]!=""){ ?>
<h3>Lesson Video</h3>
<!--<video width="640" height="360" controls loop muted poster="thumbnail.jpg">-->
<source src="../lesson-images/<?php // echo $le['lessonvideo'] ?>" type="video/mp4">
<source src="../lesson-images/<?php // echo $le['lessonvideo'] ?>" type="video/webm">
<!--</video> -->
<iframe
src='<?php echo $le["lessonvideo"] ?>'
width="640"
height="360"
frameborder="0"
allowfullscreen>
</iframe>
<? }
?>
</p>
<?php
$quizquery=mysqli_query($con,"SELECT * FROM docquizs WHERE doclessonid='$leid'");
if(mysqli_num_rows($quizquery)>0){
$val="0";
?>
<div>
<h3>Lesson Quiz</h3>
<?php while($qq=mysqli_fetch_assoc($quizquery)){
$quizid=$qq["id"];
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM quizanswer WHERE quizid='$quizid' AND studentid='$studentid'"))>0){
$val="1";
?>
<p>You have already uploaded your answers</p>
<input type="hidden" value="1" class="submitted">
<?php }else{ ?>
<p><?php echo $qq["docessay"] ?></p>
<form method="post" id="essaysubmit" enctype="multipart/form-data">
<label>Attach Document with Answers</label>
<input type="hidden" value="<?php echo $qq['id'] ?>" name="quizid">
<input type="hidden" value="<?php echo $leid ?>" name="lessonid">
<input type="hidden" value="<?php echo $studentid ?>" name="studentid">
<input type="file" class="form-control" name="docanswer" id="docanswer" required>
<button type="submit" class="btn btn-success btn-md">Submit Document</button>
<p id="status12"></p>
</form>
<input type="hidden" value="0" class="submitted">
<?php }} ?>
</div>
<?php }else{
$val="1";
?>
<input type="hidden" value="1" class="submitted">
<?php } ?>
</div>
<p>
<a class="previousid default__button"><i class="fa fa-arrow-left"> </i>Previous Lesson</a>
<a style="margin-left:50%" class="nextid default__button"><i class="fa fa-arrow-right"> </i>Next Lesson</a>
</p>
<p style="color:#fff" id="status11"></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- tution__section__end -->
<!-- footer__section__start -->
<?php include_once("includes/footer.php") ?>
<!-- footer__section__end -->
</main>
<!-- JS here -->
<script src="js/vendor/modernizr-3.5.0.min.js"></script>
<script src="js/vendor/jquery-3.6.0.min.js"></script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/isotope.pkgd.min.js"></script>
<script src="js/slick.min.js"></script>
<script src="js/jquery.meanmenu.min.js"></script>
<script src="js/ajax-form.js"></script>
<script src="js/wow.min.js"></script>
<script src="js/jquery.scrollUp.min.js"></script>
<script src="js/imagesloaded.pkgd.min.js"></script>
<script src="js/jquery.magnific-popup.min.js"></script>
<script src="js/waypoints.min.js"></script>
<script src="js/jquery.counterup.min.js"></script>
<script src="js/plugins.js"></script>
<script src="js/swiper-bundle.min.js"></script>
<script src="js/plugin_plyr.js" ></script>
<script src="js/main.js"></script>
<script>
$(".nextid").click(function(){
var lessonid=<?php echo $lessonid1 ?>//$(this).attr("id");
var nextid=<?php echo $thenextid ?>//$(this).attr("data-next");
var unitid="<?php echo $unitid1 ?>"
var studentid="<?php echo $studentid ?>"
//var submitted=$(".submitted").val()
var submitted="<?php echo $val ?>"
if(submitted=="1" ){
$("#status11").html("<p style='color:#fff' class='bg-success'><i class='fa fa-spinner fa-pulse'></i> Updating. Please wait...</p>");
$.ajax({
url : "app/unit-progress",
type: "POST",
data : {lessonid:lessonid,nextid:nextid,studentid:studentid,unitid:unitid}
}).done(function(data){
if(data.status == "200"){
$("#status11").html("");
// $('#myDiv').delay(5).load('unit-learning?unitid='+unitid);
//$("#status11").html("<p class=' bg-success'><i class='fa fa-check'></i> quiz saved successfully.</p>");
if(nextid!="0"){
window.location.replace("learn?lesson=<?php echo $thenextid ?>&&course=<?php echo $courseid ?>");
}else{
alert("You have reached to the end of this course")
}
}
if(data.message == "ERROR"){
//$("#status11").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
}else{
$("#status11").html("<p style='color:#fff' class=' bg-danger'><i class='fa fa-exclamation-circle'></i> You must submit the lesson assignments before clicking next.</p>");
}
})
$(".previousid").click(function(){
var lessonid=<?php echo $lessonid ?>//$(this).attr("id");
var previd=<?php echo $theprevid ?>//$(this).attr("data-next");
var unitid="<?php echo $unitid1 ?>"
var studentid="<?php echo $studentid ?>"
//var submitted=$(".submitted").val()
var submitted="<?php echo $val ?>"
//if(submitted=="1" ){
$("#status11").html("<p class='bg-success' style='color:#fff'><i class='fa fa-spinner fa-pulse'></i> Updating. Please wait...</p>");
$.ajax({
url : "app/unit-progress",
type: "POST",
data : {lessonid:lessonid,previd:previd,studentid:studentid,unitid:unitid}
}).done(function(data){
if(data.status == "200"){
$("#status11").html("");
// $('#myDiv').delay(5).load('unit-learning?unitid='+unitid);
//$("#status11").html("<p class=' bg-success'><i class='fa fa-check'></i> quiz saved successfully.</p>");
if(previd!="0"){
window.location.replace("learn?lesson=<?php echo $theprevid ?>&&course=<?php echo $courseid ?>");
}else{
alert("You have reached to the end of this course")
}
}
if(data.message == "ERROR"){
//$("#status11").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> An error occured, please try again later.</p>");
}
});
// }else{
// $("#status11").html("<p class=' bg-danger'><i class='fa fa-exclamation-circle'></i> You must submit the lesson assignments before clicking next.</p>");
// }
})
</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>
</body>
</html>