本篇文章的內容是PHP實現CSV寫入下載的代碼,現在分享給大家,有需要的朋友也可以參考一下這篇文章的內容
$title1 = '年月\明細,月貸款額,月利潤額,月理論回款額,月實際回款額,月未還款額,月客戶總量'."\n";
header("Cache-Control: public");
header("Pragma: public");
header("Content-type:application/vnd.ms-excel");
$filename = $title;
header("Content-Disposition:attachment;filename=$filename.csv");
header('Content-Type:APPLICATION/OCTET-STREAM');
ob_start();
//linux系統編碼轉換
//$header_str = mb_convert_encoding ($title1,"gbk","utf-8");
//$csv_line_data = mb_convert_encoding ($csv_line_data,"gbk","utf-8");
//windwos編碼轉換
//由於gb2312支援的字比較少,導致有些無法識別的字直接去掉了,換成支援更多字的gbk
//$data = iconv("utf-8","gb2312//IGNORE",$data);
$header_str = iconv("utf-8","gbk//IGNORE",$title1);
$csv_line_data = iconv("utf-8","gbk//IGNORE",$csv_line_data);
//$header_str = iconv("utf-8", 'gbk', $title);
//$csv_line_data = iconv("utf-8", 'gbk//IGNORE', $csv_line_data);
ob_end_clean();
//寫出
echo $header_str;
echo $csv_line_data;