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"); }