• CI分页类使用入门


    原文:http://hi.baidu.com/jami918/item/a23b249fbe6a3dc9b6253144

    1、

    模型:Postsmodel

    <?php
    class Postsmodel extends CI_Model
    {
        public function __construct()
        {
            parent::__construct();
        }
        public function count_posts()
        {
            return $this->db->count_all('test');
        }
        public function list_posts($limit,$offset)
        {
            $this->db->limit($limit,$offset);
            $query=$this->db->get('test');
            return $query->result();
        }
    }
    ?>

    控制器:Posts

    <?php
    class Posts extends CI_Controller
    {
        function __construct()
        {
            parent::__construct();
            $this->load->helper('url');
            $this->load->library('pagination');
            $this->load->model('Postsmodel','posts');
        }
        function index($offset='')
        {
            $limit=2;
            $total = $this->posts->count_posts();
            $data['posts']=$this->posts->list_posts($limit,$offset);


            $config['base_url']= base_url().'posts/index/';
            $config['total_rows']=$total;
            $config['per_page']= $limit;
            $this->pagination->initialize($config);
            $data['pag_links'] = $this->pagination->create_links();
            //echo $this->pagination->create_links();
            $data['title']='Pagination';
            $this->load->view('posts',$data);
        }
    }

    视图:Posts
    <h1>Pagination</h1><br>
    <?php
        foreach($posts as $p)
        {
     ?>
            <div class="post">
            <div class="title"><?php echo $p->id?></div>
            <div class="title"><?php echo $p->content;?></div>
            </div>
    <?php
            echo $p->name;
            echo "<br>";
        }
        echo $pag_links;
    ?>

    方式2:

    控制器:Site

    <?php

    class Site extends Controller {
        function index()
        {
            $this->load->library('pagination');
            $this->load->library('table');
            
            //$this->table->set_heading('Id', 'The Title', 'The Content');
            
            $config['base_url'] = 'http://localhost:8888/ci/index.php/site/index';
            $config['total_rows'] = $this->db->get('data')->num_rows();
            $config['per_page'] = 10;
            $config['num_links'] = 20;
            $config['full_tag_open'] = '<div id="pagination">';
            $config['full_tag_close'] = '</div>';
            
            $this->pagination->initialize($config);
            
            $data['records'] = $this->db->get('data', $config['per_page'], $this->uri->segment(3));
            
            $this->load->view('site_view', $data); 
        }
    }

    模型:无

    视图:site_view

    <!DOCTYPE html>

    <html lang="en">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
        <title>untitled</title>
        <style type="text/css" media="screen">
        #container {
          600px;
         margin: auto;
        font-family: helvetica, arial;
        }

        table {
          600px;
         margin-bottom: 10px;
        }

        td {
         border-right: 1px solid #aaaaaa;
         padding: 1em;
        }

        td:last-child {
         border-right: none;
        }

        th {
         text-align: left;
         padding-left: 1em;
         background: #cac9c9;
        border-bottom: 1px solid white;
        border-right: 1px solid #aaaaaa;
        }

        #pagination a, #pagination strong {
         background: #e3e3e3;
         padding: 4px 7px;
         text-decoration: none;
        border: 1px solid #cac9c9;
        color: #292929;
        font-size: 13px;
        }
        #pagination strong, #pagination a:hover {
         font-weight: normal;
         background: #cac9c9;
        }        
        </style>
    </head>
    <body>
         <div id="container">
            <h1>Super Pagination with CodeIgniter</h1>
            
            <?php echo $this->table->generate($records); ?>
            <?php echo $this->pagination->create_links(); ?>
         </div>
         
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript" charset="utf-8"></script>    

    <script type="text/javascript" charset="utf-8">
        $('tr:odd').css('background', '#e3e3e3');
    </script>
    </body>
    </html>    

    CI扩展分页类,使其适用于ajax分页

    http://rabbit52.com/2012/devel/extending-pagination-library-for-ajax

  • 相关阅读:
    iOS开发 关于启动页和停留时间的设置
    iOS应用开发,全局强制竖屏,部分页面允许旋转的处理
    iOS利用Application Loader打包提交到App Store时遇到错误The filename 未命名.ipa in the package contains an invalid character(s). The valid characters are:A-Z ,a-z,0-9,dash,period,underscore,but the name cannot start w
    iOS之加载Gif图片
    Node以数据块的形式读取文件
    Nodejs日志管理包
    Java操作SFTP
    Nginx+Nodejs搭建图片服务器
    使用Atlas实现MySQL读写分离
    MySQL-(Master-Slave)配置
  • 原文地址:https://www.cnblogs.com/leonbond/p/2814823.html
Copyright © 2020-2023  润新知