File Manager

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

<?php
include("../data/db.php");
if (!isset($_SESSION))
{
  session_start();
}?>
<?php 
$admstatus = $_GET["admstatus"];
$level = $_GET["level"];
$session = $_GET["session"];
if($admstatus == 'No' AND $level =='all' AND $session == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant`");
    $cours->execute([]);
    $title = "Report of all Courses";
}else
if($admstatus == 'No' AND $level =='all' AND $session != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `year`=?");
    $cours->execute([$session]);
    $title = "Report for all Courses in Semester: ".$session;
}
else
if($admstatus == 'No' AND $level !='all' AND $session == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `level`=?");
    $cours->execute([$level]);
    $title = "Report for all Semester of ".$admstatus. "for ". $level;
}else
if($admstatus != 'No' AND $level =='all' AND $session == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `adm_status`=?");
    $cours->execute([$admstatus]);
    $title = "Report for all Semester of ".$admstatus. "for ". $level;
}
else
if($admstatus == 'No' AND $level !='all' AND $session != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `level`=?  AND  `year`=?");
    $cours->execute([$level,$session]);
    $title = "Report for all Level of ".$admstatus. "for Semester". $session;
}
if($admstatus != 'No' AND $level !='all' AND $session == 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `adm_status`=? AND `level`=?");
    $cours->execute([$admstatus,$level,$session]);
    $title = "Report for all Semester of ".$admstatus. " - Semester". $session;
}else
if($admstatus != 'No' AND $level =='all' AND $session != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `adm_status`=? AND `year`=?");
    $cours->execute([$admstatus,$session]);
    $title = "Report for all Level of ".$admstatus. "for Semester". $session;
}else
if($admstatus != 'No' AND $level !='all' AND $session != 'all'){
    $cours = $pdo->prepare("SELECT * FROM `applicant` WHERE `adm_status`=? AND `level`=?  AND `year`=?");
    $cours->execute([$admstatus,$level,$session]);
    $title = "ADMISSION REPORT<br>LEVEL: ".$level. "<br>SESSION: ". $session;
}
?>
<!DOCTYPE html>
<html>
<head>
	<title>STUDENTS 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>Programme </th>
			<th>AppNo</th>
			<th>Names</th>
			<th>Gender </th>
			<th>DOB </th>
			<th>Level</th>
			<th>Email</th>
			<th>PhoneNo </th>
			<th>Admitted </th>

</tr>
        <?php  $sn=0;
        while($courses = $cours->fetch()){ $sn++;?>
		<tr>
			<td><?php echo $sn;?></td>
			<td><?php echo $courses["programme"];?></td>
			<td><?php echo $courses["application_no"];?></td>
			<td><?php echo $courses["names"];?></td>
			<td><?php echo $courses["gender"];?></td>
			<td><?php echo $courses["dob"];?></td>
			<td><?php echo $courses["level"];?></td>
			<td><?php echo $courses["email"];?></td>
			<td><?php echo $courses["gsm"];?></td>
			<td><?php echo $courses["adm_status"];?></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