ThinkPHP实现分页功能(2)

//商品列表 function showlist(){ //实现分页效果 $goods = D('goods'); //① 获得数据的总记录条数 $total = $goods -> count(); //select count(*) from sw_goods; $per = 7; //每页显示7条记录 //②实例化分页类 $page_obj = new \Tools\Page($total, $per); //③自定义sql语句，获取每页信息 $sql = "select * from sw_goods order by goods_id desc ".$page_obj->limit; $info = $goods->query($sql); //④获取页码列表 $pagelist = $page_obj->fpage(array(3,4,5,6,7,8)); //分配 $this->assign('pagelist',$pagelist); $this->assign('info',$info); $this->display(); }