File: /home/bibuzptr/tvetelearning.bibu-edu.us/current elearning/course-details.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"];
$id = $row["id"];
$name = $row["name"];
}
}
?>
<!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><?php echo $lb['title'] ?>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/owl.carousel.min.css">
<link rel="stylesheet" href="../assets/css/owl.theme.default.min.css">
<link rel="stylesheet" href="../assets/plugins/slick/slick.css">
<link rel="stylesheet" href="../assets/plugins/slick/slick-theme.css">
<link rel="stylesheet" href="../assets/plugins/select2/css/select2.min.css">
<link rel="stylesheet" href="../assets/plugins/aos/aos.css">
<link rel="stylesheet" href="../assets/css/style.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
</head>
<body>
<div class="main-wrapper">
<?php include_once("includes/header-course.php") ?>
<div style="display:none" class="breadcrumb-bar">
<div class="container">
<div class="row">
<div class="col-md-12 col-12">
<div class="breadcrumb-list">
<nav aria-label="breadcrumb" class="page-breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.html">Home</a></li>
<li class="breadcrumb-item" aria-current="page">Courses</li>
<li class="breadcrumb-item" aria-current="page">All Courses</li>
<li class="breadcrumb-item" aria-current="page">The Complete Web Developer Course 2.0</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
</div>
<div style="margin-top:6%" class="inner-banner">
<div class="container">
<div class="row">
<div class="col-lg-8">
<div class="instructor-wrap border-bottom-0 m-0">
<span class="web-badge mb-3">
<a style="color:#fff" href="../academic-programs/<?php echo $catdetails["url"] ?>"><?php echo $catdetails['name'] ?></a>
</span>
</div>
<h2><?php echo $lb['title'] ?></h2>
<p><?php echo substr($lb['shortdescription'],0,400) ?></p>
<div class="course-info d-flex align-items-center border-bottom-0 m-0 p-0">
<div class="cou-info">
<img src="../assets/img/icon/icon-01.svg" alt>
<p><?php echo mysqli_num_rows(mysqli_query($con,"SELECT * FROM units WHERE courseid='$courseid'")) ?> Units</p>
</div>
<div class="cou-info">
<img src="../assets/img/icon/timer-icon.svg" alt>
<p><?php echo $lb['hours'] ?></p>
</div>
<div class="cou-info">
<img src="../assets/img/icon/people.svg" alt>
<p>32 students enrolled</p>
</div>
</div>
</div>
</div>
</div>
</div>
<section class="page-content course-sec">
<div class="container">
<div class="row">
<div class="col-lg-8">
<div class="card overview-sec">
<div class="card-body">
<h5 class="subs-title">Overview</h5>
<h6>Course Description</h6>
<p><?php echo $lb['description'] ?></p>
<h6>What you will learn</h6>
<div class="row">
<div class="col-md-12">
<?php echo $lb['tolearn'] ?>
</div>
</div>
<h6>Requirements</h6>
<?php echo $lb['prereq'] ?>
</div>
</div>
<div class="card content-sec">
<div class="card-body">
<div class="row">
<div class="col-sm-6">
<h5 class="subs-title">Course Outline</h5>
</div>
<div class="col-sm-6 text-sm-end">
<h6></h6>
</div>
</div>
<div class="course-card">
<?php
$lesson=mysqli_query($con,"SELECT * FROM programcourses WHERE courseid='$courseid'");
while($les=mysqli_fetch_assoc($lesson)){
$pcid=$les["id"];
?>
<h6 class="cou-title">
<a class="collapsed" data-bs-toggle="collapse" href="#collapse<?php echo $les["id"] ?>" aria-expanded="false"><?php echo $les["programcoursetitle"] ?></a>
</h6>
<div id="collapse<?php echo $les["id"] ?>" class="card-collapse collapse" style>
<ul>
<?php
$unit=mysqli_query($con,"SELECT * FROM units WHERE moduleid='$pcid'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<p><?php echo $unt["unittitle"] ?></p>
</li>
<?php } ?>
</ul>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="col-lg-4">
<div class="sidebar-sec">
<div class="video-sec vid-bg">
<div class="card">
<div class="card-body">
<img class src="../course-images/<?php echo $lb['courseimage'] ?>" alt>
<div class="video-details">
<div style="display:none" class="course-fee">
<?php
if($lb['price']=="0"){ ?>
<h2>Free</h2>
<?php }else{
?>
<h2>Ksh. <?php echo number_format($lb["price"]) ?></h2>
<?php } ?>
</div>
<?php if($stdid!=""){
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM mycourses WHERE courseid='$courseid' AND studentid='$stdid'"))>0){ ?>
<a href="../dashboard/ongoing-course/<?php echo $url ?>" class="btn btn-enroll w-100">Continue Learning</a>
<?php }else{ ?>
<a style="display:none" href="../enroll.php?courseurl=<?php echo $url ?>&&courseid=<?php echo $courseid ?>&&stdid=<?php echo $stdid ?>" class="btn btn-enroll w-100">Enroll Now</a>
<a href="../dashboard/" class="btn btn-enroll w-100">Student Portal</a>
<?php }
}else{
?>
<a href="../dashboard/" class="btn btn-enroll w-100">Student Portal</a>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="card include-sec">
<div class="card-body">
<div class="cat-title">
<h4>Includes</h4>
</div>
<ul>
<li><img src="../assets/img/icon/play.svg" class="me-2" alt> downloadable resources</li>
<li><img src="../assets/img/icon/key.svg" class="me-2" alt> Full lifetime access</li>
<li><img src="../assets/img/icon/cloud.svg" class="me-2" alt> Assignments</li>
<li><img src="../assets/img/icon/teacher.svg" class="me-2" alt> Certificate of Completion</li>
</ul>
</div>
</div>
<div class="card feature-sec">
<div class="card-body">
<div class="cat-title">
<h4>Includes</h4>
</div>
<ul>
<li><img src="../assets/img/icon/users.svg" class="me-2" alt> Enrolled: <span>32 students</span></li>
<li><img src="../assets/img/icon/timer.svg" class="me-2" alt> Duration: <span><?php echo $lb["hours"] ?></span></li>
<li><img src="../assets/img/icon/chapter.svg" class="me-2" alt> Chapters: <span>15</span></li>
<li><img src="../assets/img/icon/chart.svg" class="me-2" alt> Level: <span><?php echo $lb["type"] ?></span></li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<?php include_once('includes/footer-course.php') ?>
</body>
</html>