Json decode in php basics

Question

I'm trying to learn json in php. Here's my json result from a ElasticSearch query.

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "failed" : 0
  },
  "hits" : {
    "total" : 1,
    "max_score" : null,
    "hits" : [ {
      "_index" : "xenforo",
      "_type" : "post",
      "_id" : "1816069",
      "_score" : null,
      "sort" : [ 1365037907 ]
    } ]
  }
}

I assume that my php code will look something like this:

$myData = json_decode($result);

foreach($myData->hits as $var) {
   $post_id[] = $var->_id;
}

Been looking for the answer for hours, I sure do appreciate any help. Thank you.

Edit: Here is the answer:

foreach($myData->hits->hits as $var) {
   $post_id[] = $var->_id;
}

See array.include-once.org on how to traverse data structures in PHP. Only ->hits->hits is meant to be iterated over. — mario
– mario, Commented Apr 13, 2013 at 20:47
yes please explain the question, what are you trying to accomplish with the JSON object? — 1337holiday
– 1337holiday, Commented Apr 13, 2013 at 20:50
I would like to populate the $post_id array with the _id in the json output. So in this case $post_id[0] should equal 1816069. — Andy Bajka
– Andy Bajka, Commented Apr 13, 2013 at 20:52
your current JSON object only shows one _id parameter but it seems what you are asking involves getting multiple _id so can you modify your JSON so that it shows how the structure will look with multiple _ids? — 1337holiday
– 1337holiday, Commented Apr 13, 2013 at 20:56

Phill Sparks · Accepted Answer · 2013-04-13 20:57:36Z

3

You're one ->hits short if you look at your JSON structure...

{
    "hits" : {
        "hits" : [ {
            "_id" : "1816069",

$myData = json_decode($result);

foreach($myData->hits->hits as $hit) {
    $post_id[] = $hit->_id;
}

answered Apr 13, 2013 at 20:57

Phill Sparks

21k3 gold badges36 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Json decode in php basics

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related