$fp = fopen($outputFileName, 'w');
fwrite($fp, chr(0xEF).chr(0xBB).chr(0xBF)); //导出的CSV文件是无BOM编码UTF-8,而我们通常使用UTF-8编码格式都是有BOM的。所以添加BOM于CSV中
$tmparr = array("发放者工号","发放者姓名","接收者工号","接收者姓名","额度","规则代号","规则名称","发放原因","发放备注",'发放时间');
fputcsv($fp, $tmparr);
foreach($data as $item){
$tmparr[0] = $item['fromid'];
$tmparr[1] = $item['fromname'];
$tmparr[2] = $item['toid'];
$tmparr[3] = $item['toname'];
$tmparr[4] = $item['edu'];
$tmparr[5] = $item['reg_shortname'];
$tmparr[6] = $item['reg_name'];
$tmparr[7] = $item['reason'];
$tmparr[8] = $item['remark'];
$tmparr[9] = $item['time'];
fputcsv($fp, $tmparr);
}
php 导出csv中文乱码
最新推荐文章于 2023-05-23 15:55:26 发布