Quick question on pagination with laravel 5.5

when you convert the record to json you will see

{
   "total": 50, // all num
   "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":[]
}

to get total use $result->total();

more information https://laravel.com/docs/5.5/pagination#paginator-instance-methods

Thanks Muntadher

The 'length-aware' paginator will count all matching records so that it can show the number of pages and display the appropriate links.

Because this may not be appropriate in all cases, there is also a 'simple' paginator which just does a simpler query and only allows a next and previous link.

https://laravel.com/docs/5.5/pagination#basic-usage

@Boubou see this https://laracasts.com/discuss/channels/guides/length-aware-paginator

Skip and take and a pre count make the Lengthaware paginator very efficient.

Eager load just means load when needed, i.e., You have a company and want to list their accounts receivables.

That orm breaks down very fast if in a nested foreach the inner foreach has thousands of results. But it is fine for small results.

Boss wants to view report, I would have a paginator kind of in a paginator. I.e., where inner foreach has a whole lot of results.

This is something you will never see in a video, I promise. WHY -- Large enterprise don't use active record on large database results, it breaks..

Thank you both for your replies. I did not know about active records not being a good choice for large enterprises.