CI框架实现分页

一、模型

   /*
     * 文章分页
     * */
    public function getpage($offset,$per_page_nums,$table,$cate_id){
        $result=$this->db->where(['article_cate_id'=>$cate_id,'article_is_deleted'=>0,'article_status'=>3])
                ->order_by('article_create','desc')
                ->limit($per_page_nums,$offset)->get($table);
        return $result->result_array();
    }
    /*
     * 文章总条数
     * */
    public function allnums($table,$cate_id){
        $result=$this->db->where(['article_cate_id'=>$cate_id,'article_is_deleted'=>0,'article_status'=>3])
            ->get($table);

        return $result->num_rows();
    }

二、控制器

    /*新闻分页*/
    public function articlepage($page,$cate_id,$per_page=0,$base_url){
        $this->load->library('pagination');
        $this->load->helper('url');
        $count=$this->articlelist->allnums('nct_article',$cate_id);
        $config['per_page']=2;
        $config['total_rows']=$count;
        $config['first_link']='首页';
        $config['prev_link']='上一页';
        $config['next_link']='下一页';
        $config['last_link']='末页';
        $config['page_query_string'] = TRUE;
//      $config['base_url']=base_url('web/BookMain/showPage/news');
        $config['base_url']=base_url($base_url);
        $this->pagination->initialize($config);
        $query['newslist']=$this->articlelist->getpage($per_page,$config['per_page'],'nct_article',$cate_id);
        $query['link']=$this->pagination->create_links();
        return $query;

    }

三、视图

<?php foreach($newslist as $news_item):?>
                <a href="article_detail?article_id=<?php echo $news_item['article_id']?>" style="color:#333;text-decoration: none">
                <li>
                    <div class="img_l">
                        <img src="/public/img/home-pic1.png" alt="">
                    </div>
                    <div class="news_r">
                        <p class="title"><?php echo $news_item['article_name']?></p>
                        <p class="describe"><?php echo $news_item['article_describe']?></p>
                        <p class="time"><?php echo $news_item['article_create']?></p>
                    </div>
                </li>
                </a>
                <?php endforeach;?>
                <div class="xian"></div>
                <div class="page-turning">
                    <?php echo $link;?>
                </div>