• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pagination in descending order

#1
Hi

In my controller I have this :

Code:
$article = new Article();
$data = [
            'articles' => $article->paginate(5),
            'pager' => $article->pager
        ];

echo view('panel/template', $data);

Which loads the records from the article table and uses the pagination module to limit the number of records per page in the view file.
The pagination module loads the records in ascending order by default but I need to have them in Descending order which means I need the new articles to be on the first page.

Any idea how to do that?
Reply

#2
(06-27-2020, 08:15 AM)mohs3n Wrote: Hi

In my controller I have this :

Code:
$article = new Article();
$data = [
            'articles' => $article->paginate(5),
            'pager' => $article->pager
        ];

echo view('panel/template', $data);

Which loads the records from the article table and uses the pagination module to limit the number of records per page in the view file.
The pagination module loads the records in ascending order by default but I need to have them in Descending order which means I need the new articles to be on the first page.

Any idea how to do that?

Have you tried this?

PHP Code:
$article = new Article();
$data = [
            'articles' => $article->orderBy('id''DESC')
            ->paginate(5),
            'pager' => $article->pager
        
];

echo 
view('panel/template'$data); 
Reply

#3
(06-27-2020, 02:31 PM)wdeda Wrote:
(06-27-2020, 08:15 AM)mohs3n Wrote: Hi

In my controller I have this :

Code:
$article = new Article();
$data = [
            'articles' => $article->paginate(5),
            'pager' => $article->pager
        ];

echo view('panel/template', $data);

Which loads the records from the article table and uses the pagination module to limit the number of records per page in the view file.
The pagination module loads the records in ascending order by default but I need to have them in Descending order which means I need the new articles to be on the first page.

Any idea how to do that?

Have you tried this?

PHP Code:
$article = new Article();
$data = [
            'articles' => $article->orderBy('id''DESC')
            ->paginate(5),
            'pager' => $article->pager
        
];

echo 
view('panel/template'$data); 

Nice one wdeda
That worked.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.