Split set of data in the output using PHP

Question

How to spit this set of data using php? this data generated from some php to my mysql database.

[{"id":"1","is_email":"false","add_to_day_hour_info":"false","add_to_day_hour_body":"false","translation":"Company","value":"Destination Queenstown"},{"id":"2","is_email":"false","add_to_day_hour_info":"false","add_to_day_hour_body":"false","translation":"Your Name","value":"Ella Zhang"}]

now i just need to get id=2 and its value in the output.

hi rikesh...i don't know anything about json before. thank you for your references. problem solved ;) — Haris, Feb 16 '15 at 06:42

score 0 · Accepted Answer · edited Feb 16 '15 at 06:33

0

It is a JSON data.Try with -

$array = '[{"id":"1","is_email":"false","add_to_day_hour_info":"false","add_to_day_hour_body":"false","translation":"Company","value":"Destination Queenstown"},{"id":"2","is_email":"false","add_to_day_hour_info":"false","add_to_day_hour_body":"false","translation":"Your Name","value":"Ella Zhang"}]';

$array = json_decode($array);

echo $array[1]->id;

edited Feb 16 '15 at 06:33

Noël Jackson

3
1

answered Feb 16 '15 at 06:13

Sougata Bose

31,517
8
49
87

Hi Noel, thanks for help. how to implement json_decode in while loop? i tried it in my code but it returns empty – Haris Feb 16 '15 at 07:07
Add your code to loop – Sougata Bose Feb 16 '15 at 07:16
here is my code http://pastebin.com/i9z7YBwY i tried to use $array = json_decode($array, true); but still return with empty value – Haris Feb 16 '15 at 08:00
Why did you use `$array[1]`? – Sougata Bose Feb 16 '15 at 08:04
to parse json data for id:2 – Haris Feb 16 '15 at 08:10

Split set of data in the output using PHP

1 Answers1