php列表导出程序,PHP方案实现数据导出

【HTML代码】

导出职工信息

//此处的$_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 "

echo "

姓名";

echo "

在职";

echo "

联系方式";

echo "

登录信息";

echo "

性别";

echo "

分校";

echo "

最高学历";

echo "

毕业院校";

echo "

毕业时间";

echo "

入职时间";

echo "

工作职务";

echo "

生日";

echo "

QQ";

echo "

Email";

echo "

所在省市";

echo "

街道地址";

echo "

";

foreach ($allusers as $user)

{

echo "

".$user->name."";

echo "

".element($user->classify,config_item('user_classify'))."";

echo "

".$user->mobilephone."";

echo "

".$user->username."";

echo "

".$user->sex."";

echo "

";

if ($this->base_school_model->cache_by_id($user->school_id))

echo $this->base_school_model->cache_by_id($user->school_id)->name."

";

echo "

".$user->xueli."";

echo "

".$user->yuanxiao."";

echo "

".$user->biye_time."";

echo "

".$user->join_time."";

echo "

".$user->zhiwu."";

echo "

".$user->birthday."";

echo "

".$user->qq."";

echo "

".$user->email."";

echo "

".$this->base_region_model->get_ids(array($user->province, $user->city, $user->county))."";

echo "

".$user->address."";

}

echo "

";

}

【效果预览】