File Manager

✏️ Edit File: /home/coemyoza/public_html/portal/admin/report_payment_list.php

<?php
include("../data/db.php");
if (!isset($_SESSION))
{
  session_start();
}?>
<?php 
$programme = $_GET["programme"];
$level = $_GET["level"];
$semester = $_GET["semester"];
$type = $_GET["type"];
$session = $_GET["session"];
$status = $_GET["status"];
if($programme == 'all' AND $level =='all' AND $type =='all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `session`=? AND `semester`=? AND `status`=?");
    $cours->execute([$session, $semester, $status]);
    $title = "Report of all Payment";
}else
if($programme == 'all' AND $level =='all' AND $type != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `semester`=? AND `session`=? AND`type`=? AND `status`=?");
    $cours->execute([$semester,$session, $type,$status]);
    $title = "Report for all Courses in Semester: ".$semester;
}
else
if($programme == 'all' AND $level !='all' AND $type == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `level`=? AND `semester`=? AND `session`=?  AND `status`=?");
    $cours->execute([$level,$semester,$session,$status]);
    $title = "Report for all Semester of ".$programme. "for ". $level;
}else
if($programme != 'all' AND $level =='all' AND $type == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `programme`=? AND `semester`=? AND `session`=? AND `status`=?");
    $cours->execute([$programme,$semester,$session,$status]);
    $title = "Report for all Semester of ".$programme. "for ". $level;
}
else
if($programme == 'all' AND $level !='all' AND $type != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `level`=? AND `type`=? AND `semester`=? AND `session`=? AND `status`=?");
    $cours->execute([$level,$type,$semester,$session,$status]);
    $title = "Report for all Level of ".$programme. "for Semester". $semester;
}
if($programme != 'all' AND $level !='all' AND $type == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `programme`=? AND `level`=? AND `semester`=? AND `session`=? AND `status`=?");
    $cours->execute([$programme,$level,$semester,$session,$status]);
    $title = "Report for all Semester of ".$programme. " - Semester". $semester;
}else
if($programme != 'all' AND $level =='all' AND $type != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `programme`=? AND  `type`=? AND `semester`=? AND `session`=? AND `status`=?");
    $cours->execute([$programme,$type,$semester,$session,$status]);
    $title = "Report for all Level of ".$programme. "for Semester". $semester;
}else
if($programme != 'all' AND $level !='all' AND $type != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `stu_payloader` WHERE `programme`=? AND `level`=? AND `semester`=?,`session`=? AND `status`=?");
    $cours->execute([$programme,$level,$type,$semester,$session,$status]);
    $title = "COURSE REPORT<br>LEVEL: ".$level."<br>PROGRAMME: ".$programme. "<br>SEMESTER: ". $semester;
}
?>
<!DOCTYPE html>
<html>
<head>
	<title>PAYMENT 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>matno</th>
			<th>Names </th>
			<th>Pay Type </th>
			<th>Level </th>
			<th>Amount </th>
			<th>Semester </th>
			<th>Session </th>
			<th>Status </th>
			<th>TranxID </th>

</tr>
        <?php  $sn=0;
        while($courses = $cours->fetch()){ $sn++;?>
		<tr>
			<td><?php echo $sn;?></td>
			<td><?php echo $courses["matno"];?></td>
			<td><?php echo $courses["pay_type"];?></td>
			<td><?php echo $courses["type"];?></td>
			<td><?php echo $courses["level"];?></td>
			<td><?php echo $courses["amount"];?></td>
			<td><?php echo $courses["semester"];?></td>
			<td><?php echo $courses["session"];?></td>
			<td><?php echo $courses["status"];?></td>
			<td><?php echo $courses["txid"];?></td>
		</tr>
        <?php }?>
	</table>
</body>
</html>

Batal

