Google

Edit File: exportcsv.php

<?php
require 'Models/ConDB.php';
$db1 = new ConDB();

function download_send_headers($filename) {
    // disable caching
    $now = gmdate("D, d M Y H:i:s");
    header("Expires: Tue, 03 Jul 2001 06:00:00 GMT");
    header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
    header("Last-Modified: {$now} GMT");

// force download  
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");

// disposition / encoding on response body
    header("Content-Disposition: attachment;filename={$filename}");
    header("Content-Transfer-Encoding: binary");
}

if(isset($_GET['event_id'])){
	$event_id = $_GET['event_id'];
	$type = $_GET['type'];
	
	switch($type){
		case 'order':
			$data=exportOrderdata($event_id,$db1);
			if(count($data)>1){
				exportcsv($data,'order');
			}else{
				header('location:mainorders.php?status=norec');
				exit;
			}
			break;
		case 'feedback':	
			$data=exportfeedbackdata($event_id,$db1);
			if(count($data)>1){
				exportcsv($data,'feedback');
			}else{
				header('location:mainorders.php?status=norec');
				exit;
			}
			break;
			
		default:
			break;
	}
}

function exportfeedbackdata($event_id,$db1){
	  $accQry = "SELECT (SELECT event_name FROM event WHERE event_id=".$event_id.") AS eventname,order_id,ratings,comments,created_on FROM feedback where event_id='".$event_id."'";
	 $result1 = $db1->db->query($accQry);

$data[] = [
	'event_name'=>'Event Name',
	'order_id'  =>'Order Id',
	'ratings'=>'Rating',
	'comments'=>'Comment',
	'created_on'=>'Created Date'
	];
  while ($row = $result1->fetch_assoc()) {
	  $data[] =$row; 
  }
    return $data;

}

function exportOrderdata($event_id,$db1){
   $accQry = "select e.event_name, o.order_id,o.state, o.hall_number,o.table_no,o.amount,o.paid,o.payment_mode,o.created_dt 
  from orders o inner join event e on o.event_id = e.event_id AND o.`event_id` = ".$event_id." ORDER BY o.created_dt DESC ";
  
  $result1 = $db1->db->query($accQry);

$data[] = [
	'event_name'=>'Event Name',
	'order_id'  =>'Order Id',
	'state'=>'State',
	'hall_number'=>'Hall Number',
	'table_no'=>'Table No',
	'amount'=>'Amount',
	'paid'=>'Paid',
	'payment_mode'=>'Payment Mode',
	'created_dt'=>'Created Date'
	];
  while ($row = $result1->fetch_assoc()) {
	  $data[] =$row; 
  }
  return $data; 
}
function exportcsv($data,$file) {
	download_send_headers($file."_export_" . date("Y-m-d") . ".csv");
	echo array2csv($data);
		die();
    
}