File Manager

✏️ Edit File: /home/coemyoza/portal.coeminna.edu.ng/admin/report_schedule_list.php

<?php
include("../data/db.php");
if (!isset($_SESSION))
{
  session_start();
}?>
<?php 
$category = $_GET["category"];
$level = $_GET["level"];
$semester = $_GET["semester"];
$session = $_GET["session"];
if($category == 'all' AND $level =='all' AND $semester == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `session`=?");
    $cours->execute([$session]);
    $title = "Report of all Courses";
}else
if($category == 'all' AND $level =='all' AND $semester != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `semester`=? AND  `session`=?");
    $cours->execute([$semester,$session]);
    $title = "Report for all Courses in Semester: ".$semester;
}
else
if($category == 'all' AND $level !='all' AND $semester == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE  `level`=? AND `session`=?");
    $cours->execute([$level,$session]);
    $title = "Report for all Semester of ".$category. "for ". $level;
}else
if($category != 'all' AND $level =='all' AND $semester == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `category`=? AND  `session`=?");
    $cours->execute([$category,$session]);
    $title = "Report for all Semester of ".$category. "for ". $level;
}
else
if($category == 'all' AND $level !='all' AND $semester != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `level`=? AND `semester`=? AND  `session`=?");
    $cours->execute([$level,$semester,$session]);
    $title = "Report for all Level of ".$category. "for Semester". $semester;
}
if($category != 'all' AND $level !='all' AND $semester == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `category`=? AND `level`=? AND `session`=?");
    $cours->execute([$category,$level,$session]);
    $title = "Report for all Semester of ".$category. " - Semester". $semester;
}else
if($category != 'all' AND $level =='all' AND $semester != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `category`=? AND  `semester`=? AND `session`=?");
    $cours->execute([$category,$semester,$session]);
    $title = "Report for all Level of ".$category. "for Semester". $semester;
}else
if($category != 'all' AND $level !='all' AND $semester != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `payment_schedule` WHERE `category`=? AND `level`=? AND `semester`=? AND `session`=?");
    $cours->execute([$category,$level,$semester,$session]);
    $title = "COURSE REPORT<br>LEVEL: ".$level."<br>category: ".$category. "<br>SEMESTER: ". $semester;
}
?>
<!DOCTYPE html>
<html>
<head>
	<title>PAYMENT SCHEDULE REPORT</title>
	<style>
		table {
			border-collapse: collapse;
			width: 100%;
			margin-top: 20px;
			margin-bottom: 20px;
			font-family: Arial, sans-serif;
			font-size: 14px;
			color: #333;
			border: 1px solid #ccc;
		}

table th, table td {
			padding: 8px;
			text-align: justify;
			border: 1px solid #ccc;
		}

table th {
			background-color: #f2f2f2;
			color: #333;
			font-weight: bold;
		}

table tr:nth-child(even) {
			background-color: #f2f2f2;
		}

table tr:hover {
			background-color: #ddd;
		}
	</style>
</head>
<body>
    
	<h4><?php echo strtoupper($title);?></h4>
	<table>
		<tr>
			<th>#</th>
			<th>Category</th>
			<th>Level </th>
			<th>Amount (ind)</th>
			<th>Amount (non)</th>
			<th>Session </th>
			<th>Semester </th>

</tr>
        <?php  $sn=0;
        while($courses = $cours->fetch()){ $sn++;?>
		<tr>
			<td><?php echo $sn;?></td>
			<td><?php echo $courses["category"];?></td>
			<td><?php echo $courses["level"];?></td>
			<td><?php echo $courses["amount_indigene"];?></td>
			<td><?php echo $courses["amount_nonindigene"];?></td>
			<td><?php echo $courses["session"];?></td>
			<td><?php echo $courses["semester"];?></td>
		</tr>
        <?php }?>
	</table>
</body>
</html>

Batal

