php 导出csv文件

$str = "用户ID,用户昵称,可提收入,已提收入,总收入,越狱,邀请用户数量,试玩应用数量\n";
                $str = iconv('utf-8', 'gb2312', $str);
                /** 列表项 */
                foreach ($res as $key => $row) {
                    $row['id'] = iconv('utf-8', 'gb2312', $row['id']); //中文转码
                    $row['nick'] = iconv('utf-8', 'gb2312', $row['nick']);
                    $v = $row['income'] - $row['spend'];
                    $v = iconv('utf-8', 'gb2312', $v);
                    $row['spend'] = iconv('utf-8', 'gb2312', $row['spend']);
                    $row['income'] = iconv('utf-8', 'gb2312', $row['income']);
                    $row['escape'] = iconv('utf-8', 'gb2312', $row['escape']);
                    $row['invited_user_num'] = iconv('utf-8', 'gb2312', $row['invited_user_num']);
                    $row['download_num'] = iconv('utf-8', 'gb2312', $row['download_num']);
                    $str .= $row['id'] . "," . $row['nick'] . "," . $v . "," . $row['spend'] . "," . $row['income'] . "," . $row['escape'] . "," . $row['invited_user_num'] . "," . $row['download_num'] . "\n"; //用引文逗号分开


                }
                $filename = date('Ymd') . '.csv'; //设置文件名
                $this->mUser->export_csv($filename, $str);

                exit; //导出



public function export_csv($filename, $data)
    {
        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;
    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值