csv 导出

$data[title] = '用户数据统计';
$rowname = array('用户ID', '用户名', '总发帖数', '总回复数', '总点赞数');
$data['rowname'] = $rowname;


if ($_GET['exportexcel_statistics']) {
    extract($statvars);
    $filename = 'statistics_' . $type . '_' . $startDate . '_' . $endDate . rand() . '.csv';
    include template('service/statistics_statistics');
    $csvstr = ob_get_contents();
    ob_end_clean();
    header('Content-Encoding: none');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename=' . $filename);
    header('Pragma: no-cache');
    header('Expires: 0');
    if ($_G['charset'] != 'gbk') {
        $csvstr = diconv($csvstr, $_G['charset'], 'GBK');
    }
    echo $csvstr;
    exit;

}

statistics_statistics.htm

<!--{if $_GET['exportexcel']}-->
<!--{loop $value['reply'] $row}-->
<!--{loop $row $key=>$value}-->
{$value},<!--{/loop}--><!--{echo "\r\n";}-->
<!--{/loop}-->
<!--{else}-->
$data[title]({$startDate}至{$endDate})
<!--{echo "\r\n";}-->
<!--{loop $data[rowname] $colname}-->
$colname,<!--{/loop}-->
<!--{echo "\r\n";}-->
<!--{loop $list $row}-->
<!--{loop $row $key=>$value}-->


$value,<!--{/loop}--><!--{echo "\r\n";}-->
<!--{/if}-->
<!--{/if}-->