关于php导出数据(不用phpexcel)

       

        $str = "序号,配件名称,供应商,入库时间,采购员,进价\n";
        foreach($orderModel as $key=>$value) {
            $keys = $key+1;
            $accessorie_name = $value['accessorie_name'];
            $supplier_name =$value['supplier_name'];
            $create_time =$value['create_time'];
            $buyer_name = $value['buyer_name'];
            $buy_price = $value['buy_price'];
    
            $str .= $keys.",".$accessorie_name.",".$supplier_name.",".date('Y-m-d H:i:s',$create_time).",".$buyer_name.",".$buy_price."\n"; //用引文逗号分开
        }
    
        $filename = 'RuKuChaXun'.date('Ymdhis').'.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');

        $str= iconv('UTF-8', 'GBK//IGNORE', $str);  //不加会出现乱码
        echo $str;

 



posted @ 2017-10-18 15:07  哈妮s  阅读(266)  评论(0)    收藏  举报