网站用PHP导出CSV格式文件怎么做?示例代码分享

作者:admin 发布时间:2020-06-15 18:53:45 浏览:702次
主要是利用php导出csv格式的文件,下面是小超越某个项目的代码片段,大家根据自己的数据来修改吧,懒得整理了! $dowdata = []; $csvstr = 'user_id,测试名单,总货源数,广东货源数,总完单数,广东完单数,最后发货时间' . "\n";//表头 foreach ($userinfo as $key => $val) { $user_id = $val['user_id']; $types = $val['type']; $goodsnum = 0; $gdgoodsnum = 0; $ordernum = 0; $gdordernum = 0; $lastgoodstime = ''; foreach ($goodsdata as $keys => $goods) { if ($user_id == $goods['user_id']) { $goodsnum = $goods['goodsnum']; $gdgoodsnum = $goods['gdgoodsnum']; $ordernum = $goods['ordernum']; $gdordernum = $goods['gdordernum']; $lastgoodstime = $goods['lastgoodstime']; } } $tempdata = ['user_id' => $user_id, 'type' => $type, 'goodsnum' => $goodsnum, 'gdgoodsnum' => $gdgoodsnum, 'ordernum' => $ordernum, 'gdordernum' => $gdordernum, 'lastgoodstime' => $lastgoodstime]; // array_push($dowdata,$tempdata); $csvstr .= implode(",", $tempdata) . "\n"; } $filename = '测试名单下载-' . $title . 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'); exit(mb_convert_encoding($csvstr, "GBK", "UTF-8"));

如需转载请保留本文出处: https://www.zhe94.com/732.html

上一篇:HTML5 Canvas全屏的星光闪烁3D视差特效代码
下一篇:layui上传文件PHP接收接口代码怎么写?