Search code examples
phppaginationcodeigniter-4

Pagination in Desc or Asc Order in CI 4

I am working on CI 4 pagination. Pagination is working fine and by defaults it returns results in asc order.

Here is my code i am using in controller like this.

$data['blog_posts'] = $this->blogsModel->paginate('10');

Problem

How can i get data in DESC order in CI 4?

Solution

  • In CI4, you can use the following :

    $this->model->orderBy($sort_key, $sort_value);

    Also note, orderBy will be before the pagination.