Level 75
$paginator->total() is not available when usingsimplePaginate. So only options is
$totalCount = ModelName::count();
Jul 29, 2021
13
Level 1
How to get total rows count in laravel with simplePagination()
How can I get total rows count with simplePagination() in Laravel?
paginate() runs two quires and both takes separate time to execute that I don't want.
Is there any other way to get total rows count in pagination ?
Level 1
it will return all rows not filtered. There is a filter before pagination which will obviously reduce rows
Level 75
Just use same filters
$totalCount = ModelName::where('foo', 'bar')->count();
Level 1
it will return the total rows of first page/offset. for example if i do simpePaginate(10) it will return 10 or less to total from filtered results
Level 75
No... it returns count of filtered rows.
Level 1
but for each page. for example if i uses simplePaginate(10), it will show 10 on each page not total of filterd results
Level 75
Yes and what is the problem?
Level 1
i want to show total rows of filtered results as the same thing we can achieve with paginate() like $users->total() this total() function is available for paginate not simplePaginate() and i need simplePaginate()
Level 75
In my first reply is the solution...
Level 1
sorry this is not the answer. it is returning all from from table not filtered rows
Level 75
Have a nice day.
Level 75
Why don't you use regular paginate with a custom template. Fairly straight forward to do, but if you need an example, I will post.
But the above answer should work.
2 likes
Level 1
already explained in my question. there is time issue. paginate() runs two queries and each take separate time (200ms each) and i want to save time as i can. if there is no solution, then I will obviously go with paginate()
Please or to participate in this conversation.