File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/openuni/lecturers/index.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["OpenUniL^###DHSG"])){
$email = $_SESSION["OpenUniL^###DHSG"];
$chkuser = mysqli_query($con,"SELECT * FROM lecturers WHERE email='$email'");
while($row = mysqli_fetch_assoc($chkuser)){
$lecturerid = $row["id"];
$name = $row["fullname"];
$icon = $row["profilepic"];
}
}
else{
header("Location:../staff-login.php");
}
?>
<!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>Lecturer 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="https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/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>
#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="#"><img src="../lecturer-images/<?php echo $icon ?>" alt class="img-fluid"></a>
<div class="d-flex align-items-center">
<div class="course-name">
<h4><a href="lecturer-profile.php"><?php echo $name ?></a></h4>
</div>
</div>
</div>
<!--<div class="course-share ">-->
<!--<a href="javascript:void(0);" class="btn btn-primary">Account Settings</a>-->
<!--</div>-->
</div>
</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="my-students.php">My Students</a>
<a class="nav-link" href="logout.php">Logout</a>
</div>
</div>
</div>
</nav>
</div>
</div>
<div id="pgc" class="page-content1">
<div class="container1" style="margin-left:2%; margin-right:2%">
<div class="row">
<div class="col-xl-12 col-md-12">
<div class="settings-top-widget student-deposit-blk">
<div class="row">
<div class="col-lg-4 col-md-6 col-6 col-sm-6">
<div class="card stat-info ttl-tickets">
<div class="card-body">
<div class="view-all-grp d-flex">
<div class="student-ticket-view">
<h3>
<?php
$leccourses=mysqli_fetch_assoc(mysqli_query($con,"SELECT assignedcourses FROM lecturers WHERE id='$lecturerid'"))["assignedcourses"];
if($leccourses!=""){
$array = explode(',', $leccourses);
echo COUNT($array);
}else{
echo "0";
}
?>
</h3>
<p>Assigned Courses</p>
<!--<a href="completed-courses.php">View All</a>-->
</div>
<div class="img-deposit-ticket">
<img src="assets/img/students/book.svg" alt>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4 col-md-6 col-6 col-sm-6">
<div class="card stat-info open-tickets">
<div class="card-body">
<div class="view-all-grp d-flex">
<div class="student-ticket-view">
<h3><?php
$leccourses=mysqli_fetch_assoc(mysqli_query($con,"SELECT assignedcourses FROM lecturers WHERE id='$lecturerid'"))["assignedcourses"];
if($leccourses!=""){
$array = explode(',', $leccourses);
$percourse=0;
foreach($array AS $courseid){
$courseid=$courseid;
$percourse+=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) AS noofstd FROM mycourses WHERE courseid='$courseid'"))["noofstd"];
}
echo $percourse;
}else{
echo "0";
}
?></h3>
<p>My Students</p>
<!--<a href="ongoing-courses.php">View All</a>-->
</div>
<div class="img-deposit-ticket">
<img src="assets/img/students/receipt-text.svg" alt>
</div>
</div>
</div>
</div>
</div>
<div style="display:none" class="col-lg-4 col-md-6">
<div class="card stat-info close-tickets">
<div class="card-body">
<div class="view-all-grp d-flex">
<div class="student-ticket-view">
<h3>2</h3>
<p>Messages</p>
<a href="messages.php">View All</a>
</div>
<div class="img-deposit-ticket">
<img src="assets/img/students/empty-wallet-tick.svg" alt>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<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>Assigned Courses</h3>
</div>
<div class="settings-tickets-blk table-responsive">
<table id="dataTable" class="table table-nowrap mb-0 table-striped">
<thead>
<tr>
<th>Course Image</th>
<th>Course Name</th>
<th>Period</th>
<th>No of Students</th>
<th></th>
<th style="display:none"></th>
</tr>
</thead>
<tbody>
<?php
$leccourses=mysqli_fetch_assoc(mysqli_query($con,"SELECT assignedcourses FROM lecturers WHERE id='$lecturerid'"))["assignedcourses"];
// if($leccourses!=""){
// $array = explode(',', $leccourses);
// foreach($array AS $courseid){
// $courseid=$courseid;
// echo "<p>";
// echo $coursetitle=mysqli_fetch_assoc(mysqli_query($con,"SELECT title FROM courses WHERE id='$courseid'"))["title"];
// echo "</p>";
// }
// }
// else{
// }
$leccourses=mysqli_fetch_assoc(mysqli_query($con,"SELECT assignedcourses FROM lecturers WHERE id='$lecturerid'"))["assignedcourses"];
if($leccourses!=""){
$array = explode(',', $leccourses);
foreach($array AS $courseid){
$courseid=$courseid;
$coursedet=mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM courses WHERE id='$courseid'"));
$percourse=mysqli_fetch_assoc(mysqli_query($con,"SELECT COUNT(*) AS noofstd FROM mycourses WHERE courseid='$courseid'"))["noofstd"]
?>
<tr>
<td style="width:100px; height:auto">
<img style="width:70%; height:auto" src="../course-images/<?php echo $coursedet["courseimage"];?>" class="img-fluid " alt='<?php echo $coursedet["title"];?>'>
</td>
<td><a target="_blank" href="../course-details/<?php echo $coursedet["url"];?>"><?php echo $coursedet["title"];?></a></td>
<td><?php echo $coursedet["hours"];?></td>
<td><?php echo $percourse ?></td>
<td>
<a href="course-students/<?php echo $coursedet["url"] ?>" class="btn btn-sm btn-enroll w-100">View Students</a>
</td>
<th style="display:none">
<a href="ongoing-course/<?php echo $coursedet["url"] ?>" class="btn btn-sm btn-enroll w-100">Continue Learning</a>
</th>
</tr>
<?php } ?>
</tbody>
</table>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include_once("../includes/footer-course.php") ?>
<script>
$('#dataTable').DataTable({"aaSorting" : []});
</script>
</div>
</body>
</html>