File: /home/bibuzptr/elearning.bibu-edu.us/openuni/dashboard/ongoing-course.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"];
}
}
else{
header("Location:../../login.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:../../");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
<title>Student Dashboard | Breakthrough Open University</title>
<link rel="shortcut icon" type="image/x-icon" href="../../assets/img/logo.png">
<link rel="stylesheet" href="../../assets/css/bootstrap.min.css">
<link rel="stylesheet" href="../../assets/plugins/fontawesome/css/fontawesome.min.css">
<link rel="stylesheet" href="../../assets/plugins/fontawesome/css/all.min.css">
<link rel="stylesheet" href="../../assets/css/feather.css">
<link rel="stylesheet" href="../../assets/css/style.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.3/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.min.js"></script>
<style>
<style>
#dash{
background: #102044;
border-left: 6px solid #06bf1c;
color: #fff;
}
.nav-link{
color:#fff;
}
@media (max-width: 392.98px) {
#pgc{
margin-top:50%;
background: #fafafa;
}
}
@media (max-width: 767.98px) {
#pgc{
margin-top:42%;
background: #fafafa;
}
}
@media (max-width: 992.98px) {
#pgc{
margin-top:20%;
background: #fafafa;
}
}
@media (min-width: 992.98px) {
#pgc{
margin-top:11%;
background: #fafafa;
}
}
</style>
</head>
<body>
<div class="main-wrapper">
<?php //include_once("../includes/header-course.php") ?>
<div style="margin-top:0%;" class="course-student-header header-fixed">
<div class="container">
<div class="student-group">
<div class="course-group ">
<div class="course-group-img d-flex">
<a href="../student-profile.php"><img src="../../student-images/<?php echo $icon ?>" alt class="img-fluid"></a>
<div class="d-flex align-items-center">
<div class="course-name">
<h4><a href="../student-profile.php"><?php echo $name ?></a><span><?php echo $admno ?></span></h4>
</div>
</div>
</div>
<!--<div class="course-share ">-->
<!--<a href="javascript:void(0);" class="btn btn-primary">Account Settings</a>-->
<!--</div>-->
</div>
</div>
<!--<div class="my-student-list">-->
<!--<ul>-->
<!--<li><a href="../../">Home</a></li>-->
<!--<li><a href="../../courses">All Courses</a></li>-->
<!--<li><a href="../index.php">Dashboard</a></li>-->
<!--<li><a class="../active" href="my-courses.php">My Courses</a></li>-->
<!--<li><a href="../messages.php">Messages</a></li>-->
<!--<li><a href="../profile.php">Profile</a></li>-->
<!--<li class="mb-0"><a href="../logout.php">Logout</a></li>-->
<!--</ul>-->
<!--</div>-->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark1">
<div class="container-fluid">
<a class="navbar-brand" href="#"></a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNavAltMarkup">
<div class="navbar-nav">
<a class="nav-link" href="../../">Home</a>
<a class="nav-link" href="../../courses">All Courses</a>
<a class="nav-link active" href="../index.php">Dashboard</a>
<a class="nav-link" href="../logout.php">Logout</a>
</div>
</div>
</div>
</nav>
</div>
</div>
<div id="pgc" class="page-content1">
<div class="container">
<div class="row">
<div class="col-xl-12 col-md-12">
<div class="settings-widget">
<div class="settings-inner-blk p-0">
<div class="comman-space pb-0">
<div class="filter-grp ticket-grp d-flex align-items-center justify-content-between">
<h3><?php echo $lb['title'] ?></h3>
</div>
<div class="settings-tickets-blk table-responsive">
<div class="course-feature">
<div class="row">
<?php
$listcat=mysqli_query($con,"SELECT * FROM units WHERE courseid='$courseid' ORDER BY id ASC");
while($lc=mysqli_fetch_assoc($listcat)){
$unitid=$lc["id"];
?>
<div class="col-lg-4 col-md-6 d-flex">
<div style="border: 1px solid #102044; margin:10px" class="course-box d-flex aos" data-aos="fade-up">
<div class="product">
<div class="product-img">
<div style="height:150px">
<a href="../unit-learning?unitid=<?php echo $lc['id'] ?>">
<img class="img-fluid1" alt="<?php echo $lc['title'] ?>" src="../../unit-images/<?php echo $lc['unitimg'] ?>">
</a>
</div>
</div>
<div class="product-content">
<div style="height:60px">
<h3 class="title instructor-text"><a href="../unit-learning?unitid=<?php echo $lc['id'] ?>"><?php echo $lc['unittitle'] ?></a></h3>
</div>
<div style="height:100px">
<p class="title instructor-text"><?php echo substr($lc['unitdesc'],0,150) ?>...</p>
</div>
<div class="course-info d-flex align-items-center">
<div class="rating-img d-flex align-items-center">
<img src="assets/img/icon/icon-01.svg" alt>
<p><?php echo mysqli_num_rows(mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid'")) ?> Lessons</p>
</div>
<div class="course-view d-flex align-items-center">
<img src="assets/img/icon/icon-02.svg" alt>
<p><?php echo $lc['hours'] ?></p>
</div>
</div>
<?php
$lessonsdone=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) as theprogress FROM learningprogress WHERE studentid='$studentid' AND unitid='$unitid'"))["theprogress"];
$listlessons=mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$unitid'");
$nooflessons=mysqli_num_rows($listlessons);
$percentdone=number_format($lessonsdone/$nooflessons*100,2);
//previous
$prevuinit=mysqli_fetch_assoc(mysqli_query($con,"SELECT MAX(id) as prevunit FROM units WHERE id<'$unitid' AND courseid='$courseid' LIMIT 1"))["prevunit"];
$lessonsdone1=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) as theprogress FROM learningprogress WHERE studentid='$studentid' AND unitid='$prevuinit'"))["theprogress"];
$listlessons1=mysqli_query($con,"SELECT * FROM lessons WHERE unitid='$prevuinit'");
$nooflessons1=mysqli_num_rows($listlessons1);
$percentdone1=number_format($lessonsdone1/$nooflessons1*100,2);
?>
<div class="progress-stip">
<div class="progress-bar bg-success progress-bar-striped active-stip1" role="progressbar" aria-valuenow="<?php echo $percentdone ?>"
aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $percentdone ?>%"></div><?php echo $percentdone ?>%
</div>
<br>
<div class="all-btn all-category d-flex align-items-center">
<?php if($prevuinit==""){ ?>
<a href="../unit-learning?unitid=<?php echo $lc['id'] ?>" class="btn btn-enroll w-100">Learn</a>
<?php }else if($percentdone1>=100){ ?>
<a href="../unit-learning?unitid=<?php echo $lc['id'] ?>" class="btn btn-enroll w-100">Learn</a>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include_once("../includes/footer-course2.php") ?>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
</script>
</div>
</body>
</html>