Extract specific values from JSON Array php

Question

I have a JSON Array

    [0] => Array
    (   
        [stage_id] => 80    
        [yieldVal] => Array
            (
                [0] => Array
                    (
                        [datajson] => [{"name":"doi","value":"215"},{"name":"dateofpollinationstops","value":"Date of Pollination Stops~23-3-2015"}]
                    )

                [1] => Array
                    (
                        [datajson] => [{"name":"doi","value":"698"},{"name":"dateofpollinationstops","value":"Date of Pollination Stops~23-3-2015"}]
                    )
            )
    )

I need to extract the values from this Array

    [0] => Array
    (   
        [stage_id] => 80    
        [yieldVal] => Array
            (
                [doi_value] => 215  
                [doi_value] => 698  
            )
    )

I have tried decoding the JSON. But unable to continue further.

$phpArray = json_decode($res['datajson'], true);

How to extract the values and assign the key.

EDIT : My final output should be

[0] => Array
    (   
        [stage_id] => 80    
        [yieldVal] => 913  //215+698  -> Extracting values from [datajson]
    )

You can't have multiple elements with the same key doi_value in an array. — Barmar
– Barmar, Commented Mar 27, 2015 at 10:58
So you don't want an array in the resulting yieldVal? Please update the question to show what you really want. — Barmar
– Barmar, Commented Mar 27, 2015 at 11:02

beingalex · Accepted Answer · 2015-03-27 11:48:22Z

1

One thing that may of tripped you up is that your datajson string is:

`[{"name":"doi","value":"215"},{"name":"dateofpollinationstops","value":"Date of Pollination Stops~23-3-2015"}]`

The square brackets mean that json_decode will create an array from the objects.

Anyway, try this...should give you the exact output you asked for:

$yieldVal = 0;

foreach ($res['yieldVal'] as $key => $arr) {

    $decode = json_decode($arr['datajson']);
    $yieldVal = $yieldVal + $decode[0]->value;

}

$newArray = array (

    'stage_id' => $res['stage_id'],
    'yieldVal' => $yieldVal

);

//var_dump($newArray);
echo "<pre>".print_r($newArray, true)."</pre>";

edited Mar 27, 2015 at 11:48

answered Mar 27, 2015 at 11:38

beingalex

2,4865 gold badges33 silver badges72 bronze badges

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

Comments

Barmar · Accepted Answer · 2015-03-27 11:03:49Z

1

You should be able to get the value with:

$doi_value = $phpArray[0]['value'];

You can then sum them, push them onto a resulting array, or whatever.

answered Mar 27, 2015 at 11:03

Barmar

789k57 gold badges555 silver badges669 bronze badges

Collectives™ on Stack Overflow

Extract specific values from JSON Array php

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