skymvc开发手册之数据分页显示
查看视频教程或者获取有关《skymvc开发手册》更多信息

skymvc数据分页显示

//mysql处理部分


$limit=20;
$start=get("per_page","i");
$option=array(
	"start"=>intval(get_post('per_page')),
	"limit"=>$limit,
	"order"=>" id DESC",
	"where"=>$where
);
$rscount=true;
$data=M("guest")->select($option,$rscount);			

$start==>开始记录数

//ctrl处理部分

$pagelist=$this->pagelist($rscount,$limit,$url);

$rscount==>mysql中的所有记录

$limit==>每次显示的记录数

$url==>当前网址

实例:

public function onDefault(){
	$where="1";
	$url="/index.php?m=guest&a=default";
	$limit=20;
	$start=get("per_page","i");
	$option=array(
		"start"=>intval(get_post('per_page')),
		"limit"=>$limit,
		"order"=>" id DESC",
		"where"=>$where
	);
	$rscount=true;
	$data=M("guest")->select($option,$rscount);
	//分页
	$pagelist=$this->pagelist($rscount,$limit,$url);
	//end分页
	$this->smarty->goassign(
		array(
			"data"=>$data,
			"pagelist"=>$pagelist,
			"rscount"=>$rscount,
			"url"=>$url
		)
	);
	$this->smarty->display("guest/index.html");
}