Laravel pagination relationship

Question

I asked to create a page that displays a list of all the categories and the last 3 products for each category.

There is a relationship between the category and the products.

I am trying to generate a route that will return a Json response.

Here is my code:

$category = Category::all()->load(["products"=>function($res){
            $res->take(3);
        }]);
        return $category->paginate(2);

But It returns an error:Collection::paginate does not exist.

What does it mean?

Thank you

Does this answer your question? [Laravel Method paginate does not exist](https://stackoverflow.com/questions/48148472/laravel-method-paginate-does-not-exist) — Manoj Salvi, Nov 29 '20 at 19:41
@RicardoJesusJarquinPerez thank you it's work! But now the Pagination meta data is missing from the output. — Jack, Nov 29 '20 at 20:26

Hafez Divandari · Answer 1 · 2020-11-30T17:40:27.523

1

all method returns collection instead of query builder instance. You may use with instead of load and use paginate to get the paginated result:

return Category::with(["products" => function($res) {
    $res->take(3);
}])->paginate(2);

Please note that according to Laravel docs:

The limit and take query builder methods may not be used when constraining eager loads.

edited Nov 30 '20 at 17:40

answered Nov 29 '20 at 20:29

Hafez Divandari

8,381
4
46
63

Thank you but it returns only the products that related to the first category – Jack Nov 29 '20 at 21:09
@Jack I added a note. – Hafez Divandari Nov 30 '20 at 17:40
@Jack you may use this workaround: https://stackoverflow.com/a/53022451/3477084 – Hafez Divandari Dec 01 '20 at 11:41

Laravel pagination relationship

1 Answers1