CI框架分页类及其实现

不BB了，直接上代码

Model类

class Page_model extends CI_Model{    public function get_page()    {        //这是一个sql语句，查询需要的结果，并将结果返回        $data = $this->db->select('id,name,age')->from('user')->get()->result_array();        return $data;    }}

控制器类

class Pages extends CI_Controller{    public function page(){        //载入分页类        $this->load->library('pagination');        $perPage=10;//每页10条        //配置项设置        $config['base_url']=site_url("pages/page");        $config['total_rows']=$this->db->count_all_results('user');        $config['per_page']=$perPage;        $config['uri_segment']=3;//偏移量，默认是3，如果在控制器有二级目录，根据偏移量层级而定        //自定义配置        $config['first_link']="首页";        $config['prev_link']="上一页";        $config['next_link']="下一页";        $config['last_link']="尾页";        //传入配置项，并生成链接        $this->pagination->initialize($config);        $data['links']=$this->pagination->create_links();        //设置偏移量        $offset=$this->uri->segment(3);        $this->db->limit($perPage,$offset);        //加载模型类和视图        $this->load->model("page_model","page");        $data['user']=$this->page->get_page();        $this->load->view("pages/page.html",$data);    }}

View文件（page.html中的核心代码）

<table>        <tr>            <td>ID</td>            <td>名字</td>            <td>年龄</td>        </tr>        <?php foreach($user as $v):?>        <tr>            <td><?php echo $v['id'] ?></td>            <td><?php echo $v['name'] ?></td>            <td><?php echo $v['age'] ?></td>        </tr>        <?php endforeach?>    </table>    <?php echo $links ?>

效果图