public function usergl(){
$User = M("User");
$list = $User->where("lv=0")->select();
$total = $User->where("lv=0")->count();
$page = new \Think\Page($total,10);
$page->setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$userlist = $User->where("lv=0")->limit($page->firstRow.','.$page->listRows)->select();
$this->assign('pagebutton',$page->show());
$this->assign('usergl',$userlist);
$this->display();
}
第1个回答 2014-10-09
这个一个查询自定义函数
首先定义数据库模型
$User = M("User");
然后查询数据，一共有多少条，一共有多少页，分页查询
$total = $User->where("lv=0")->count();
$page = new \Think\Page($total,10);
$page->setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$userlist = $User->where("lv=0")->limit($page->firstRow.','.$page->listRows)->select();
最后赋值到模板，载入模板
$this->assign('pagebutton',$page->show());
$this->assign('usergl',$userlist);
$this->display();本回答被提问者采纳
首先定义数据库模型
$User = M("User");
然后查询数据，一共有多少条，一共有多少页，分页查询
$total = $User->where("lv=0")->count();
$page = new \Think\Page($total,10);
$page->setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$userlist = $User->where("lv=0")->limit($page->firstRow.','.$page->listRows)->select();
最后赋值到模板，载入模板
$this->assign('pagebutton',$page->show());
$this->assign('usergl',$userlist);
$this->display();本回答被提问者采纳
