Downloading data in excel format with PHP And Unicode
Nov 7, 2022
public function _exportToCSV($status){
$columnHeader = "";
$setData = '';
$findAll = ImportUsers::model()->findAll("status = $status");
if(!empty($findAll)){
foreach($findAll as $objData){
$rowData = '';
$value = '"' . $objData->title1 . '"' . "\t";
$value .= '"' . $objData->title2 . '"' . "\t";
$value .= '"' . $objData->title3 . '"' . "\t";
$rowData .= $value;
$setData .= trim($rowData) . "\n";
}
}
$fileName = 'output.csv';
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename = $fileName");
header('Content-Transfer-Encoding: binary');
header("Pragma: no-cache");
header("Expires: 0");
echo chr(255).chr(254).iconv("UTF-8", "UTF-16LE//IGNORE", $setData . "\n");
exit();
}
Enjoy.