get index of json key using php

Question

I want to find index of key from json array similar to this question Get index of a key in json but i need the solution using php.

here is my json (partial data)

{   
"currentOver":{
    "events":[]
},  
"matchString":"",
"currentPlayer":5, 
"previousOvers":[], 
"innings":[],   
"scorecards":[
    {
        "batting":{
            "players":[
                        {"id":16447,"name":"Rahul Roy"},
                        {"id":12633,"name":"Sijal Thomas"},
                        {"id":16446,"name":"Mohammed Reza"},
                        {"id":16509,"name":"Asif Khan"},
                        {"id":12633,"name":"Koyel Dijesh"},
                        {"id":16468,"name":"Shahrook"},
                        {"id":64691,"name":"Shafiq"},
                        {"id":6518,"name":"Ubaidulah"}
            ]
        }
    }
]

}

and php

foreach ($read_json->scorecards->batting->players as $batsmen => $val) {    
                if($val == 5) {   // if batsman index is 5 then display his name
                    $name = $batsmen->name;

                    echo "<div>$name</div>\n"; 

                }               
}

Please help me to solve this issue.Thanks in advance.

And where is the problem? Where are you stuck with which code? — Rizier123
– Rizier123, Commented Jun 7, 2016 at 9:38
change this javascript to php function getObjectKeyIndex(obj, keyToFind) { var i = 0, key; for (key in obj) { if (key == keyToFind) { return i; } i++; } return null; } — user4796879
– user4796879, Commented Jun 7, 2016 at 9:39

BlackBurn027 · Accepted Answer · 2016-06-11 06:47:02Z

8

+50

I think this would suffice your requirement

http://codepad.org/XQDCKAsB

Find the code sample below as well.

       $json  = '{"currentOver":{"events": []},"matchString":"","currentPlayer":5,"previousOvers":[],"innings":[],"scorecards":[{"batting":{"players":[{"id":16447,"name":"Rahul Roy"},{"id":12633,"name":"Sijal Thomas"},{"id":16446,"name":"Mohammed Reza"},{"id":16509,"name":"Asif Khan"},{"id":12633,"name":"Koyel Dijesh"},{"id":16468,"name":"Shahrook"},{"id":64691,"name":"Shafiq"},{"id":6518,"name":"Ubaidulah"}]}}]}';

       $arr = json_decode($json);

       echo '<pre>';

       $currentPlayer = $arr->currentPlayer;

       echo $arr->scorecards[0]->batting->players[$currentPlayer-1]->name;

answered Jun 11, 2016 at 6:47

BlackBurn027

6425 silver badges20 bronze badges

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

1 Comment

BlackBurn027 Over a year ago

and yes as @Andrew said make sure you decrement the current player value to get the index right ;)

Andrew · Accepted Answer · 2016-06-11 06:48:15Z

3

Try this code.

$info = json_decode('json string');
$currentPlayer = $info->currentPlayer;
$batsman = $info->scorecards[0]->batting->players[$currentPlayer];
echo "<div>{$batsman->name}</div>\n";

Also, note that arrays in PHP are zero-based. If currentPlayer index in json data is based on 1 (rare case, but it exists sometimes) you will ned to use

$batsman = $info->scorecards[0]->batting->players[$currentPlayer - 1];

to get right item from array.

answered Jun 11, 2016 at 6:48

Andrew

1,86615 silver badges15 bronze badges

1 Comment

Dil Dilshan Over a year ago

FYI, ($currentPlayer - 1) not required for my case $currentPlayer works

Shadi · Accepted Answer · 2016-06-11 06:50:34Z

3

If you just want to fix your foreach

$read_json->scorecards->batting should become $read_json->scorecards[0]->batting
if($val == 5) should become if($batsmen == 5)
$name = $batsmen->name; should become $name = $val->name;

answered Jun 11, 2016 at 6:50

Shadi

10.4k5 gold badges49 silver badges73 bronze badges

1 Comment

Shadi Over a year ago

I see. But it still says below your question that the bounty is still open. You need to click on the bounty award icon next to your selected answer, as it says here

user6364857 · Accepted Answer · 2016-06-07 09:43:34Z

2

You need to use json_decode and array_keys for the array keys from the json.

$json = '{ "key1" : "watevr1", "key2" : "watevr2", "key3" : "watevr3" }';
$result = json_decode ($json, true);
$keys = array_keys($result);
print_r($keys); //Array ( [0] => key1 [1] => key2 [2] => key3 )

answered Jun 7, 2016 at 9:43

user6364857

11 Comments

Dil Dilshan Over a year ago

only count from first line till the end.

user6364857 Over a year ago

Your partial json is not valid.

Dil Dilshan Over a year ago

json is only for reference. it is valid json

Dil Dilshan Over a year ago

in other words how can i display only the 5th line

user6364857 Over a year ago

please, run your json here, and if works then let me do what you want?

|

Green Harry · Accepted Answer · 2016-06-17 10:32:08Z

2

In Php, You can use the code below, if you wan to fix it using foreach loop

foreach($json->entries as $row)

{

    foreach($row as $key => $val)
    {
        echo $key . ': ' . $val;
        echo '<br>';
    }

}

answered Jun 17, 2016 at 10:32

Green Harry

1112 silver badges5 bronze badges

Comments

piyushiiitm · Accepted Answer · 2016-06-18 04:41:36Z

1

please have a look following code

$json=json_decode($data)->scorecards[0]->batting->players;
foreach ($json as $key => $value) {
  if($key==5){
    echo $value->name ;
  }
}

answered Jun 18, 2016 at 4:41

piyushiiitm

253 bronze badges

Comments

Jaydp · Accepted Answer · 2016-06-18 05:14:54Z

You can do it using converting JSON string to Array

$json_str = '{   
"currentOver":{
    "events":[]
},  
"matchString":"",
"currentPlayer":5, 
"previousOvers":[], 
"innings":[],   
"scorecards":[
    {
        "batting":{
            "players":[
                        {"id":16447,"name":"Rahul Roy"},
                        {"id":12633,"name":"Sijal Thomas"},
                        {"id":16446,"name":"Mohammed Reza"},
                        {"id":16509,"name":"Asif Khan"},
                        {"id":12633,"name":"Koyel Dijesh"},
                        {"id":16468,"name":"Shahrook"},
                        {"id":64691,"name":"Shafiq"},
                        {"id":6518,"name":"Ubaidulah"}
            ]
        }
    }
]

}';

Decode your JSON string using "json_decode" and you get array

$json_decode_str = json_decode($json_str, true);

Now using foreach you can do anything

if($json_decode_str['scorecards']){

    foreach($json_decode_str['scorecards'] as $scorecard){

        $player_index = 1;
        if($scorecard['batting']['players']){

            foreach($scorecard['batting']['players'] as $player){

                if($player_index == 5){
                    echo $player['name'];
                }

                $player_index++;
            }

        }

    }

}

Maybe this one help you :)

Collectives™ on Stack Overflow

get index of json key using php

7 Answers 7

1 Comment

1 Comment

1 Comment

11 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

1 Comment

1 Comment

11 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related