Search code examples
phpcodeignitersortingcodeigniter-pagination

Sorting in CodeIgniter Pagination


The other day I managed to implement Pagination in CI using a wonderful tutorial found on the net. The next day, I noticed that Sorting was not covered in the tutorial. So I went on to implement sorting, and successfully implemented it. However, the issue arose that the pagination links did not contain the specific URI Segments related to "sortfield" and "sortorder" and hence the confusion.

If anyone knows about a way to implement sorting such that it is retained on all pages, let me know.

My test URL : http://zzz.zzz.z.zz/frog/index.php/questions/page/1/id/desc which is not retained when I click on page 2

My code:

function page($offset = 0,$sortfield=null,$order=null) {
/**
* Removed all the unnecessary code
*/
    $config = array (
                    'base_url' => base_url () . 'index.php/questions/page/',
                    'total_rows' => $this->db->count_all ( 'questions' ),
                    'per_page' => $this->input->get ( 'perpage' ) ? $this->input->get ( 'perpage' ) : (@$layoutspecificpagination->per_page ? $layoutspecificpagination->per_page : 5),
                    'num_links' => 5,
                    'reuse_query_string' => true
            );

    $config ['total_rows'] = $this->questionsm->read ( $config ['per_page'], $offset, true );

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

Then in the view:

<?php echo $this->pagination->create_links(); ?>

Solution

  • I did the following to get the answer:

    1. Changed the order of the parameters passed in the function

      function page($sortfield=null,$order=null,$offset = 0) {}

    2. As told by @rejoanul-alam, modified the base URL as such

      $config = array ( 'base_url' => base_url () . 'index.php/questions/page/'.$sortfield.'/'.$order.'/', 'total_rows' => $this->db->count_all ( 'questions' ), 'per_page' => $this->input->get ( 'perpage' ) ? $this->input->get ( 'perpage' ) : (@$layoutspecificpagination->per_page ? $layoutspecificpagination->per_page : 5), 'num_links' => 5, 'reuse_query_string' => true );

    There was no need for getting URI segments in controller as they were already being passed in the function

    1. Changed the sort table heading in view accordingly.