Extract values from multidimensional array using key value

Question

I wonder if someone can help me extract values from an array by key value rather than array number.

$json = json_decode($stock, true);
print_r($json);
$sims = $json['stock'][1]['sims'];

foreach ($sims as $sim)
{
    echo nl2br($sim . "\n");
}

The output from print_r($json) is:

Array ( [stock] => Array (
[0] => Array
( [operator] => ECL [sims] => Array
( [0] => 8944122616994 [1] => 89650264517182 [2] => 894412265075 [3] => 894412 ) )
[1] => Array
( [operator] => JT [sims] => Array
( [0] => 89445023065 [1] => 894156673081 [2] => 8944501 [3] => 89445027 ) ) ) )

It appears that sometimes the data I want is not in array number 1 hence I would like to extract it based on "[operator] => JT" I've been trying various ideas but it never seems to work.

This is a bit unclear - what is the output you're trying to get? — Ben
– Ben, Commented Feb 12, 2016 at 15:49
Could you maybe give us your JSON string and a clear example of what you're trying to extract from it? — Rein
– Rein, Commented Feb 12, 2016 at 15:51
Whoever downvoted its a very good question. Please add your comment — Nabin Kunwar
– Nabin Kunwar, Commented Feb 12, 2016 at 17:10

Ben · Accepted Answer · 2016-02-12 16:03:21Z

4

You can accomplice it by using array_search and array_column

This will give you the multidimensional array key

$key = array_search("JT", array_column($json['stock'], 'operator'));

Then you can do

$sims = $json['stock'][$key]['sims'];
print_r($sims) //this will print desired array

edited Feb 12, 2016 at 16:03

Ben

8,9519 gold badges48 silver badges82 bronze badges

answered Feb 12, 2016 at 15:54

Nabin Kunwar

1,98414 silver badges29 bronze badges

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

Comments

Ben · Accepted Answer · 2016-02-12 15:52:47Z

0

Try:

$json = json_decode($stock, true);

foreach($json["stock"] as $arr){
    echo $arr["operator"]."\n";
    foreach($arr["sims"] as $sim){
        echo $sim."\n";
    }
    echo "\n";
}

This would output (for example):

ECL
8944122616994
89650264517182
894412265075
894412

JT
89445023065
894156673081
8944501
89445027

answered Feb 12, 2016 at 15:52

Ben

8,9519 gold badges48 silver badges82 bronze badges

Comments

Tobias Xy · Accepted Answer · 2016-02-12 15:53:48Z

0

Write a function like this:

function getSims(array $array) {
    $sims = [];

    foreach ($array as $data) {
        if ($data['operator'] == 'JT') {
            return $data['sims'];
        }
    }
    // here you could also throw an exception or return something else
    return [];
}

and use it like this:

$json = json_decode($stock, true);
$sims = getSims($json['stock']);

answered Feb 12, 2016 at 15:53

Tobias Xy

2,07918 silver badges19 bronze badges

Collectives™ on Stack Overflow

Extract values from multidimensional array using key value

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