How to reverse Array of Data in Laravel when using Eloquent with Pagination?

Question

I am fetching a list of data using Eloquent method and trying to reverse the order of array, I am getting an error.

Here is the code :(Previous Code)

$temp = Product::paginate(20);

New Code

$temp = Product::paginate(20)->orderBy('id','desc');

Error :

Method Illuminate\Database\Eloquent\Collection::orderBy does not exist.

New method :

$temp = Product::paginate(20)->sortDesc();

Error :

Method Illuminate\Database\Eloquent\Collection::appends does not exist.

Can anyone help me?

sajjad · Accepted Answer · 2021-08-23 09:12:16Z

2

use below syntax

Product::orderBy('id','desc')->paginate(20);

answered Aug 23, 2021 at 9:12

sajjad

4875 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gert B. Over a year ago

Always explain your answer :-)

Hanan Alhasan · Accepted Answer · 2021-08-23 09:10:44Z

1

try to write it in this way, use orderBy before the paginate

$temp = Product::orderBy('id','desc')->paginate(20);

answered Aug 23, 2021 at 9:10

Hanan Alhasan

3003 silver badges15 bronze badges

Comments

Rahul Jat · Accepted Answer · 2021-08-23 09:18:06Z

0

->latest() fetches the most recent set of data from the Database. In short, it sorts the data fetched, using the 'created_at' column to chronologically order the data.

Product::latest()->paginate(20)

answered Aug 23, 2021 at 9:18

Rahul Jat

7061 gold badge7 silver badges14 bronze badges

1 Comment

Gert B. Over a year ago

That is not the question, the question is to order the result with orderBy . latest() will work for an order on id, but since he is calling the functions in the wrong order, this is not the needed answer.

Collectives™ on Stack Overflow

How to reverse Array of Data in Laravel when using Eloquent with Pagination?

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related