1,分页
首先创建方法application/controllers/user.php
//分页 public function test(){ //状态类文件 $this->load->library('pagination'); //每页显示10条数据 $page_size=10; //$config['base_url']=''; //一共有多少条数据 $config['total_rows']='200'; //每页显示多少条 $config['per_page']=$page_size; $this->pagination->initialize($config); echo $this->pagination->create_links(); }
浏览器显示
2,分页加载到视图
application/controllers/user.php
//分页 public function test(){ //状态类文件 $this->load->library('pagination'); //每页显示10条数据 $page_size=10; //$config['base_url']=''; //一共有多少条数据 $config['total_rows']='200'; //每页显示多少条 $config['per_page']=$page_size; $this->pagination->initialize($config); //加载视图 $data['link']=$this->pagination->create_links(); $this->load->view('user/test',$data); }
创建视图文件
application/views/test.php
<html> <head></head> <body> <?=$links?> </body> </html>
浏览器显示:
3,如何获取参数,在控制器里面打印sql
application/controllers/user.php
//获取参数 $offset=intval($this->uri->segment(3)); $sql = "select * from blog_user limit $offset,$page_size";
4,自定义分页文字
//自定义分页文字 $config['first_link']='首页'; $config['next_link']='下一页';
5,配置获取分页参数位置
$config['uri_segment']=3;
完整代码:
//分页 public function test(){ //状态类文件(可以配置自动加载) $this->load->library('pagination'); //加载url参数(可以配置自动加载) $this->load->helper('url'); //每页显示10条数据 $page_size=10; $config['base_url']=site_url('user/test'); //一共有多少条数据 $config['total_rows']='200'; //每页显示条数 $config['per_page']=$page_size; //自定义分页文字 $config['first_link']='首页'; $config['next_link']='下一页'; //配置获取分页参数位置 $config['uri_segment']=3; $this->pagination->initialize($config); //获取参数 $offset=intval($this->uri->segment(3)); $sql = "select * from blog_user limit $offset,$page_size"; //echo $sql; //加载视图 $data['links']=$this->pagination->create_links(); $this->load->view('user/test',$data); }