PHP - Incrementally add array value

Question

Basically I have this from a query:

Array
(
[0] => Array
    (
        [period] => 2014-03
        [val] => 2.19
        [type] => TypeX
    ),
[1] => Array
    (
        [period] => 2014-03
        [val] => 2.02
        [type] => TypeY
    )
)

Using a foreach loop to populate another array we will call DATA, I want the to get the following:

Array
(
[TypeX] => Array
    (
        [2014-03] => 2.19
    )
[TypeY] => Array
    (
        [2014-03] => 2.02
    )
 )

The whole thing is looped because my query needs to run each time for a different period. Current exemple, second loop would run for 2014-04. My problem is when I arrive for the 2nd time at my DATA array, I want this:

Array
(
[TypeX] => Array
    (
        [2014-03] => 2.19
        [2014-04] => 1.10

    )
[TypeY] => Array
    (
        [2014-03] => 2.02
        [2014-04] => 4.74
    )
)

My code is roughly like this:

$data = array();
foreach($graph_period as $period){
$rows = Queryfunction($period,$WHERE,$byType);
        foreach($rows as $row){
            $data[$row['type']] = array($row['period']=>$row['val']);
        }
}

Because the key of the first level (TypeX, TypeY) are the same, the valei is overwritten. How am I to append the array instead of overwriting ?

You can probably get the SQL server to do all this for you without having to resort to juggling all the data in PHP. Look up aggregate functions. — GordonM
– GordonM, Commented Mar 5, 2015 at 17:02

zim32 · Accepted Answer · 2015-03-05 17:05:36Z

1

foreach($rows as $row){
    $data[$row['type']][$row['period']] = $row['val']);
}

answered Mar 5, 2015 at 17:05

zim32

2,6491 gold badge25 silver badges32 bronze badges

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

Comments

Leandro Papasidero · Accepted Answer · 2015-03-05 17:11:46Z

0

You only need to change a tiny bit. Inside the foreach where you set the value:

if( !isset($date[$row['type']]) ) {
  $data[$row['type']] = array();
}

$data[$row['type']][$row['period']] = $row['val'];

So, you create the array only if it does not exist.

edited Mar 5, 2015 at 17:11

Leandro Papasidero

3,7381 gold badge20 silver badges33 bronze badges

answered Mar 5, 2015 at 17:03

kainaw

4,3621 gold badge23 silver badges38 bronze badges

Collectives™ on Stack Overflow

PHP - Incrementally add array value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related