php导出数组到csv格式demo

php的二维数组导出到csv需要处理文字编码,代码如下

<?php
$data=array(
    array("username"=>"test1","password"=>"123"),
    array("username"=>"test2","password"=>"456"),
    array("username"=>"test3","password"=>"789"),
);
export_csv($data);
function export_csv($data)
{
    $string="";
    foreach ($data as $key => $value) 
    {
        foreach ($value as $k => $val)
        {
            $value[$k]=iconv('utf-8','gb2312',$value[$k]);
        }

        $string .= implode(",",$value)."\n"; //用英文逗号分开 
    }
    $filename = date('Ymd').'.csv'; //设置文件名
    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 $string; 
}
?>

 

 

posted @ 2017-06-08 17:43  李照耀  阅读(7507)  评论(0编辑  收藏  举报