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

<?php

include("excelwriter.inc.php");
	include "config_nsemem.php";
	
	$excel=new ExcelWriter("myReport.xls");
	
	if($excel==false)	
		echo $excel->error;
		
	$myArr=array("S/No","File No","Branch","Names","Sex","Date of Birth","Qualification", "Position and Place of Work","Category","Proposers");
	$excel->writeLine($myArr);
	
	
	// now fetch data from database table, there is a new line create each time loop runs
	//$qry=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'");
	$qry=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'");

if($qry!=false)
	{
	 $i=1;
	 while($res=mysql_fetch_array($qry))
	 {
		 	$category=GetAny("corp_cat",$row['category'],"id","name");
	 $myArr=array($i,$res['file_no'],GetAny("branch",$res['branch_id'],"branchid","branch_name"),$res['surname']." ".$res['othernames'],$res['sex'],$res['dob'],$res['qual'],$res['work'],$category,$res['proposer1']."/".$res['proposer2']);
	 $excel->writeLine($myArr);
	 $i++;
	 }
	}
	else{
		echo mysql_error();
	}

/*$myArr=array("Sriram","Pandit","23 mayur vihar",24);
	$excel->writeLine($myArr);
	
	$excel->writeRow();
	$excel->writeCol("Manoj");
	$excel->writeCol("Tiwari");
	$excel->writeCol("80 Preet Vihar");
	$excel->writeCol(24);
	
	$excel->writeRow();
	$excel->writeCol("Harish");
	$excel->writeCol("Chauhan");
	$excel->writeCol("115 Shyam Park Main");
	$excel->writeCol(22);

$myArr=array("Tapan","Chauhan","1st Floor Vasundhra",25);
	$excel->writeLine($myArr);*/
	
	$excel->close();
	/*function GetAny($table,$value,$field,$output){
		$sql=mysql_query("SELECT * FROM $table WHERE $field='$value'");
		$row=mysql_fetch_array($sql);
		return $row["$output"];
	}*/
	function getCat($id){
		switch ($id){
			case "1":
			echo "A1";
			break;
			
			case "2":
			echo "A2";
			break;
			
			case "3":
			echo "B1";
			break;
			
			case "4":
			echo "B2";
			break;
			
			case "5":
			echo "C1";
			break;
			
			case "6":
			echo "C2";
			break;
	}
	}
	//echo "Report Successfully Generated.<br>";
	?>
	<a href="myReport.xls" target="_blank">Download in Microsoft Format</a>