Laravel 4 Binding paginated

Question

Laravel 4 Binding paginated

I am trying to display a list of products with matching categories using the following in my controller:

return View::make('products.index')
->with('categories', Categories::with('products')->orderBy('name', 'asc')->Paginate(15))

But pagination doesn't work, it displays all products (500+), while I only want to show 15 on each page. Here are my models:

Categories:

public function products()
{
    return $this->belongsToMany('Products');
}

Products:

public function categories()
{
    return $this->belongsToMany('Categories');
}

How can I make pagination work?

+3

pagination laravel-4

Hardist 05 Aug '15 at 9:10

source to share

1 answer

aldrin27 · Accepted Answer · 2015-08-05T09:33:01+0000

Try the following:

$categories = Categories::with(array('products' => function($query)
{
   $query->orderBy('name', 'asc');

 }))->paginate(15);

 return View::make('products.index', compact('categories'));

Hope this helps you. Here's a link to actively download.

Laravel 4 Binding paginated

More articles: