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 {
     width: 600px;
     margin: auto;
    font-family: helvetica, arial;
    }

    table {
     width: 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

转载于:https://www.cnblogs.com/caroar/archive/2012/12/12/2814823.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值