php 导出简单例子附源码

来源：互联网发布：胜利足球欧赔数据库吧编辑：程序博客网时间：2024/06/05 18:30

注：这个是ci框架

这里因为使用db类，查出的数据为对象数组

$data['query']=

Array(    [query] => Array        (            [0] => stdClass Object                (                    [id] => 33                    [uid] => 7                    [type] => 3                    [loseid] => 34                    [userid] =>                     [note] => 减肥活动保证金扣款                    [total] => 63.00                    [time] => 1427444875                    [username] => tiandao2                    [title] => 孕妇装秋款连衣裙夏季时尚春秋装打底衫韩版春装衣服上衣                )            [1] => stdClass Object                (                    [id] => 35                    [uid] => 7                    [type] => 2                    [loseid] => 34                    [userid] =>                     [note] => 减肥活动 id:34,参与id:29 返款                    [total] => 21.00                    [time] => 1427445003                    [username] => tiandao2                    [title] => 孕妇装秋款连衣裙夏季时尚春秋装打底衫韩版春装衣服上衣                )            [2] => stdClass Object                (                    [id] => 37                    [uid] => 7                    [type] => 2                    [loseid] => 34                    [userid] =>                     [note] => 减肥活动 id:34,参与id:28 返款                    [total] => 21.00                    [time] => 1427445019                    [username] => tiandao2                    [title] => 孕妇装秋款连衣裙夏季时尚春秋装打底衫韩版春装衣服上衣                )            [3] => stdClass Object                (                    [id] => 39                    [uid] => 7                    [type] => 2                    [loseid] => 34                    [userid] =>                     [note] => 减肥活动 id:34,参与id:27 返款                    [total] => 21.00                    [time] => 1427445037                    [username] => tiandao2                    [title] => 孕妇装秋款连衣裙夏季时尚春秋装打底衫韩版春装衣服上衣                )            [4] => stdClass Object                (                    [id] => 41                    [uid] => 7                    [type] => 2                    [loseid] => 34                    [userid] =>                     [note] => 减肥活动 id:34,参与id:30 返款                    [total] => 21.00                    [time] => 1427447078                    [username] => tiandao2                    [title] => 孕妇装秋款连衣裙夏季时尚春秋装打底衫韩版春装衣服上衣                )        )    [paginate] => )

public function export_joindetail($id,$cur_page=0){

$limit=100;

$res=$this->common_m->get_one('loseweight',array('id'=>$id),'title');

$sql='SELECT journal_records.*, users.username,loseweight.title from journal_records

left join users on journal_records.uid=users.id

left join loseweight on journal_records.loseid=loseweight.id

where journal_records.type in(2,3) and journal_records.loseid='.$id;

$data = $this->common_m->get_relate_sql_list($sql,'/admin/account/joindetail/'.$id,$limit,$cur_page);

$output = "<HTML>";

$output .= "<HEAD>";

$output .= "<META http-equiv=Content-Type content=\"text/html; charset=utf-8\">";

$output .= "</HEAD>";

$output .= "<BODY>";

$output .= "<TABLE BORDER=1>";

$output .= "<tr><td colspan='6'> </td></tr>";

$output .= "<tr><td colspan='6' bgcolor='#538ED5'>活动账户流水记录</td></tr>";

$output .= "<tr><td bgcolor='#CCCCCC' align='center'>用户</td><td bgcolor='#CCCCCC' align='center'>活动</td><td align='center' bgcolor='#CCCCCC'>类型</td><td align='center' bgcolor='#CCCCCC'>操作日期</td><td align='center' bgcolor='#CCCCCC'>金额</td><td align='center' bgcolor='#CCCCCC'>备注</td></tr>";

foreach ($data['query'] as $key=>$value2) {

$output .= "<tr><td align='center'>{$value2->username}</td><td align='center'>{$value2->title}</td><td align='center'>";

if($value2->type==3){

$output.='活动保证金扣款';

}else if($value2->type==2){

$output.='活动返款';

}

$output.="</td><td align='center'>";

$output.=date('Y-m-d H:i:s',$value2->time);

$output.="</td><td align='center'>{$value2->total}</td><td align='center'>{$value2->note}</td></tr>";

}

$output .= "</TABLE>";

$output .= "</BODY>";

$output .= "</HTML>";

$upDowm=date('Ymd')."_减肥活动_".$res['title'].'_流水账';

header("Content-type:application/msexcel");

header("Content-disposition: attachment; filename={$upDowm}.xls");

header("Cache-control: private");

header("Pragma: private");

print($output);

}

0 0

php 导出 简单例子附源码

php 导出简单例子附源码