ci分页

调用视图newslist页面

控制器news_list

class News_list extends CI_Controller{
 var $base;
 var $base_admin;
 function News_list(){
  parent::__construct();
  $this->base=$this->config->item('base_url');
  $this->base_admin=$this->base.'admin/';
 }
 function index(){
  $data['base']=$this->base;
  $data['base_admin']=$this->base_admin;
  $this->load->model('n');
  $rows=$this->n->index();  //×?????
  $this->load->library('pagination');
  $config['base_url'] = $this->base.'/m/news_list/index';
  $config['total_rows'] = $rows;
  $config['per_page'] = '1';
  $config['uri_segment']='4';
  $this->pagination->initialize($config);
  $data['page']=$this->pagination->create_links();
  //load the model and get results
  $data['results'] = $this->n->news_list($this->uri->segment(4),$config['per_page']);
  $this->load->view('admin/news_list_lm',$data);

 
 }
 
 }

 

从模型n文件中news_list方法中传进参数，模型中接受参数并分页显示。

 function news_list($num,$offset){
  $base=$this->config->item('base_url');
  if($num==""){
   $num=0;
  }
   $sql="select *,(select news_class_title from news_class where news_class_id=news.news_class_id) as news_class_title from news order by newsid desc limit $num , $offset ";
         $query=$this->db->query($sql);
   $list=" ";
   foreach($query->result() as $row){
    $list=$list.'$row->newstime.';
   }
  
   return $list;
 }