How can I display pagination in laravel?

Question

I use laravel 5.6

I try this documentation : https://laravel.com/docs/5.6/pagination

My controller like this :

public function index()
{
    $products = $this->product->list(); 
    dd($products);
    return view('admin.product.index',compact('products'));
}

My list function like this :

public function scopeList($query)
{
    return $query->orderBy('updated_at', 'desc')->paginate(20);
}

If I dd($products);, the result like this :

On the view laravel, I add this :

 {{ $products->links() }}

Then I check on the web, the result empty

Why the result empty?

Is there something wrong?

If the image not display, access here : https://postimg.org/image/w39usbfrv/

try changing `{{ $products->links() }}` to `{!! $products->render() !!}` as mentioned in my answer. — Option, Feb 21 '18 at 10:21
Are you running a foreach statement? Share the view file code. — Option, Feb 21 '18 at 10:22

score 7 · Answer 1 · answered Feb 21 '18 at 10:36

your controller code will look like this

$products = DB::table('products')->paginate(20);
return view('admin.product.index', ['products' => $products ]);

your view page code look like this

   @foreach ($products as $product)
         {{ $product->product_name}}
    @endforeach
    {{ $products->links() }}

Note : Add more items more than your limit to view pagination links

score 4 · Answer 2 · answered Feb 21 '18 at 10:45

In laravel pagination can be done using two method

1) Using Query Builder Results

$products= DB::table('products')->paginate(15);

or

$products= DB::table('products')->simplePaginate(15);

If you only need to display simple "Next" and "Previous" links in your pagination view, you may use the simplePaginate method.

2) Using Eloquent Results

$products= App\Products::paginate(15);

To print pagination links

{{ $products->links() }}

customize pagination view using

{{ $paginator->links('view.name') }}

or you can refer this link for more custom pagination view

Custom pagination view in Laravel 5

Is it possible to display the first page? – Angel Mar 01 '20 at 02:24 — Angel, Mar 01 '20 at 02:24

score 1 · Answer 3 · edited Feb 26 '18 at 20:07

1

Use paginate() function

App\Product::paginate();

or by query builder:

$products= DB::table('products')->paginate(15);

edited Feb 26 '18 at 20:07

marc_s

732,580
175
1,330
1,459

answered Feb 21 '18 at 10:12

Mahdi Younesi

6,889
2
20
51

I had it in method list. See my question. I had update it – moses toh Feb 21 '18 at 10:17
forget `$this->product->list();` do as my answer – Mahdi Younesi Feb 21 '18 at 10:20

score 1 · Answer 4 · answered Feb 21 '18 at 10:24

That's because, you are paginiating for 20 products and you have only 11 products. That is why pagination will only come only if there are more then the number of products you are requesting .. For you u have one page and 11 products. Look at the top #total:11 , lastpage:1 that's why empty pagination , because there is nothing to paginate.

How can I display pagination in laravel?

4 Answers4

Linked