Decoding JSON array

Question

I'm struggling to parse a simple JSON array, am new to this so trying to learn.

Here's the data:

{"data":[
  {"name":"john","id":"123"},
  {"name":"dave","id":"345"}
  ], "other":
  {"foo":"bar"}
}

I only want the data information.

Here's what I'm trying (also what else I tried):

$list = json_decode(file_get_contents($jsonURL),true);

foreach ($list as $element){

  //$id = $element->data->id; // this didn't work either
  //$name = $element->data->name; // this didn't work either

  $id = $element[data][id];
  $name = $element[data][name];

  $message .= $id.' - '.$name.'</br>';

}

Any ideas why it returns nothing?

morissette · Accepted Answer · 2014-10-27 20:43:10Z

4

$json = '{"data":[
  {"name":"john","id":"123"},
    {"name":"dave","id":"345"}
      ], "other":
        {"foo":"bar"}
}';

$list = json_decode($json,true);
foreach ( $list['data'] as $item ) {
    echo $item['id'] . "\n";
    echo $item['name'] ."\n\n";
}

Here is a perfect example of how to work with that data.

answered Oct 27, 2014 at 20:43

morissette

1,1092 gold badges8 silver badges29 bronze badges

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

Comments

Aleksey Linetskiy · Accepted Answer · 2014-10-27 20:45:27Z

0

First of all, you have errors in your code. Use strings to access members of the $element: $element['data']. Then, I would think that the entire data structure will be the first element of the list, so you can access it like this:

$list = json_decode(file_get_contents($jsonURL),true);
$data = $list['data'];

$id = $data['id'];
$name = $data['name'];

$message .= $id.' - '.$name.'</br>';

answered Oct 27, 2014 at 20:45

Aleksey Linetskiy

4733 silver badges10 bronze badges

Comments

worldofjr · Accepted Answer · 2014-10-27 20:54:52Z

0

I'm surprised that everyone is telling you to access the data using arrays. JSON is a object based system, and you should access the data with the object notation. The problem was you were attempting to traverse the main object, not the data part of it.

You should do the following instead;

$list = json_decode(file_get_contents($jsonURL),true);
$data = $list->data;

foreach ($data as $element) {
    $id = $element->id;
    $name = $element->name;

    $message .= $id.' - '.$name.'</br>';
}

Hope this helps.

answered Oct 27, 2014 at 20:54

worldofjr

3,8968 gold badges41 silver badges53 bronze badges

Collectives™ on Stack Overflow

Decoding JSON array

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