Laravel lazy eager loading with pagination

Hi I have two models , Tag and Post and many to many relation between them . I want to show and also paginate posts with specific tag . what is the best practice for this situation . I used the function but not work :

        public function getPosts($tagId,$rowsCount)
    {
                return App\Models\Tag::where('id',$tagId)->with(['posts' => function($q) use ($rowsCount){
                  $q->paginate($rowsCount);
                 }])->get();
     }

willvincent

9 years ago

Best Answer

Level 54

Try this instead:

public function getPosts($tagId, $rowsCount) {
  return Post::whereHas('tags', function ($q) use ($tagId) {
             $q->where('id', $tagId);
           })
           ->with('tags')
           ->paginate($rowsCount);
}

1 like

Mohsen

9 years ago

Level 1

thank you very much for your help ....

Please or to participate in this conversation.