PHP array add Incremental

Question

I have an array, i get from database

*

Array
(
    [0] => Array
        (
            [year] => "2016"
            [numb] => 1
        )
    [1] => Array
        (
            [year] => "2016"
            [numb] => 3
        )
    [2] => Array
        (
            [year] => "2017"
            [numb] => 3
        )
    [3] => Array
        (
            [year] => "2016"
            [numb] => 1
        )
    [4] => Array
        (
            [year] => "2018"
            [numb] => 2
        )
)

*

I want the result array will be like this

Array
(
    [2016] => 5
    [2017] => 8
    [2018] => 10
)

This means: 2016 = 1 +3 + 1 = 5, 2017 = (year2016) + 3, 2018 = (year2016) + (year2017) + 2. But 2016 is not always the first year, it depends on the database

Please read about array and learn how to iterate them. That should be enough to solve the problem. — Tarun
– Tarun, Commented Oct 24, 2017 at 7:03
you might want to change your query to something which uses group by and sum methods — Abhishek Bhatia
– Abhishek Bhatia, Commented Oct 24, 2017 at 7:05

Taha Paksu · Accepted Answer · 2017-10-24 07:48:15Z

4

First method: use database query (the better and recommended way)

SELECT DISTINCT y1.year,
(SELECT sum(y2.numb) FROM nums y2 WHERE y2.year <= y1.year) AS numb_total
FROM nums y1

Fiddle: http://sqlfiddle.com/#!9/0c6ec5/12

Second method: use PHP methods

// create a container for the new array
$newArray = [];

// get the unique years from array
$years = array_unique(array_column($array, "year"));

// loop them
foreach($years as $year){

    // filter the array to match the years less or equal of the current year
    $year_filtered = array_filter($array, function($d)use($year){ return intval($d["year"]) <= intval($year);});

    // sum the numbers
    $total = array_sum(array_column($year_filtered, "numb"));

    // place the values in the new array
    $newArray[$year] = $total;
}

// echo the output (for debugging purposes)
print_r($newArray);

Fiddle: https://3v4l.org/UK9A8

edited Oct 24, 2017 at 7:48

answered Oct 24, 2017 at 7:05

Taha Paksu

15.6k2 gold badges50 silver badges83 bronze badges

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

2 Comments

Andreas Over a year ago

This doesn't either create the output wanted by OP.

Taha Paksu Over a year ago

@Andreas fixed both.

Umesh Maliya · Accepted Answer · 2017-10-24 07:06:15Z

2

$MyNewArray = array();
foreach($YourArray as $Row){
    $MyNewArray[$Row->year] = $MyNewArray[$Row->year]+$Row->numb;
}
print_r($MyNewArray);

answered Oct 24, 2017 at 7:06

Umesh Maliya

1557 bronze badges

1 Comment

Andreas Over a year ago

This does not create the output wanted by OP.

Andreas · Accepted Answer · 2017-10-24 07:19:49Z

0

I create a new array with key as year and value as numb.
Then sort the array on keys (year).
Then I sum the values in another loop.

There may be an easier way but this is what I could think of.

// create new array with year as key and numb as value
$res =array();
Foreach($arr as $val){
    If(!isset($res[$val["year"]])) $res[$val["year"]] =0;
    $res[$val["year"]] += $val["numb"];

}

ksort($res); // sort the array on keys to make earliest year first
$newarr= array();
$sum =0;
foreach($res as $key => $val){
    $newarr[$key] = $val+$sum; // new array with summed values from previous year(s)
    $sum +=$val;
}
Var_dump($newarr);

https://3v4l.org/5Ql2U

answered Oct 24, 2017 at 7:19

Andreas

24k7 gold badges34 silver badges75 bronze badges

Comments

Bharti · Accepted Answer · 2017-10-24 07:13:00Z

-1

$dbResult = array(array('year' => '2016', 'numb' => 1),  
                array('year' => '2016', 'numb' => 3), 
                array('year' => '2017', 'numb' => 3), 
                array('year' => '2016', 'numb' => 1), 
                array('year' => '2018', 'numb' => 2)); 

$result = array();
foreach ($dbResult as $data) {
    $result[$data['year']] = (isset($result[$data['year']])) ? $result[$data['year']] : 0;
    $result[$data['year']] = $result[$data['year']] + $data['numb'] ;
}
echo '<pre>';print_r($result);

answered Oct 24, 2017 at 7:13

Bharti

12 bronze badges

Collectives™ on Stack Overflow

PHP array add Incremental

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related