How to use multiple arguments when querying Laravel Eloquent results

Question

I am querying DB posts via a Laravel eloquent controller and would like to first filter the posts and then paginate.

$filter = ['author_id' => $id, 'status' => 'live', 'type' => $type];
$posts = Post::where($filter)->orderBy('id','desc')->get();
$posts = Post::paginate(1, ['*'], 'page', $page);

return $posts;

Of course currently it is only going to paginate. How can I combine both $posts so that the filtered results are paginated?

Thanks!

Seva Kalashnikov · Accepted Answer · 2018-10-30 21:19:01Z

2

As simple as just chain those methods like:

$posts = Post::where($filter)
    ->orderBy('id','desc')
    ->paginate(1, ['*'], 'page', $page);

answered Oct 30, 2018 at 21:19

Seva Kalashnikov

4,4322 gold badges26 silver badges36 bronze badges

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

1 Comment

scopeak Over a year ago

Excellent! Makes sense now - thought the :: was required for each.

Jesus Erwin Suarez · Accepted Answer · 2018-10-30 22:30:41Z

0

You can also simplify the solution like this and this will become more flexible.

$filter = ['author_id' => $id, 'status' => 'live', 'type' => $type];

$posts = new Post();
$posts = $posts->where($filter);
$posts = $posts->orderBy('id','desc');
$posts = $posts->paginate(1, ['*'], 'page', $page);

return $posts;

answered Oct 30, 2018 at 22:30

Jesus Erwin Suarez

1,59517 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to use multiple arguments when querying Laravel Eloquent results

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related