这是一个简单的php导出csv的示例，有用到iconv模块，通过转码到gb2312实现excel打开csv无乱码出现
<?php
function escapeCSV($str){
$str = str_replace(array(',','"',"\n\r"),array('','""',''),$str);
if($str == ""){
$str = '""';
}
return $str;
}
function iconvstr($str){
return iconv('utf-8','gb2312',escapeCSV($str));
}
$dataforcsv = array(
array(1,'psdshow','psdshow@gmail.com','2008-9-10'),
array(2,'我的姓名','test@gmail.com','2008-9-11')
);
$filename = date('YmdHis').'.csv';
$data = "\"ID\",Username,Email,Day"."\n";
foreach($dataforcsv as $r) {
$data .= $r[0].','.iconvstr($r[1]).','.iconvstr($r[2]).','.$r[3]."\n";
}
header("Content-type: text/csv");
header ("Content-Disposition: attachment; filename=" . $filename);
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Expires: 0');
header('Pragma: public');
echo $data;
?>
下载php导出csv无乱码实例
http://www.dayanmei.com/download.php?filename=export_csv.rar
(141)
