File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/schools3.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 schools WHERE url='$url'"));
$schoolid=$lb["id"];
}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['name'] ?>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">
</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">Schools</li>
<li class="breadcrumb-item" aria-current="page">All Schools</li>
<li class="breadcrumb-item" aria-current="page">The Complete Web Developer School 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"><?php echo $lb['name'] ?></span>
</div>
<h2><?php echo $lb['title'] ?></h2>
<p><?php echo substr($lb['shortdescription'],0,400) ?></p>
<div class="school-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 categories WHERE schoolid='$schoolid'")) ?> Departments</p>
</div>
</div>
</div>
</div>
</div>
</div>
<section class="page-content school-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></h6>
<p><?php echo $lb['description'] ?></p>
</div>
</div>
<div class="card content-sec">
<div class="card-body">
<div class="row">
<div class="col-sm-6">
<h5 class="subs-title">School Departments</h5>
</div>
<div class="col-sm-6 text-sm-end">
<h6></h6>
</div>
</div>
<div class="school-card">
<?php
$lesson=mysqli_query($con,"SELECT * FROM categories WHERE schoolid='$schoolid'");
while($les=mysqli_fetch_assoc($lesson)){
$deptid=$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["name"] ?></a>
</h6>
<div id="collapse<?php echo $les["id"] ?>" class="card-collapse collapse" style>
<ul>
<?php
$unit=mysqli_query($con,"SELECT * FROM courses WHERE category='$deptid'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<p><?php echo $unt["title"] ?></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="../school-images/<?php echo $lb['deanimage'] ?>" alt="<?php echo $lb['deanname'] ?>">
<h3><?php echo $lb['deanname'] ?></h3>
<div class="video-details">
<p><?php echo $lb['deandescription'] ?></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<?php include_once('includes/footer-course.php') ?>
</body>
</html>