Welcome Guest, Not a member yet? Register   Sign In
Pagination in descending order
#1

(This post was last modified: 06-27-2020, 08:16 AM by mohs3n.)

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
#4

(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); 

<?php echo $pager->links('article', 'front_pagination');?>

it doesnt work to me, the error say "Call to member function links() on null" in view.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB