Parsing a JSON array of arrays using PHP

Question

I know this is rather simple but I'm stuck at it and I'd really like some help

Here's a JSON string I'm generating.

[{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}]

How do I extract the value associated with field1?

And how do I access elements of each of the distinct arrays?

you'll have to parse the string into an array structure your programming language understands. Which language is that? (javascript, php, ...) — giorgio, Oct 01 '13 at 13:15
Your question is not answerable if you don't tell us which programming language you are using. — Felix Kling, Oct 01 '13 at 13:20

score 4 · Accepted Answer · answered Oct 01 '13 at 13:30

try this code

$jsonString = '[{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}]';

$json = json_decode($jsonString, true);

print_r($json);

Anand Jha · Answer 2 · 2013-10-01T13:29:28.650

2

Try this (in Javascript)

var jsonData=[{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}];

if you get response as text then use jsonData=JSON.parse(yourResponseText);

for(var i=0;i<jsonData.length;i++){
alert('your required val:'+jsonData[i].field1);
}

In php

$data = json_decode($json);//$json is your json data

foreach ($data as $item) {
  echo $item->field1
}

edited Oct 01 '13 at 13:29

answered Oct 01 '13 at 13:17

Anand Jha

10,404
6
25
28

would you be able to help me with a PHP solution? – Anon Oct 01 '13 at 13:21

score 1 · Answer 3 · edited May 23 '17 at 10:25

1

https://stackoverflow.com/a/3627901/485790

console.log(jQuery.parseJSON(' [{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}]').field1);

edited May 23 '17 at 10:25

Community

1
1

answered Oct 01 '13 at 13:18

Vojtiik

2,558
1
17
21

could you help me with doing this in PHP? – Anon Oct 01 '13 at 13:21

score 1 · Answer 4 · answered Oct 01 '13 at 13:25

In php way

$jsonString = '[{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}]';

$json = json_decode($jsonString, true);

foreach($json as $item){
   echo $item['field1'];
}

score 1 · Answer 5 · answered Oct 01 '13 at 13:28

1

In php you can:

$json = json_decode($_GET['variable'];

http://php.net/manual/en/function.json-decode.php

answered Oct 01 '13 at 13:28

Developerium

7,155
5
36
56

score 1 · Answer 6 · answered Oct 01 '13 at 13:29

try this,

var json = '[{"field1":3,"field2":"5","field3":"value3","field4":"value4"},{"field1":3,"field2":"8","field3":"value3","field4":"value4"},{"field1":3,"field2":"6","field3":"value3"}]';
    $.each(jQuery.parseJSON(json), function () {
        alert(this['field1']);
        alert(this['field2']);
        alert(this['field3']);
        alert(this['field4']);

});

score 1 · Answer 7 · answered Oct 01 '13 at 14:03

1

this is a simple array of json objects. so with jquery

var jsonArray = JSON.parse("your string");
   for(var int i=0 ; i < jsonArray.length() ; i++){
     var jsonObject = jsonArray[i];
     Console.log(jsonObject.field1)
   }

answered Oct 01 '13 at 14:03

Pankaj Sharma

1,833
1
17
22

Parsing a JSON array of arrays using PHP

7 Answers7