Get total number of results with pagination

Question

I'd like to get the total number of users on a page where all the users are listed. This page should be paginated.

So far, this is what I've come up with:

Controller

$users = User::paginate(10);
return View::make('index', compact('users'));

View:

{{{ count($users) }}}

But this gives me only the count of the users for the current page. I'd like to count the full result set, if possible without querying another time the database.

Is there a reason why you un-accepted my answer? If something is not working please tell me so I can help you :) — lukasgeiter, Feb 12 '15 at 07:29
Oh, sorry, I must have clicked the accept icon again on a non-refreshed page. It works great! — PeterInvincible, Feb 12 '15 at 11:03

score 126 · Accepted Answer · edited Jun 01 '21 at 10:16

126

In Laravel 4 use:

{{ $users->getTotal() }}

Docs

In Laravel 5 and above use:

{{ $users->total() }}

Docs

edited Jun 01 '21 at 10:16

mgraph

15,238
4
41
75

answered Feb 11 '15 at 23:09

lukasgeiter

147,337
26
332
270

Sunil kumawat · Answer 2 · 2019-04-27T11:40:54.303

8

Controller

$products = ProductMaster::paginate(10); //1 page with 10 products

return view('index',compact('products'));

view

 {{ $products->total() }}   //show total products in your database

edited Apr 27 '19 at 11:40

answered Jul 14 '17 at 16:36

Sunil kumawat

804
8
14

score 5 · Answer 3 · edited Jul 23 '20 at 06:38

5

To Get All Item Total

$paginator->total() Determine the total number of matching items in the data store. (Not available when using simplePaginate).

To Get Current Page Total

$paginator->count() Get the number of items for the current page.

Example

Controller

$users = User::paginate(10); //1 page with 10 products
return view('users', compact("users"));

View:

{{ $users->total() }} //show total users in your database

edited Jul 23 '20 at 06:38

THCBin

21
5

answered Jul 16 '20 at 17:57

Chetan

195
2
6

2

When adding an answer to a five year old question with an accepted answer it is important to point out what new aspect of the question your answer addresses. – Jason Aller Jul 16 '20 at 18:20

score 1 · Answer 4 · answered May 25 '23 at 04:35

    // Assuming you have a paginated collection named $users
$total = $users->total();
$currentPage = $users->currentPage();
$perPage = $users->perPage();

$from = ($currentPage - 1) * $perPage + 1;
$to = min($currentPage * $perPage, $total);

echo "Showing {$from} to {$to} of {$total} entries";

score 0 · Answer 5 · answered Apr 19 '21 at 22:34

On Laravel 8x this data is also returned in the response.

https://laravel.com/docs/8.x/pagination#introduction

The JSON from the paginator will include meta information such as total, current_page, last_page, and more. The result records are available via the data key in the JSON array. Here is an example of the JSON created by returning a paginator instance from a route:

{
   "total": 50,
   "per_page": 15,
   "current_page": 1,
   "last_page": 4,
   "first_page_url": "http://laravel.app?page=1",
   "last_page_url": "http://laravel.app?page=4",
   "next_page_url": "http://laravel.app?page=2",
   "prev_page_url": null,
   "path": "http://laravel.app",
   "from": 1,
   "to": 15,
   "data":[
        {
            // Record...
        },
        {
            // Record...
        }
   ]
}

score 0 · Answer 6 · answered Sep 06 '21 at 09:11

0

for total results {{ $results->total() }}

for the first item of current page {{ $results->firstItem() }}

for the last item of current page {{ $results->lastItem() }}

for current page {{ $results->currentPage() }}

answered Sep 06 '21 at 09:11

Junaid Masood

658
11
20

Get total number of results with pagination

6 Answers6