Pagination and search displaying all records on ea

2019-09-03 02:30发布

站内文章 / 前沿技术
7 0 0

问题:

I'm using codeigniter 2.1.4 and i'm trying to display all the users files on a page with pagination of 5 records per page. The pagination links work but every link shows all the records.

My Model 

public function get_user_files($user_id, $keyword = NULL) {
    $select =   array(
        'files.name as filename',
        'files.id, files.remarks',
        'boxes.id as box_id',
        'boxes.bin_id as bin_id',
        'box_types.name as box_type',
        'companies.name as companyname'
    );
    $from   =   array('files','boxes','box_types','companies');
    $where  =   array(
        'files.status'      =>  'Warehouse',
        'files.box_id'      =>  'boxes.id',
        'boxes.box_type_id' =>  'box_types.id',
        'boxes.company_id'  =>  'companies.id',
        'boxes.user_id'     =>  $user_id
    )

    $this->db
        ->select($select)
        ->from($from)
        ->where($where);

    if ($keyword) {
        $this->db->like('files.name', $keyword);
    }

    $query = $this->db->get()->result_array();
    return $query;
}

My Controller

public function retrieve_box() {
    if ($this->correct_permission('client') == false) {
        redirect(base_url());
    }
    $this->load->helper('form');
    $keyword = $this->input->post('keyword');
    $data['files'] = $this->File->get_user_files($this->data['user_id'], $keyword);

    $total_rows = count($data['files']);

    // Pagination
    $this->load->library('pagination');

    $config['base_url'] = base_url() . 'client/service_request/type/retrieve-box';
    $config['uri_segment'] = 5;
    $config['total_rows'] = $total_rows;
    $config['per_page'] = 5;

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

    $data['pages'] = $this->pagination->create_links();

    $this->load->view('retrieve_box', $data);
}

My URL is like so

www.website.com/client/service_request/type/retrieve-box/

My View

<?php 
    $attributes = array('class' => 'standardForm', 'id' => 'retrieveBoxesForm');
    echo form_open('', $attributes);
    ?>
    <fieldset>
        <ul>
            <li>

                <?php
                    $data_form = array(
                        'name' => 'keyword',
                        'id' => 'boxes-field1',
                        'class' => 'textbox2',
                    );
                    echo form_input($data_form);
                ?>

                <?php
                    $data_form = array(
                        'class' => 'button2',
                        'value' => 'Search',
                    );
                    echo form_submit($data_form);
                ?>
            </li>
        </ul>
    </fieldset>

    <div class="clear"></div>
    <?php echo form_close(); ?>
    <div class="standardTable">
        <table>
            <thead>
                <tr>
                    <th><span class="checkboxReplacement"><input type="checkbox" /></span></th>
                    <th>Type</th>
                    <th>Filename</th>
                    <th>Box ID</th>
                    <th>Company</th>
                    <th>Location</th>
                    <th>Remarks</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>

                <?php foreach ($files as $file) { ?>
                    <tr>
                        <td><span class="checkboxReplacement"><input type="checkbox" /></span></td>
                        <td><?php echo $file['box_type']; ?></td>
                        <td><?php echo $file['filename']; ?></td>
                        <td><?php echo $file['box_id']; ?></td>
                        <td><?php echo $file['companyname']; ?></td>
                        <td><?php echo $file['bin_id']; ?></td>
                        <td><?php echo $file['remarks']; ?></td>
                        <td>
                            <a href="<?php echo base_url('client/retrievebox/' . $file['box_id']); ?>">Retrieve File</a> |
                            <a href="<?php echo base_url('client/retrievefile/' . $file['id']); ?>">Retrieve Box</a>
                        </td>
                    </tr>
                <?php } ?>

            </tbody>
        </table>
        <?php echo $pages; ?>
    </div>

Objective When a user goes to the above link, all of his/her files are displayed but with pagination of 5 records per page.

They can search their file names to get a more specific record.

I've managed to display the links like so:

www.website.com/client/service_request/type/retrieve-box/
www.website.com/client/service_request/type/retrieve-box/5
www.website.com/client/service_request/type/retrieve-box/10

But when i click on any of the pagination links, i'm taken to the respective url but all the records are showing.

Thank you for reading this. Really struggling to find a solution.

Regards :)

回答1:

You need two functions for it. First, to count the total files a user has, and the second to get the results pagination wise. What you are doing wrong here is that you are fetching all the records in a single query and looping through all the results.

 /* count all results */
