Question

thinkPHP查询后的数据进行分页显示

thinkPHP查询后的数据进行分页显示

Answer 1

给个例子
import('ORG.Util.Page');
//艺术家查询
$sss=$_GET['textfield'];//这个就是你需要传的参数，你的条件，分页时候需要用到
if(isset($_POST['Submit'])&&($_POST['textfield'])||$sss!=NULL){//判断你是不是条件查询
$name=$_POST['textfield'];
$tag=$_POST['select'];
if($sss!=""){
$name=$_GET['textfield'];//
传的参数，分页时候用到
$tag=$_GET['select'];//你传的参数，分页时候用到
}
$nowPage = isset($_GET['p'])?$_GET['p']:1;
$count= $this->where("yishu_artist.".$tag." like "."'%$name%'")->count();
$Page = new Page($count,15);
$list = $this->where("yishu_artist.".$tag." like "."'%$name%'")->order('artistId desc')->page($nowPage.','.$Page->listRows)->select();
}
else{
$count= $this->count();
$Page = new Page($count,15);
$nowPage = isset($_GET['p'])?$_GET['p']:1;
$list = $this->order('create_time desc')->page($nowPage.','.$Page->listRows)->select();
}
$show = $Page->show();