<?php
$arr = array();
$main="select Distinct location from ige_international where city = 'UAE' and mental_grade != ''";
$resultmain = mysqli_query($MySQLi_CON, $main) or die(mysqli_error($MySQLi_CON));
$arr = mysqli_fetch_row($resultmain);
$length = count($arr);
for ($i = 0; $i < $length; $i++) {
$sql="SELECT location, CONCAT('IGEMA-0',MONTH(exam_date),YEAR(exam_date),'-',id) AS stud_id, UPPER(std_name)as std_name, mental_grade , UPPER(result) as result , DATE_FORMAT(exam_date, '%d/%m/%Y') as date from ige_international where city = 'UAE' and result not in ( 'Fail' ) and mental_grade != '' and location = '$arr[$i]' ";
$result = mysqli_query($MySQLi_CON, $sql) or die(mysqli_error($MySQLi_CON));
if (mysqli_num_rows($result) > 0) {
$objPHPExcel = new PHPExcel();
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Final Result.xlsx"');
header('Cache-Control: max-age=0');
$s=0;
if ($s < $length) {
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex($s);
$objPHPExcel->getActiveSheet()->setTitle($arr[$i]);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', "NO");
$objPHPExcel->getActiveSheet()->SetCellValue('B1', "CENTRE");
$objPHPExcel->getActiveSheet()->SetCellValue('C1', "EXAMINATION CODE");
$objPHPExcel->getActiveSheet()->SetCellValue('D1', "STUDENT NAME");
$objPHPExcel->getActiveSheet()->SetCellValue('E1', "MENTAL GRADE");
$objPHPExcel->getActiveSheet()->SetCellValue('E1', "RESULT");
$objPHPExcel->getActiveSheet()->SetCellValue('E1', "DATE");
$rowCount = 2;
$n = 1;
while($row = mysqli_fetch_assoc($result)) {
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $n);
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $row['location']);
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $row['stud_id']);
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $row['std_name']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $row['mental_grade']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $row['result']);
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $row['date']);
$rowCount++;
$n++;
}
$s++;
}
}
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);