function count_all_user_files($user_id, $keyword = NULL) {
    $this->db->from('files');
    $this->db->join('boxes', 'files.box_id = boxes.id');
    $this->db->join('box_types', 'boxes.box_type_id = box_types.id');
    $this->db->join('companies', 'boxes.company_id = companies.id');
    $this->db->where('files.status', 'Warehouse');
    $this->db->where('files.box_id = boxes.id');
    $this->db->where('boxes.box_type_id = box_types.id');
    $this->db->where('boxes.company_id = companies.id');
    $this->db->where('boxes.user_id', $user_id);
    if ($keyword) {
        $this->db->like('files.name', $keyword);
    }
    return $this->db->count_all_results();
}

/* get result to show */
function all_user_files( $user_id, $keyword = NULL, $limit, $offset ) {
    $this->db->select('files.name as filename, files.id, files.remarks');
    $this->db->select('boxes.id as box_id, boxes.bin_id as bin_id');
    $this->db->select('box_types.name as box_type');
    $this->db->select('companies.name as companyname');
    $this->db->from('files');
    $this->db->join('boxes', 'files.box_id = boxes.id');
    $this->db->join('box_types', 'boxes.box_type_id = box_types.id');
    $this->db->join('companies', 'boxes.company_id = companies.id');
    $this->db->where('files.status', 'Warehouse');
    $this->db->where('files.box_id = boxes.id');
    $this->db->where('boxes.box_type_id = box_types.id');
    $this->db->where('boxes.company_id = companies.id');
    $this->db->where('boxes.user_id', $user_id);
    if ($keyword) {
        $this->db->like('files.name', $keyword);
    }
    return $this->db->get()->result_array();
}

/* Config */
$config['base_url']     = base_url() . 'client/service_request/type/retrieve-box';
$config['uri_segment']  = 5;
$config['total_rows']   = $this->model_name->count_all_user_files( $user_id, $keyword );
$config['per_page']     = 5;

$data['files']          = $this->File->get_user_files($this->data['user_id'], $keyword, $config['per_page'], $this->uri->segment(5));


回答2:

$data['pages'] = $this->pagination->create_links();

No need to pass the pagination through data array.(line above)

Just echo $this->pagination->create_links();

will do.

Also please change the value of $config['uri_segment'] and check.

UPDATE

Okay.The problem is you haven't added limit and offset to the query.

Add to Controller

public function retrieve_box() {
if ($this->correct_permission('client') == false) {
    redirect(base_url());
}
$this->load->helper('form');
$keyword = $this->input->post('keyword');
$total = $this->File->get_user_files($this->data['user_id'], $keyword,'','');

$total_rows = count($total);

// Pagination
$this->load->library('pagination');

$config['base_url'] = base_url() . 'client/service_request/type/retrieve-box';
$config['uri_segment'] = 5;
$config['total_rows'] = $total_rows;
$config['per_page'] = 5;

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

$data['pages'] = $this->pagination->create_links();

$limit=$config['per_page'];
$offset= $this->uri->segment(5);

$data['files'] = $this->File->get_user_files($this->data['user_id'], $keyword,$limit,$offset);

$this->load->view('retrieve_box', $data);
}

Model

public function get_user_files($user_id, $keyword = NULL,$limit='',$offset='') {
       if(!empty($limit)){
      $this->db->limit($limit);
      }
  //offset
    if(!empty($offset)){
     $this->db->offset($offset);
    }
    $this->db->select('files.name as filename, files.id, files.remarks')->from('files');
    $this->db->select('boxes.id as box_id, boxes.bin_id as bin_id')->from('boxes');
    $this->db->select('box_types.name as box_type')->from('box_types');
    $this->db->select('companies.name as companyname')->from('companies');
    $this->db->where('files.status', 'Warehouse');
    $this->db->where('files.box_id = boxes.id');
    $this->db->where('boxes.box_type_id = box_types.id');
    $this->db->where('boxes.company_id = companies.id');
    $this->db->where('boxes.user_id', $user_id);

    if ($keyword) {
        $this->db->like('files.name', $keyword);
    }

    $query = $this->db->get()->result_array();
    return $query;
}


标签： codeigniter pagination
举报

收藏的人(0)

Ta的文章 更多文章
登录 后发表评论
0条评论
还没有人评论过~