鑫安财富项目随记5--如何导出excel表

<a href="{url:/member/output_user}" ><button class="operating_btn" type="button"><span class="recharge">导出VIP列表(未分配理财师)</span></button></a>

在页面中的链接。

function output_user()
    {
        $member = new IQuery('member');
        $member->where = "apply_vip_status = 3 and (pro_id is null or pro_id = '')";
        $info = $member->find();
        header("Content-type:application/vnd.ms-excel charset=gb2312");
        header("Content-Disposition:attachment;filename=test_data.xls");
        $tx= '理财师分配表'."\n\n"."客户姓名"."\t". "电话号码"."\t"."地区"."\t"."理财经理工号"."\t"."理财经理电话号码"."\t\n";   
        echo   iconv("utf-8", "gb2312", $tx);   
        foreach($info as $key=>$value) 
        {
            echo   iconv("utf-8", "gb2312", $value['true_name'])."\t";   
            echo   iconv("utf-8", "gb2312", $value['mobile'])."\t";   
            echo   iconv("utf-8", "gb2312", $value['contact_addr'])."\t";
            echo    "\t"."\t"; 
            echo   "\n"; 
        }
    }

 

在member.php中的函数。

这样就可以导出一张excel表，十分的有效。

先放在这，以备不时之需。嘿嘿~

 

转载于:https://www.cnblogs.com/sjnloveprogram/archive/2012/07/03/2575294.html