首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >单击next/prev或第二页时将代码点火器分页重定向到同一页

单击next/prev或第二页时将代码点火器分页重定向到同一页
EN

Stack Overflow用户
提问于 2015-06-05 06:03:35
回答 1查看 2.1K关注 0票数 1

我对CodeIgniter分页很陌生。我有一张显示用户的表格。我要把它分页。但我的问题是它在页面中显示相同的数据。我是说,当我点击第二页或下一页时。它重定向到同一页。要怎么解决这个问题?

代码语言:javascript
复制
 $config = array();
    $config["base_url"] = site_url('User/viewUsers/');
    $config['total_rows'] =  $this->db->get('user')->num_rows();
    $config["per_page"] = 10;
    $config["num_links"] = 1;
    $config['uri_segment'] = 4;
    //$config['use_page_numbers'] = TRUE;

    $config['enable_query_strings'] = TRUE;

    //Adding Enclosing Markup
    $config['full_tag_open'] = '<p><ul  class="pagination">';
    $config['full_tag_close'] = '</ul></p><!--pagination-->';
    //Customizing the First Link
    $config['first_link'] = '&laquo; First';
    $config['first_tag_open'] = '<li class="prev page">';
    $config['first_tag_close'] = '</li>';
    //Customizing the Last Link
    $config['last_link'] = 'Last &raquo;';
    $config['last_tag_open'] = '<li class="next page">';
    $config['last_tag_close'] = '</li>';
    //Customizing the "Next" Link
    $config['next_link'] = 'Next &rarr;';
    $config['next_tag_open'] = '<li class="next page">';
    $config['next_tag_close'] = '</li>';
    //Customizing the "Previous" Link
    $config['prev_link'] = '&larr; Previous';
    $config['prev_tag_open'] = '<li class="prev page">';
    $config['prev_tag_close'] = '</li>';
    //Customizing the "Current Page" Link
    $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
    $config['cur_tag_close'] = "<span class='sr-only'></span></a></li></li>";
    //Customizing the "Digit" Link
    $config['num_tag_open'] = '<li class="page">';
    $config['num_tag_close'] = '</li>';

    $this->pagination->initialize($config);

    $page = $this->uri->segment(4);
    //$page = ($this->uri->segment(4) > 0) ? $this->uri->segment(4) : 0;
    $data = array(); 
    $data['users'] = $this->user_model->getUserList($config["per_page"], $page);

    $data['links'] = $this->pagination->create_links();
    $data['fullname'] = NULL; 
            $this->load->view('include/header');
        $this->load->view('admin/viewUsers',$data); 
        $this->load->view('include/footer');

型号:

代码语言:javascript
复制
public function getUserList($limit,$start){
    $query = array();
    $this->db->limit($limit, $start);
    $this->db->order_by('user_id'); 
    $query = $this->db->get('user');  
    return $query->result();
}
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2015-06-05 06:14:03

改变这个

控制器中的

代码语言:javascript
复制
<?php

    $count = $this->db->get('user')->num_rows();

    $config['base_url'] = base_url().'User/viewUsers/';
    $config['total_rows'] = $count;
    $config["per_page"] = 10;
    $config['uri_segment'] = 3;
    $limit = $config['per_page'];

//    $config['enable_query_strings'] = TRUE;

    $config['full_tag_open'] = '<ul class="pagination">';
    $config['full_tag_close'] = '</ul>';
    $config['first_link'] = false;
    $config['last_link'] = false;
    $config['first_tag_open'] = '<li>';
    $config['first_tag_close'] = '</li>';
    $config['prev_link'] = '&laquo';
    $config['prev_tag_open'] = '<li class="prev">';
    $config['prev_tag_close'] = '</li>';
    $config['next_link'] = '&raquo';
    $config['next_tag_open'] = '<li>';
    $config['next_tag_close'] = '</li>';
    $config['last_tag_open'] = '<li>';
    $config['last_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="active"><a href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['num_tag_open'] = '<li>';
    $config['num_tag_close'] = '</li>';

    $this->pagination->initialize($config);

 $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;

    $data['users'] = $this->user_model->getUserList($limit, $page);
    $data['links'] = $this->pagination->create_links();
    $data['fullname'] = NULL;

    $this->load->view('include/header');
    $this->load->view('admin/viewUsers',$data);
    $this->load->view('include/footer');

模型中的应用

代码语言:javascript
复制
    public function getUserList($limit,$page)
{
    $query = $this->db->query("SELECT * FROM user LIMIT $page, $limit");
    $result = $query->result_array();
    return $result;
}
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/30659371

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档