PHP: get value from JSON String?

Question

I have a string that looks like this:

[
   {
      "id":"2",
      "price":"39.99",
      "timeStamp":"1506264307167",
      "quantity":"1",
      "colours":"Green",
      "pid":"234234234"
   },
   {
      "id":"2",
      "price":"39.99",
      "timeStamp":"1506264311757",
      "quantity":"1",
      "colours":"Blue",
      "pid":"234234234"
   }
]

I need to get the id from this JSON string using PHP.

So I tried this:

$details = '[
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264307167",
          "quantity":"1",
          "colours":"Green",
          "pid":"234234234"
       },
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264311757",
          "quantity":"1",
          "colours":"Blue",
          "pid":"234234234"
       }
    ]';

$details = json_encode($details, true);

$array = json_decode($details, true);
$oid = $array['id'];


echo $oid;

The code above is in a while loop so the echo $oid should echo the id multiple times.

anyway, the code above only prints this:

[
[

and when i look in the error log, i see this error:

PHP Warning:  Illegal string offset 'id'

Could someone please advice on this issue?

Thanks in advance.

@JohnConde, i thought that is whats needed to be able to get the value of id? — David Hope, Sep 25 '17 at 12:25
If it is already `json` then common sense dictates that you don't need to convert it into `json` — ProEvilz, Sep 25 '17 at 12:26

score 2 · Accepted Answer · answered Sep 25 '17 at 12:31

<?php
$details = '[
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264307167",
          "quantity":"1",
          "colours":"Green",
          "pid":"234234234"
       },
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264311757",
          "quantity":"1",
          "colours":"Blue",
          "pid":"234234234"
       }
    ]';


$array = json_decode($details, true);

for($i=0;$i<count($array);$i++){
    $idValue = $array[$i]['id'];
    echo $idValue;
}

You need a loop to go through all the nested arrays and get all the ids.

Just for knowledge sake, since `foreach()` take care of indexes itself so prefer it over to `for()` as much as possible. — Alive to die - Anant, Sep 26 '17 at 04:14

mega6382 · Answer 2 · 2017-09-25T12:27:32.617

Try the following code:

<?php
$details = '[
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264307167",
          "quantity":"1",
          "colours":"Green",
          "pid":"234234234"
       },
       {
          "id":"2",
          "price":"39.99",
          "timeStamp":"1506264311757",
          "quantity":"1",
          "colours":"Blue",
          "pid":"234234234"
       }
    ]';


$array = json_decode($details, true);
$oid = $array[0]['id'];


echo $oid;

Instead of encoding json string into json. Decode it to PHP array directly. And use [0] index to get first Json Object

PHP: get value from JSON String?

2 Answers2