How to sum over multiple fields in an array

Question

i have a charges model that contain Price And Quantity , i want to multiply Price and Quantity and sum the results and update a table named bill with final results , here is my array

 [
  [
    "Title" => "Price 1",
    "Quantity" => "1",
    "Price" => "1",
  ],
  [
    "Title" => "Price 2",
    "Quantity" => "232",
    "Price" => "32632",
  ],
  [
    "Title" => "Price 3",
    "Quantity" => "11",
    "Price" => "2115",
  ],
]

And what is your problem exactly? Have you tried doing it "manually" by iterating over this array? I am not sure where your problem begins. — matiit
– matiit, Commented Oct 18, 2016 at 13:14
i dont know ho to it , to explain the problem i have a dinamic form with multiple fields , and t store the fields in an $charges array wich i need to multiply the price and quantity in order to update bill table — Ahmed Imad Touil
– Ahmed Imad Touil, Commented Oct 18, 2016 at 13:16

Armin Sam · Accepted Answer · 2016-10-18 13:41:29Z

1

Assuming that $billItems is your initial array, you can do this in one line:

$grandTotal = array_sum(array_map(function($item) { return $item['Quantity'] * $item['Price']; }, $billItems));

answered Oct 18, 2016 at 13:41

Armin Sam

9339 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jarek · Accepted Answer · 2016-10-18 15:24:14Z

1

You can use collections like this

$collection->sum('Price');

or

$yourArray = [
        [
            "Title" => "Price 1",
            "Quantity" => "1",
            "Price" => "1",
        ],
        [
            "Title" => "Price 2",
            "Quantity" => "232",
            "Price" => "32632",
        ],
        [
            "Title" => "Price 3",
            "Quantity" => "11",
            "Price" => "2115",
        ]
    ];  

$collection = collect($yourArray);

$payment = $collection->sum(function ($item) {
    $item['Price'] = $item['Price'] * $item['Quantity'];
    return $item['Price'];
});

dd($payment); // 7593890

more https://laravel.com/docs/5.3/collections#method-sum

edited Oct 18, 2016 at 15:24

answered Oct 18, 2016 at 13:20

Jarek

3042 silver badges5 bronze badges

5 Comments

Ahmed Imad Touil Over a year ago

how to multiply Price And Quantity before using sum

Ahmed Imad Touil Over a year ago

$addition = $addition ->each(function ($item, $key) { // add new property $item['val'] = price * qty });

Ahmed Imad Touil Over a year ago

$add = $add ->each(function ($item, $key) { // add new property $item['val'] = price * qty }); $collection->sum($add ); like that ?

Jarek Over a year ago

Should return 7593890 ( (1*1)+(232*32632)+(11*2115) )

Jarek Over a year ago

Do You try it? ;-)

Collectives™ on Stack Overflow

How to sum over multiple fields in an array

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related