[PHP] 使用php生成下载csv文件php csv
原理很简单,就是用php输出一个header头,可以直接让浏览器下载文件
单元格内容用英文逗号分隔, 其中为了防止乱码,汉字部分会进行一个转码操作,从utf8转为gbk
为了使单元格看起来直观一点,会增加个\t ,这样就不会看的时候出现#########
比如下面这个把moveusers数组作为csv文件下载
if(isset($_REQUEST['act'])&& $_REQUEST['act']=="downloadAll") { $outformat = "entmove.csv"; $title = "邮箱名,姓名,邮箱密码,搬家状态,开始时间,结束时间,邮件总数,收取数,失败数\n"; $data = ""; foreach ($moveUsers as $b) { $status = iconv("utf-8", "gbk//IGNORE", $b['status_text']); $realName = iconv("utf-8", "gbk//IGNORE", $b['realName']); $data .= "{$b['account']}\t,{$realName}\t,{$b['password']},{$status}\t,{$b['movetime']}\t" . ",{$b['endtime']}\t,{$b['totle']},{$b['successnum']},{$b['failnum']}\n"; } $title = iconv("utf-8", "gbk//IGNORE", $title); $data = $title . $data; header("Cache-control: private"); header("Pragma: public"); header('Content-type: application/x-csv'); if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE 5')) { header("Content-Disposition: inline; filename=$outformat"); } else { header("Content-Disposition: attachment; filename=$outformat"); } echo $data; exit; }