File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/schools.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">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
<style>
.show-hide {
display: none;
}
@media only screen and (max-width: 480px) {
.show-hide {
display: inline-block;
}
.information {
display: none;
}
.information.toggle {
display: block;
}
}
</style>
<body>
<div class="main-wrapper">
<?php include_once("includes/header-course.php") ?>
<div 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:0%; background:#e19b36" class="inner-banner1">
<div class="container">
<div class="row">
<div class="col-lg-8">
<p> </p><p> </p>
<h2 style="color:#fff"><?php echo $lb['name'] ?></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="container1" style="margin-left:2%; margin-right:2%">
<div class="row">
<div class="col-lg-4">
<div class="sidebar-sec1">
<div class="video-sec vid-bg">
<div class="card">
<div class="card-body">
<div class="show-hide">
<a >
<span class="bar-icon">
<span></span>
<span></span>
<span></span>
</span>
</a>
</div>
<div class="information">
<div class="course-card">
<h6 class="cou-title">
<a style="font-size:18px" class="collapsed" data-bs-toggle="collapse" href="#collapsedept" aria-expanded="false">Departments in <?php echo $lb['name'] ?></a>
</h6>
<div id="collapsedept" class="card-collapse collapse" style>
<ul>
<?php
$unit=mysqli_query($con,"SELECT * FROM categories WHERE schoolid='$schoolid'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<p>
<a style="text-decoration:none; font-size:15px" href="../academic-programs/<?php echo $unt['url'] ?>"><?php echo $unt["name"] ?></a>
</p>
</li>
<?php } ?>
</ul>
</div>
</div>
<div class="course-card">
<h6 class="cou-title">
<a style="font-size:18px" class="collapsed" data-bs-toggle="collapse" href="#collapseup" aria-expanded="false">Undergraduate Programs</a>
</h6>
<div id="collapseup" class="card-collapse collapse" style>
<ul>
<?php
$unit=mysqli_query($con,"SELECT courses.* FROM courses,categories,schools WHERE schools.id='$schoolid' AND schools.id=categories.schoolid AND categories.id=courses.category AND courses.type='Degree'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<h4>
<a style="text-decoration:none" href="../course-details/<?php echo $unt['url'] ?>"><?php echo $unt["title"] ?></a>
</h4>
</li>
<?php } ?>
</ul>
</div>
</div>
<div class="course-card">
<h6 class="cou-title">
<a style="font-size:18px" class="collapsed" data-bs-toggle="collapse" href="#collapsepp" aria-expanded="false">Postgraduate Programs</a>
</h6>
<div id="collapsepp" class="card-collapse collapse" style>
<ul>
<?php
$unit=mysqli_query($con,"SELECT courses.* FROM courses,categories,schools WHERE schools.id='$schoolid' AND schools.id=categories.schoolid AND categories.id=courses.category AND courses.type='Masters'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<h4>
<a style="text-decoration:none" href="../course-details/<?php echo $unt['url'] ?>"><?php echo $unt["title"] ?></a>
</h4>
</li>
<?php } ?>
</ul>
</div>
</div>
<ul>
<?php
$unit=mysqli_query($con,"SELECT * FROM categories WHERE schoolid='$schoolid'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<li>
<p style="background: rgba(161, 196, 253, .12);border-radius: 5px;padding: 15px ">
<a style="text-decoration:none; font-size:17px" href="../academic-programs/<?php echo $unt['url'] ?>"><?php echo $unt["name"] ?></a>
</p>
</li>
<?php } ?>
</ul>
<div class="video-sec vid-bg">
<div class="card">
<div class="card-body">
<div style="width:50%; margin-left:20%; margin-right:20%">
<img style="height:auto; max-height:250px; width:100%; border-radius:10px" class src="../school-images/<?php echo $lb['deanimage'] ?>" alt="<?php echo $lb['deanname'] ?>">
</div>
<h3><?php echo $lb['deanname'] ?></h3>
<div class="video-details">
<p><?php echo $lb['deandescription'] ?></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-8">
<div style="padding:5px" class="card overview-sec">
<div class="card-body" >
<div class="navbar-show">
<div style="height:330px">
<img style="width:100%; height:auto; max-height:300px" class src="../school-images/<?php echo $lb['icon'] ?>" alt="<?php echo $lb['name'] ?>">
</div>
<h6></h6>
<p><?php echo $lb['description'] ?></p>
</div>
</div>
<div class="row">
<?php
$unit=mysqli_query($con,"SELECT * FROM categories WHERE schoolid='$schoolid'");
while($unt=mysqli_fetch_assoc($unit)){
$unitid=$unt["id"];
?>
<div class="col-md-4">
<div class="card overview-sec" style="border-radius: 15px;padding: 5px; box-shadow: 0px 0px 8px -4px rgba(0,0,0,0.75); height:300px">
<div class="card-body" >
<h3 style="color:#102044"><?php echo $unt["name"] ?></h3>
<p style="font-size:15px"><?php echo $unt["description"] ?></p>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</section>
<?php include_once('includes/footer-course.php') ?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
$('.show-hide').click(function() {
$(this).next().toggleClass('toggle');
});
});
</script>
</body>
</html>