导出CSV乱码
导出CSV,无论是什么格式,excel打卡都是乱码
需要加上
echo "\xEF\xBB\xBF";
header("Content-Disposition:attachment;filename=$fileName.csv"); header("Content-Type:$exportType;charset=UTF-8"); header("Expires: Mon, 31 Dec 2000 00:00:00 GMT" ); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT" ); header("Cache-Control: post-check=0, pre-check=0", false ); $header = implode("\", \"", $headers); $header = "\"" .$header; $header .= "\"\r\n"; echo "\xEF\xBB\xBF"; echo $header; foreach($entries as $row) { foreach ($row as $key => $value) { /* To support double quotations in CSV format * To review: http://creativyst.com/Doc/Articles/CSV/CSV01.htm#EmbedBRs */ $row[$key] = str_replace('"', '""', $value); } $line = implode("\",\"",$row); $line = "\"" .$line; $line .= "\"\r\n"; echo $line; }