php export to excel
<?php
$strExcelFileName="Member-All.xls";
header("Content-Type: application/x-msexcel; name=\"$strExcelFileName\"");
header("Content-Disposition: attachment; filename=\"$strExcelFileName\"");
header("Pragma:no-cache");
$i = 1;
foreach ($data as $row) {
if ($i == 1) {
// COLUMN HEADERS
echo implode("\t", array_keys($row)) . "\r\n";
}
// DATA ROWS
echo implode("\t", array_values($row)) . "\r\n";
$i++;
}