Convert JSON string to array in php?

Question

I want to convert the following JSON string to array using PHP...

a:6:{
i:0;a:2:{s:2:"id";d:31003200320082;s:7:"address";s:5:"test1";}
i:1;a:2:{s:2:"id";d:83003500350087;s:7:"address";s:9:"test2";}
i:2;a:2:{s:2:"id";d:41002800280012;s:7:"address";s:5:"test3";}
}

Please help me....

Try [`unserialize`](http://www.php.net/manual/en/function.unserialize.php) on your data. — Dave Chen, Apr 16 '14 at 05:58
Your string is not a json, but it is not serialized array also. Where did you get this output? — Hüseyin BABAL, Apr 16 '14 at 06:05
I don't know actually I am new in oops in php.... I am very much confused for this one.... :( This project is not developed by me so I am not getting the right function to insert in db... — Hardik Patel, Apr 16 '14 at 06:29

score 2 · Answer 1 · answered Apr 16 '14 at 06:04

2

Try using

json_decode($data,true) to get the results in Array format

true is for converting to array, otherwise it will return as object

answered Apr 16 '14 at 06:04

sshet

1,152
1
6
15

Thanks but, I have tried bro... Look this... $locations='a:6:{i:0;a:2:{s:2:"id";d:31003200320082;s:7:"address";s:5:"test1";}i:1;a:2:{s:2:"id";d:83003500350087;s:7:"address";s:9:"test2";}i:2;a:2:{s:2:"id";d:41002800280012;s:7:"address";s:5:"test3";}}'; $resultLocations=json_decode($locations,TRUE); print_r($resultLocations); – Hardik Patel Apr 16 '14 at 06:14
right , so first you need to correct JSON string otherwise it will keep on throwing error – sshet Apr 16 '14 at 06:26

score 1 · Answer 2 · answered Apr 16 '14 at 06:03

1

Here is the Best way:

Store the string in a PHP variable:

$jsondata = '...... json string goes here ......';
Now use json_decode PHP function.

$resultdata = json_decode($jsondata);

The result will be collection of arrays and objects.

However, your data is not is json but serialized so you will need to use unserialize

answered Apr 16 '14 at 06:03

Sankalp Bhatt

1,154
13
17

Thanks bro, but I haven't get success in that function.... I am getting null value by this function.... :( – Hardik Patel Apr 16 '14 at 06:10
anyways How did you got this data? – Sankalp Bhatt Apr 16 '14 at 06:17

score 1 · Answer 3 · answered Apr 16 '14 at 06:03

1

try json_decode()

refer php manual

answered Apr 16 '14 at 06:03

AVM

592
2
11
25

Thanks bro, but I haven't get success in that function.... I am getting null value by this function.... :( – Hardik Patel Apr 16 '14 at 06:04
just check it using var_dump(json_decode($json)); may be its returning objects.try json_decode($json, true); for array – AVM Apr 16 '14 at 06:10
Can you please specify how your json string is generated – AVM Apr 16 '14 at 06:20
I don't know actually I am new in oops in php.... I am very much confused for this one.... :( – Hardik Patel Apr 16 '14 at 06:23
that's ok,did you tried unserialize() on that string? – AVM Apr 16 '14 at 06:37

score 0 · Accepted Answer · answered Apr 16 '14 at 06:43

Got solution to your problem:

The String you are using is not a JSON string, its actually a serialized array. So you will need to use the function unserialize instead of json_decode.
You are not getting success with unserialize because the serialized string you have is malformed. I have made some adjustments in the string use mine one and you will get success.

old malformed one:

a:6:{
   i:0;a:2:{s:2:"id";d:31003200320082;s:7:"address";s:5:"test1";}
   i:1;a:2:{s:2:"id";d:83003500350087;s:7:"address";s:9:"test2";}
   i:2;a:2:{s:2:"id";d:41002800280012;s:7:"address";s:5:"test3";}
   }

new Corrected string:

a:3:{i:0;a:2:{s:2:"id";i:31003200320082;s:7:"address";s:5:"test1";}i:1;a:2:{s:2:"id";i:83003500350087;s:7:"address";s:5:"test2";}i:2;a:2:{s:2:"id";i:41002800280012;s:7:"address";s:5:"test3";}}

Have a good day my friend.

Convert JSON string to array in php?

4 Answers4