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: fullMembers.php

<? include("inc/header.php"); ?>
<style>
table{font-size:12px}
tr:nth-child(even) {background: #CCC;}
tr:nth-child(odd) {background: #FFF;}
</style>

<?php
include("inc/config.php");
$appType=$_GET['appType'];
$query=returnQuery($appType);
$sql=mysql_query($query);

if(!$sql){ 
echo mysql_error();
}
$num=mysql_num_rows($sql);

?>
<pre><span><strong><h4><?php echo returnTitle($appType); ?></h4></strong></span></pre>
<?php if(!$num){echo "No Completed Application";}else{ ?>
<table border="1" cellspacing="0" cellpadding="5" width="100%">
<tr><th>S/No</th><th>Assigned Membership No</th><th>Name</th><th>Email</th><th>Phone</th></tr>
<?php
$sno=0;
while ($row=mysql_fetch_array($sql)){ 
$sno++; 
//echo returnRows($appType,$row,$sno);
if($appType==1){
?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['memRegNo']; ?></td><td><?php echo $row['fellSurname']." ".$row['fellOthernames']; ?></td><td><?php echo $row['fellEmail']; ?></td><td><?php echo $row['fellPhone']; ?></td></tr>
<?php } elseif($appType==2){ ?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['memRegNo']; ?></td><td><?php echo $row['memSurname']." ".$row['memOthernames']; ?></td><td><?php echo $row['memEmail']; ?></td><td><?php echo $row['memPhone']; ?></td></tr>
<?php
} elseif($appType==3){?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['memRegNo']; ?></td><td><?php echo $row['probSurname']." ".$row['probOthernames']; ?></td><td><?php echo $row['probEmail']; ?></td><td><?php echo $row['probPhone']; ?></td></tr>
<?php } elseif($appType==4){ ?>
<tr><td><?php echo $sno; ?></td><td><?php echo $row['memRegNo']; ?></td><td><?php echo $row['techSurname']." ".$row['techOthernames']; ?></td><td><?php echo $row['techEmail']; ?></td><td><?php echo $row['techPhone']; ?></td></tr>	
<?php } elseif($appType==5){ ?>
	<tr><td><?php echo $sno; ?></td><td><?php echo $row['memRegNo']; ?></td><td><?php echo $row['studSurname']." ".$row['studOthernames']; ?></td><td><?php echo $row['studEmail']; ?></td><td><?php echo $row['studPhone']; ?></td></tr>
	
<?php }}
?>
</table>
<?php
}
function returnQuery($appType){
	switch($appType){
		case "1":
		$query="SELECT * FROM fellreg a,transaction b,clearance c WHERE a.fellAuthNum=b.transRef AND a.fellID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='1' AND c.clearApproval2='1' AND c.clearAssignNo='1'";
		break;
		
		case "2":
		$query="SELECT * FROM memreg a,transaction b,clearance c WHERE a.memAuthNum=b.transRef AND a.memID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='1' AND c.clearApproval2='1' AND c.clearAssignNo='1'";
		break;
		
		case "3":
		$query="SELECT * FROM probreg a,transaction b,clearance c WHERE a.probAuthNum=b.transRef AND a.probID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='1' AND c.clearApproval2='1' AND c.clearAssignNo='1'";
		break;
		
		case "4":
		$query="SELECT * FROM techreg a,transaction b,clearance c WHERE a.techAuthNum=b.transRef AND a.techID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='1' AND c.clearApproval2='1' AND c.clearAssignNo='1'";
		break;
		
		case "5":
		$query="SELECT * FROM studentreg a,transaction b,clearance c WHERE a.studAuthNum=b.transRef AND a.studID=c.studID AND c.appTypeID='$appType' AND b.transStatus='PAID' AND c.clearApproval1='1' AND c.clearApproval2='1' AND c.clearAssignNo='1'";
		break;
	}
	return $query;
}
function returnTitle($appType){
	switch($appType){
		case "1":
		$title='COMPLETED FELLOW APPLICATION';
		break;
		
		case "2":
		$title='COMPLETED MEMBER APPLICATION';
		break;
		
		case "3":
		$title='COMPLETED PROBATIONER APPLICATION';
		break;
		
		case "4":
		$title='COMPLETED TECHNICIAN APPLICATION';
		break;
		
		case "5":
		$title='COMPLETED STUDENT APPLICATION';
		break;
	}
	return $title;
}
?>