Export to excel

export-to-excel

<?php

$actual_headers = array();
foreach ($data['fields'] as $field)
{
 	$actual_headers [] = $data['actual_headers'][$field];
}

$path = realpath(BASEPATH."../assets/fmt/xls/");
$fname = $title."-".time().".csv";

$fp = fopen("{$path}/{$fname}", 'w');
	fputcsv($fp, $actual_headers);

foreach ($data['result']->result()  as $result)
{
	$row = array();
	foreach ($data['fields'] as $field)
	{
		$row []  = $result->{$field};
	}
	fputcsv($fp, $row);
}

fclose($fp);

header('Content-type: application/csv');
header("Content-Disposition: inline; filename=".$fname);
readfile("{$path}/{$fname}");
exit();