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_brief.php

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

//include "inc/config.php";

//include("inc/fxn.php");
//include("search_form1.php");

?>

<p style="background-color:#CCC; width:180px; height:20px;"><strong>BRIEF</strong></p>
<table cellspacing="0" cellpadding="5" class="mytable" border="1" width="100%">
<tr>
<td colspan="9"><a href="print_brief1.php" target="_new">Print Brief </a></td><td><? include "excel_report.php";?></td></tr>
<th>S/No</th><th>File No</th><th>Branch</th><th>Names</th><th>Sex</th><th>Date of Birth</th><th>Qualification</th><th>Position and Place of Work</th><th>Category</th><th>Proposers</th>
<?

$sql=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 c.ad_comm='1' AND b.status='Paid'");
$sno=0;
if(!$sql){echo mysql_error();}
while ($row=mysql_fetch_array($sql)){
	$stud_id=$row['stud_id'];

//$sql2=mysql_query("SELECT *  FROM stud_reg_pay WHERE stud_id='$stud_id' AND status='Paid' AND amount >='2000'");
		//while ($row2=mysql_fetch_array($sql2)){
			$sno++;			
			$other_names_split=explode(" ",$row['othernames']);
			$other_names1=strtolower($other_names_split[0]);
			$other_names1=ucfirst($other_names1);
			$other_names2=strtolower($other_names_split[1]);
			$other_names2=ucfirst($other_names2);
			$other_names3=$other_names1." ".$other_names2;
			$name=$other_names3. " ".$row['surname'];
			//$name=ucfirst(strtolower($row['othernames'])). " ".$row['surname'];
			$email=$row2['email'];
			$grad_year=$row['grad_year'];
			$branch=GetAny("branch",$row['branch_id'],"branchid","branch_name");
			$category=GetAny("corp_cat",$row['category'],"id","name");
			if($row['sex']=='Male'){
				$sex="M";
			}
			else{
				$sex="F";
			}
			//$school_id=GetAny("stud_mem_reg",$stud_id,"stud_id","school");
			//$school_name=GetAny("universities",$school_id,"id","name");
			?>
            <tr>
            <td valign="top"><?=$sno?></td><td valign="top"><?=$row['file_no']."/".date("y")?></td><td valign="top"><?=$branch?></td><td valign="top"><?=$name?></td><td valign="top"><?=$sex?></td><td valign="top"><?=$row['dob']?></td><td valign="top"><?=$row['qual'].", $grad_year"?></td><td valign="top"><?=$row['work']?></td><td valign="top"><?=$category?></td><td valign="top"><?=$row['proposer1']. "<br>".$row['proposer2'] ?></td>
            </tr>
		<? }
		function GetAny ($table, $value, $where, $the_output) {

$query = "SELECT *
	FROM $table
	WHERE $where='$value'
	LIMIT 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num = mysql_num_rows($result);

// $programme_id = $row["programme_id"];
$the_output = $row["$the_output"];

$the_output = stripslashes($the_output);

return $the_output;
}
		
		
		
		?></table>

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