php---utf-8文件下生成csv文件

来源:互联网 发布:如何创建淘宝优站 编辑:程序博客网 时间:2024/05/17 23:03

写入csv

//写入csv        $url_csv = WSING_ROOT . '/countall.csv';        if (file_exists($url_csv)) {            unlink($url_csv);        }        $fp = fopen($url_csv, 'ab');        $export_array = array(            iconv('utf-8', 'gbk', '日期'),            iconv('utf-8', 'gbk', '财富通充值金额'),            iconv('utf-8', 'gbk', '支付宝冲值金额'),            iconv('utf-8', 'gbk', '微信冲值金额'),            iconv('utf-8', 'gbk', 'ios内购冲值金额'),            iconv('utf-8', 'gbk', '全部金额'),        );        fputcsv($fp, $export_array);        if ($data !== 0) {            foreach ($data['data'] as $value) {                $export_array = array(                    iconv('utf-8', 'gbk', "{$value['date']}\t"),                    iconv('utf-8', 'gbk', "{$value['total_tenpay']}\t"), #\t 可以使参数原样输出                    iconv('utf-8', 'gbk', "{$value['total_taobao']}\t"),                    iconv('utf-8', 'gbk', "{$value['total_wxpay']}\t"),                    iconv('utf-8', 'gbk', "{$value['total_ios']}\t"),                    iconv('utf-8', 'gbk', "{$value['total_all']}\t"),                );                fputcsv($fp, $export_array);            }        }        fclose($fp);

下载

a标签指向这个地址

/**     *      * @return [type] [description]     */    public function doExport()    {        $filename_url = WSING_ROOT . '/countall.csv';        $out_filename = 'countall.csv';        $filesize = filesize($filename_url);        header('Accept-Ranges: bytes');        header('Accept-Length: ' . $filesize);        // It will be called        header('Content-Transfer-Encoding: binary');        header('Content-type: application/octet-stream');        header('Content-Disposition: attachment; filename=' . $out_filename);        // The source is in filename        readfile($filename_url);        exit;    }
0 0
原创粉丝点击