PHP方案实现数据导出

来源：互联网发布：老式电视网络机顶盒编辑：程序博客网时间：2024/06/05 01:20

【HTML代码】

<a class="btn btn-warning" href="export?QUERY_STRING=<? echo $_SERVER['QUERY_STRING'] ?>">导出职工信息</a>

//此处的$_SERVER['QUERY_STRING']是页面参数id，跟例子无关！

【PHP代码】

public function export()

{

$_SERVER['QUERY_STRING']=$this->input->get('QUERY_STRING');

//获取页面参数id方便使用底层函数，如下面的$this->base_user_model->search()->get()->result();

       $allusers=$this->base_user_model->search()->get()->result();
       $title=date('Y年m月');
       Header( "Content-type:application/vnd.ms-excel;charset=gb2312");
       Header( "Content-Disposition:filename=".$title."职工列表.xls ");
       echo "<table border='1'><thead><tr>";
            echo "<td>姓名</td>";
           echo "<td>在职</td>";
            echo "<td>联系方式</td>";
           echo "<td>登录信息</td>";
           echo "<td>性别</td>";
           echo "<td>分校</td>";
           echo "<td>最高学历</td>";
           echo "<td>毕业院校</td>";
           echo "<td>毕业时间</td>";
           echo "<td>入职时间</td>";
           echo "<td>工作职务</td>";
           echo "<td>生日</td>";
           echo "<td>QQ</td>";
           echo "<td>Email</td>";
           echo "<td>所在省市</td>";
           echo "<td>街道地址</td>";
       echo "</tr></thead><tbody>";
       foreach ($allusers as $user)
       {
           echo "<tr><td>".$user->name."</td>";
           echo "<td>".element($user->classify,config_item('user_classify'))."</td>";
           echo "<td>".$user->mobilephone."</td>";
           echo "<td>".$user->username."</td>";
           echo "<td>".$user->sex."</td>";
           echo "<td>";
           if ($this->base_school_model->cache_by_id($user->school_id))
               echo $this->base_school_model->cache_by_id($user->school_id)->name."</td>";
           echo "<td>".$user->xueli."</td>";
           echo "<td>".$user->yuanxiao."</td>";
           echo "<td>".$user->biye_time."</td>";
           echo "<td>".$user->join_time."</td>";
           echo "<td>".$user->zhiwu."</td>";
           echo "<td>".$user->birthday."</td>";
           echo "<td>".$user->qq."</td>";
           echo "<td>".$user->email."</td>";
           echo "<td>".$this->base_region_model->get_ids(array($user->province, $user->city, $user->county))."</td>";
           echo "<td>".$user->address."</td></tr>";
       }
       echo "</tbody></table>";

}

【效果预览】

0 0