File Manager

✏️ Edit File: /home/coemyoza/public_html/portal/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]);
    if ($admstatus == 'Yes'){ $theadmsval = "Admitted";}
    $title = "List of  ".$theadmsval. " Applicants <br> ". $session. "/".($session + 1)." Academic 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 = "APPLICATION REPORT<br>LEVEL: ".$level. "<br>SESSION: ". $session;
}
?>
<!DOCTYPE html>
<html>
<head>
	<title> <?php echo $title;?> </title>
	<style>
		table {
			border-collapse: collapse;
			width: 100%;
			margin-top: 20px;
			margin-bottom: 20px;
			font-family: Arial, sans-serif;
			font-size: 9pt;
			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;
		}
		
      .center 
      {
        display: block; /* Ensures it's treated as a block element */
        margin: 0 auto; /* Centers the element horizontally */
        text-align: center; /* If there’s text inside, it centers the text */
      }
</style>
	</style>
    
    <link rel="shortcut icon" href="../schoologo.png" />
</head>
<body>
    
<img src="../schoologo.png" style="width:120; height:120" alt="Schoologo" class="center">
	<h4 class="center"><?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>State </th>
			<th>LGA </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["state"];?></td>
			<td><?php echo $courses["lga"];?></td>
			<td><?php echo $courses["adm_status"];?></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