⬅ Naik ke portal 72 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁assets	dir	—	2024-07-21 13:45	📂 Buka
📁demo_1	dir	—	2024-07-21 13:45	📂 Buka
🐘-add-staff.php	php	12.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-add_courses.php	php	12.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-allocat_page.php	php	12.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-allocate_c.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-courses.php	php	15.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-my_course.php	php	4.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄.DS_Store	ds_store	10 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄.htaccess	htaccess	361 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘accommodation.php	php	3.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add-staff.php	php	12.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add-user.php	php	9.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_courses.php	php	12.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_scores.php	php	7.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_student.php	php	702 B	2025-02-18 18:32	✏️ Edit 👁️ View
🐘admitted.php	php	12.2 KB	2026-01-06 09:48	✏️ Edit 👁️ View
🐘allocat_page.php	php	12.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘allocate_c.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_change_programme.php	php	22.1 KB	2026-01-06 10:07	✏️ Edit 👁️ View
🐘appl_download.php	php	5.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘applicant.php	php	15.1 KB	2025-01-22 06:26	✏️ Edit 👁️ View
🐘applicant_list_dwnld.php	php	701 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘changehostel.php	php	13.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘courses.php	php	15.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘entered_scores.php	php	6.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄error_log	file	5 MB	2026-04-21 10:58	✏️ Edit 👁️ View
🐘footer.php	php	2.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘give_offer.php	php	75 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘header.php	php	8.1 KB	2025-04-01 10:24	✏️ Edit 👁️ View
🐘header_copy.php	php	8.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘hostel.php	php	20.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️idacrd100.jpeg	jpeg	138.2 KB	2026-04-06 18:34	✏️ Edit 👁️ View
🖼️idcard.jpeg	jpeg	139.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard.php	php	10.4 KB	2026-04-06 18:43	✏️ Edit 👁️ View
🖼️idcard100back.jpeg	jpeg	100.7 KB	2026-04-06 18:34	✏️ Edit 👁️ View
🖼️idcard_back.jpeg	jpeg	114.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard_detail.php	php	3.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard_detail_100.php	php	4.3 KB	2026-04-06 18:55	✏️ Edit 👁️ View
🐘idcard_details_new.php	php	3.9 KB	2025-04-14 21:07	✏️ Edit 👁️ View
🐘idcard_old.php	php	4.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️idcards.jpeg	jpeg	123.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘index.php	php	4.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘my_course.php	php	4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘payment.php	php	12.9 KB	2025-01-22 06:42	✏️ Edit 👁️ View
🐘payment_schedule.php	php	15.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘profile.php	php	6.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️profile_image.jpg	jpg	93.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘programmes.php	php	15 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘registered_stnd_list.php	php	5.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report.php	php	23.1 KB	2025-11-10 16:54	✏️ Edit 👁️ View
🐘report_applicant_list.php	php	4.5 KB	2024-11-27 05:42	✏️ Edit 👁️ View
🐘report_course_list.php	php	3.8 KB	2025-11-10 17:00	✏️ Edit 👁️ View
🐘report_payment_list.php	php	4.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report_schedule_list.php	php	4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report_student_list.php	php	3.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘screening.php	php	7.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘setup.php	php	28.5 KB	2025-04-23 08:21	✏️ Edit 👁️ View
🐘sidebar_acadsec.php	php	2.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_admin.php	php	5.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_admin_copy.php	php	1.6 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_bursary.php	php	1.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_examoffice.php	php	1.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_main.php	php	6.8 KB	2024-07-21 13:49	✏️ Edit 👁️ View
🐘sidebar_staff.php	php	1.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_studentsaffair.php	php	4.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘staff.php	php	19.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘student.php	php	9.2 KB	2025-02-18 18:31	✏️ Edit 👁️ View
🐘student0.php	php	6.8 KB	2025-02-18 18:14	✏️ Edit 👁️ View
🐘student_data.php	php	17.1 KB	2024-10-09 06:23	✏️ Edit 👁️ View
🐘user.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘user_privilege.php	php	10.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View