One Hat Cyber Team

Your IP : 216.73.216.84

Server IP : 50.6.229.107

Server : Linux server.hostburly.com 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64

Server Software : Apache

PHP Version : 8.2.30

Buat File | Buat Folder

Dir : ~/home/andjemzt/nportal.andjemztech.com/examAdmin/

Edit File: view_branch120813.php

<?
session_start();
include("inc/header.php");
include("inc/fxn.php");

$officer_id=$_SESSION['officer_id'];
?>
<link rel="stylesheet" href="pagination_css.css" type="text/css"  />
<form action="view_branch.php" method="post">
<fieldset>
<legend>Search</legend>
<table width="100%" cellpadding="10" cellspacing="5">
<tr><td>Name</td><td><input type="text" name="surname" size="20" /></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Search" /></td></tr>
</table></fieldset></form><br /><br />
<table border="1" cellpadding="5" cellspacing="0" width="100%">
<tr><td colspan="8" bgcolor="#CCCCCC"><strong><h4>REGISTERED APPLICANTS</h4></strong></td></tr>
<tr bgcolor="#999999">
<td><b>S/No</b></td><td><b>Surname</b></td><td><b>Othernames</b></td><td><b>Branch</b></td><td><b>Email</b></td><td><b>Phone</b></td><td>View Credentials</td><td>Approve Application</td></tr>
	<?
	$name=mysql_real_escape_string($_POST['surname']);
	if($name){
		$name2=" AND b.name LIKE '%$name%'";
	}
	else{
		$name2="";
	}
	$sql=mysql_query("SELECT * FROM branch WHERE officer_id='$officer_id'");
	$sno=0;
	while ($row=mysql_fetch_array($sql)){
		$branchid=$row['branchid'];
		$sql2=mysql_query("SELECT * FROM corp_mem a,corp_reg_pay b,clearance_status c WHERE a.stud_id=b.stud_id AND a.stud_id=c.stud_id AND  b.status='Paid' AND a.branch_id='$branchid' $name2");
		while ($row2=mysql_fetch_array($sql2)){
			$sno++;
			?>
            <tr><td><?=$sno?></td><td><?=$row2['surname']?></td><td><?=$row2['othernames']?></td><td><?=GetBranchName($branchid)?></td><td><?=$row2['email']?></td><td><?=$row2['phone']?></td><td><a href="view_credentials.php?stud_id=<?=$row2['stud_id']?>">View Credentials</a></td><td><a href="approve_app.php?stud_id=<?=$row2['stud_id']?>">Approve Application</a></td></tr>
            <? } } 			?>

</table>

<?
function GetBranchName($branchid){
	$sql=mysql_query("SELECT * FROM branch WHERE branchid='$branchid'");
	$row=mysql_fetch_array($sql);
	return $row['branch_name'];
}
function branchNo2($branch){
//$sql=mysql_query("SELECT * FROM branch b,admin_corp a,corp_mem c,corp_reg_pay d WHERE b.officer_id=a.id AND c.branch_id=b.branchid AND c.stud_id=d.stud_id AND d.status='Paid' AND b.branchid='$branch'");
$sql=mysql_query("SELECT * FROM corp_mem a,corp_reg_pay b WHERE a.stud_id=b.stud_id AND b.status='Paid' AND a.branch_id='$branch'");
$count=mysql_num_rows($sql);
return $count;
}

include("inc/footer.php"); ?>