JezK

Edit File: goexport.php

<?php
//error_reporting(E_ALL);
include('PHPExcel.php');
include('PHPExcel/IOFactory.php');
include('admin_functions.php');
$date=date('d-M-Y');
$admin=new adm_functions();
if($_GET['st']=='States'){
$statesdata = $admin->get_states(); //Get States

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$row=1;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, 'id')
                              ->setCellValue('B'.$row, 'State');
$row++;   
                    
foreach ($statesdata as $key=>$val) {
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $val['stateid'])
								  ->setCellValue('B'.$row, $val['statename']);
 $row++;
}

// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Kaburu States');
$sk='States'.$date;
}
if($_GET['ds']=='Districts' && $_GET['st']!=''){

$state_id=trim($_GET['st']);
$statesdata = $admin->get_districts($state_id); //Get District Data

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);

$row=1;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, 'id')
                              ->setCellValue('B'.$row, 'districtname');
$row++;   
                       
foreach ($statesdata as $key=>$val) {
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $val['id'])
								  ->setCellValue('B'.$row, $val['districtname']);
 $row++;
}
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Kaburu Districts');
$sk='District'.$date;
}
if($_GET['mn']=='Mandals' && $_GET['ds']!=''){
	
$district_id=trim($_GET['ds']);
$statesdata = $admin->get_mandals($district_id); //Get Mandals Data
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$row=1;

$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, 'id')
                              ->setCellValue('B'.$row, 'mandalname');
  
$row++;                        
foreach ($statesdata as $key=>$val) {
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $val['id'])
								  ->setCellValue('B'.$row, $val['mandalname']);
 $row++;
}
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Kaburu Mandals');
$sk='Mandals'.$date;
}
if($_GET['cty']=='Cities' && $_GET['cy']!=''){
	
$mandal_id=trim($_GET['cy']);
$statesdata = $admin->get_city($mandal_id); //Get Cities

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);
$row=1;

$objPHPExcel->getActiveSheet()->setCellValue('A'.$row, 'id')
                              ->setCellValue('B'.$row, 'cityname');
  
 $row++;                        
foreach ($statesdata as $key=>$val) {
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $val['id'])
								  ->setCellValue('B'.$row, $val['cityname']);
 $row++;
}

// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Kaburu Cities');
$sk='Cities'.$date;
}
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename='.$sk.'.xls');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
?>