add values of array in php

Question

Hi i know its very simple but im stuck in this. Im fetching data by using join from database.. Now i got the values in array. i want to add these two value in a variable. Code is below..

$sql = "SELECT event_details.max_team_size FROM booking_details INNER JOIN event_details on booking_details.subcategory_id=event_details.id WHERE booking_details.`booking_id` = ".$booking_id." ";

        $command = Yii::$app->db->createCommand($sql);
        $array = $command->queryAll();

$array has got the values like this..

Array
(
[0] => Array
    (
        [max_team_size] => 6
    )

[1] => Array
    (
        [max_team_size] => 8
    )
 )

I want to add these two max_team_size into a single variable and use that later to compare.

@urfusion sum of these two max_team_size values.. like 6+8= 14 in a $total. — Salman Riyaz
– Salman Riyaz, Commented Oct 13, 2017 at 7:01

urfusion · Accepted Answer · 2017-10-13 07:02:03Z

2

$sum = 0;
foreach($array as $data){
    $sum  += $data->max_team_size;
}
echo $sum;

answered Oct 13, 2017 at 7:02

urfusion

5,4995 gold badges56 silver badges91 bronze badges

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

Comments

Chetan Ameta · Accepted Answer · 2017-10-13 07:12:08Z

1

Sum you can get from SQL also by using SUM function

SELECT SUM(event_details.max_team_size) FROM booking_details...

In Yii the solution will be

$sql = "SELECT SUM(event_details.max_team_size) as total FROM booking_details INNER JOIN event_details on booking_details.subcategory_id=event_details.id WHERE booking_details.`booking_id` = ".$booking_id." ";
$command = Yii::$app->db->createCommand($sql);
$array = $command->queryRow();

In PHP to sum particular key in single array you can convert it to single array by using array_column function and then use sum function

$array = array_column($array, 'max_team_size');
$total = array_sum($array);

Note: array_column will work PHP >= 5.5, for PHP < 5.5 you can use foreach loop

edited Oct 13, 2017 at 7:12

answered Oct 13, 2017 at 7:02

Chetan Ameta

7,8943 gold badges34 silver badges46 bronze badges

Comments

Izuka · Accepted Answer · 2017-10-13 07:03:49Z

0

Define an empty array like this:

$maxArr = array();

You can run a foreach loop for your array now and add variable. Like this:

foreach($gotArr as $key=>$val){

}

edited Oct 13, 2017 at 7:03

Izuka

2,5925 gold badges33 silver badges37 bronze badges

answered Oct 13, 2017 at 6:59

Er Amit Anand

501 silver badge7 bronze badges

Collectives™ on Stack Overflow

add values of array in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related