How to calculate the sum of all records when you have only the PAGINATED collection? Do the calculation BEFORE the pagination, but from the same query.
// How to get sum of post_views with pagination?$posts = Post::paginate(10);// This will be only for page 1, not ALL posts$sum = $posts->sum('post_views'); // Do this with Query Builder$query = Post::query();// Calculate sum$sum = $query->sum('post_views');// And then do the pagination from the same query$posts = $query->paginate(10);
Enjoyed This Tip?
Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.
Recent Courses
Laravel Modules and DDD
16 lessons
1 h 59 min
How to Build Laravel 12 API From Scratch
28 lessons
1 h 21 min
Laravel HTTP Client and 3rd-Party APIs
7 lessons
50 min