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 13 Eloquent: Expert Level
41 lessons
1 h 34 min
[FREE] Laravel 13 for Beginners: 3 Demo Projects
5 lessons
29 min
NativePHP v3: Create Mobile Apps with Laravel
10 lessons
1 h 02 min