Can't read JSON array value with a "$" in the array name,

Question

I have a JSON-encoded array, but in one of the array values is a "$" in the array name. When I will read the value with the follow code below, didn't get I an value.

<?php
error_reporting("E_ERROR");
date_default_timezone_set("Europe/Amsterdam"); 
$json = file_get_contents('http://jotihunt.net/api/1.0/nieuws');
$json = json_decode($json, true);

foreach ($json as $key1 => $item) {
    foreach ($item as $key2 => $value) {

        $id = $item['$id'];

         echo gmdate("d-m-Y H:i", strtotime('+2 hours', $value['datum'])) . '&nbsp;' . $value['titel'] . ' met ID: '.$id.'<br/>';
    }
}
?>

Below the JSON array from $item

Array
(
    [0] => Array
        (
            [ID] => Array
                (
                    [$id] => 52532555a08789e17900000d /* Can't read this with $item[$id] because the "$" before "id" */
                )

            [titel] => API 1.0    /* $value['titel'] */
            [datum] => 1381180320 /* $value['datum'] */
        )

    [1] => Array
        (
            [ID] => Array
                (
                    [$id] => 524b16eaa08789806a000010
                )

            [titel] => Inschrijving gesloten
            [datum] => 1380652260
        )

Does anyone know how I can read $id?

becquerel · Accepted Answer · 2013-10-10 10:14:08Z

3

The $id item is contained in an ID item. Try:

$id = $item['ID']['$id'];

Edit: I am not sure why you have the nested loops. This should be enough:

foreach ($json as $key1 => $item) {
 $id = $item['ID']['$id'];
 echo gmdate("d-m-Y H:i", strtotime('+2 hours', $item['datum'])) . '&nbsp;' . $item['titel'] . ' met ID: '.$id.'<br/>';
}

edited Oct 10, 2013 at 10:14

answered Oct 10, 2013 at 9:39

becquerel

1,1317 silver badges11 bronze badges

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

2 Comments

AD7six Over a year ago

The suggested code uses $item['$id'] instead of $item['ID']['$id'] (i.e. it's inconsistent with "the answer").

Roy Boertien Over a year ago

Both solutions doens't work. With $id = $item['ID']['$id'], there is no output from $id With one loop doens't nothing work.

Marek · Accepted Answer · 2013-10-10 10:57:23Z

1

Use $item['ID']['$id']. If you find yourself using $item[ID], you use undefined constant ID.

Here is code that works:

$json = file_get_contents('http://jotihunt.net/api/1.0/nieuws');
$json = json_decode($json, true);

foreach ($json['data'] as $key1 => $item) {
  $id = $item['ID']['$id'];
  echo gmdate("d-m-Y H:i", strtotime('+2 hours', $item['datum'])) . '&nbsp;' . $item['titel'] . ' met ID: '.$id.  '<br />';
}

edited Oct 10, 2013 at 10:57

answered Oct 10, 2013 at 9:39

Marek

7,4431 gold badge24 silver badges34 bronze badges

6 Comments

Roy Boertien Over a year ago

Both doesn't work. No result :( Below a link to the live script: [link]hq.b10-ict.nl/jotihunt/nieuws.php En the source code [link]hq.b10-ict.nl/jotihunt/nieuws.phps

Marek Over a year ago

You have nested foreach, which is wrong. becquerel's code is close in that it removed the nested foreach, but it needs to use $id = $item['ID']['$id'];

Roy Boertien Over a year ago

I'm affraid that i don't understand what you did mean. I have now above code with one forech. But than there no output from $item['datum'],titel and $id. See also the above link to the script aggain.

Marek Over a year ago

Almost there. Replace $key1['datum'] with $item['datum']

Roy Boertien Over a year ago

My bad, i was experiment with variables. Both vars don't give a about

|

Collectives™ on Stack Overflow

Can't read JSON array value with a "$" in the array name,

2 Answers 2

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related