Question 17604 in Laravel Question posted in
The official Laravel Documentation can be found here.

how to loop through table in laravel calculate sum of a column

How do i calculate the totals of all values of a column amount after fetching it in laravel controller. table collections has only amount and id column and i want to determine the totals.

Tags:

2

Answers


  1. 0

    You can do the following:

    $total = 0;
$amounts = Collections::all()->pluck('amount');
foreach($amounts as $amount){
  $total += $amount;
}
    Login or Signup to reply.
  2. 0

    You can use sum from eloquent:

    $amount = Collections::sum('amount');
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search