Laravel sort by descending or ascending with pagination

Question

I would like to perform a sort by ascending or descending together with pagination

  return \App\User:: paginate($request->per_page);

how do i add the sort by so something like this

return \App\User:: paginate($request->per_page)-sortBy(
    $request->sort_field, $request->sort_order
  );

bur the above fails where

$request->sort_order //asc or desc

the above returns an error of

"asort() expects parameter 2 to be integer, string given"

possible duplicates of : https://stackoverflow.com/questions/17429427/laravel-eloquent-ordering-results-of-all — teeyo, Oct 06 '17 at 14:27

teeyo · Answer 1 · 2017-10-06T14:38:45.297

1

I can't see the syntax in where you may enter the order (DESC or ASC) in the Laravel docs, Try this :

if ($request->sort_order == 'asc') {
   return \App\User::paginate($request->per_page)->sortBy($request->sort_field); 
}
return \App\User::paginate($request->per_page)->sortByDesc($request->sort_field);

Read more in the docs : https://laravel.com/docs/5.5/collections#method-sortby

edited Oct 06 '17 at 14:38

answered Oct 06 '17 at 14:31

teeyo

3,155
3
20
35

1

update -sortBy to ->sortBy otherwise the above throws an error – Geoff Oct 06 '17 at 14:38
1

Now it works thanks, but Ron answer above provides a cleaner syntax – Geoff Oct 06 '17 at 14:43
1

The most important that you got your answer, that's what SO is about ;) – teeyo Oct 06 '17 at 14:44

score 1 · Accepted Answer · answered Oct 06 '17 at 14:40

1

You could try something like

User::orderBy($request->sort_field, $request->sort_order)->paginate($request->per_page);

Source: https://laracasts.com/discuss/channels/laravel/combining-paginate-with-orderby

answered Oct 06 '17 at 14:40

Ron van der Heijden

13,198
7
52
79

score 0 · Answer 3 · answered Mar 10 '21 at 09:40

Using Eloquent you can sort and paginate your data quickly and easily.

For example, I want to sort all users that exist in the user table.

//---Sort Ascending
$users = User::orderBy('id', 'ASC')->Paginate(10);
//---Sort Descending
$users = User::orderBy('id', 'DESC')->Paginate(10);

Laravel sort by descending or ascending with pagination

3 Answers3