⬅ Naik ke portal.coeminna.edu.ng 66 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁assets	dir	—	2024-01-26 05:45	📂 Buka
📁demo_1	dir	—	2024-01-26 05:45	📂 Buka
🐘-add-staff.php	php	12.5 KB	2024-01-29 17:14	✏️ Edit 👁️ View
🐘-add_courses.php	php	12.3 KB	2024-02-07 20:50	✏️ Edit 👁️ View
🐘-allocat_page.php	php	12.2 KB	2024-01-29 19:22	✏️ Edit 👁️ View
🐘-allocate_c.php	php	3.5 KB	2024-01-29 18:13	✏️ Edit 👁️ View
🐘-courses.php	php	15.3 KB	2024-02-15 13:56	✏️ Edit 👁️ View
🐘-my_course.php	php	4.1 KB	2024-02-14 13:20	✏️ Edit 👁️ View
📄.DS_Store	ds_store	10 KB	2024-01-28 21:27	✏️ Edit 👁️ View
📄.htaccess	htaccess	361 B	2024-01-26 05:45	✏️ Edit 👁️ View
🐘accommodation.php	php	3.7 KB	2024-02-08 16:34	✏️ Edit 👁️ View
🐘add-staff.php	php	12.7 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘add-user.php	php	9.7 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘add_courses.php	php	12.2 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘add_scores.php	php	7.8 KB	2024-02-21 19:20	✏️ Edit 👁️ View
🐘admitted.php	php	12 KB	2024-04-05 04:23	✏️ Edit 👁️ View
🐘allocat_page.php	php	12.1 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘allocate_c.php	php	3.5 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘appl_download.php	php	5.3 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘applicant.php	php	14.3 KB	2024-04-05 04:23	✏️ Edit 👁️ View
🐘applicant_list_dwnld.php	php	701 B	2024-01-26 05:45	✏️ Edit 👁️ View
🐘changehostel.php	php	13.3 KB	2024-02-08 16:31	✏️ Edit 👁️ View
🐘courses.php	php	15.3 KB	2024-02-21 13:47	✏️ Edit 👁️ View
🐘entered_scores.php	php	6.1 KB	2024-02-21 14:07	✏️ Edit 👁️ View
📄error_log	file	165.6 KB	2025-12-29 15:16	✏️ Edit 👁️ View
🐘footer.php	php	2.9 KB	2024-01-28 06:33	✏️ Edit 👁️ View
🐘give_offer.php	php	75 B	2024-01-26 05:45	✏️ Edit 👁️ View
🐘header.php	php	8.1 KB	2024-03-08 10:38	✏️ Edit 👁️ View
🐘header_copy.php	php	8.4 KB	2024-01-31 04:38	✏️ Edit 👁️ View
🐘hostel.php	php	20.4 KB	2024-02-21 20:02	✏️ Edit 👁️ View
🖼️idcard.jpeg	jpeg	139.3 KB	2024-06-14 16:07	✏️ Edit 👁️ View
🐘idcard.php	php	10 KB	2024-04-25 13:29	✏️ Edit 👁️ View
🖼️idcard_back.jpeg	jpeg	114.9 KB	2024-04-25 13:09	✏️ Edit 👁️ View
🐘idcard_detail.php	php	3.7 KB	2024-06-22 07:01	✏️ Edit 👁️ View
🐘idcard_old.php	php	4.7 KB	2024-06-22 06:55	✏️ Edit 👁️ View
🖼️idcards.jpeg	jpeg	123.1 KB	2024-06-14 16:07	✏️ Edit 👁️ View
🐘index.php	php	4.8 KB	2024-02-14 13:24	✏️ Edit 👁️ View
🐘my_course.php	php	4 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘payment.php	php	11.8 KB	2024-02-16 16:59	✏️ Edit 👁️ View
🐘payment_schedule.php	php	15.2 KB	2024-02-22 21:17	✏️ Edit 👁️ View
🐘profile.php	php	6.1 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🖼️profile_image.jpg	jpg	93.8 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘programmes.php	php	15 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘registered_stnd_list.php	php	5.7 KB	2024-02-21 14:05	✏️ Edit 👁️ View
🐘report.php	php	23 KB	2024-01-27 20:21	✏️ Edit 👁️ View
🐘report_applicant_list.php	php	3.8 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘report_course_list.php	php	3.7 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘report_payment_list.php	php	4.5 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘report_schedule_list.php	php	4 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘report_student_list.php	php	3.8 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🖼️schoologo.png	png	9.2 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘screening.php	php	7.4 KB	2024-02-14 15:48	✏️ Edit 👁️ View
🐘setup.php	php	27.9 KB	2024-02-01 05:35	✏️ Edit 👁️ View
🐘sidebar_acadsec.php	php	2.1 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘sidebar_admin.php	php	5.2 KB	2024-01-29 13:12	✏️ Edit 👁️ View
🐘sidebar_admin_copy.php	php	1.6 KB	2024-01-29 13:43	✏️ Edit 👁️ View
🐘sidebar_bursary.php	php	1.4 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘sidebar_examoffice.php	php	1.9 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘sidebar_main.php	php	6.8 KB	2024-03-08 10:48	✏️ Edit 👁️ View
🐘sidebar_staff.php	php	1.4 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘sidebar_studentsaffair.php	php	4.3 KB	2024-01-26 05:45	✏️ Edit 👁️ View
🐘staff.php	php	19.7 KB	2024-02-21 13:39	✏️ Edit 👁️ View
🐘student.php	php	6.8 KB	2024-06-18 16:11	✏️ Edit 👁️ View
🐘student_data.php	php	14.9 KB	2024-06-18 13:01	✏️ Edit 👁️ View
🐘user.php	php	3.5 KB	2024-02-11 17:45	✏️ Edit 👁️ View
🐘user_privilege.php	php	10.1 KB	2024-03-16 16:14	✏️ Edit 👁️ View