issue with json decode value stored in mysql

Question

I have the following value stored in mysql : a:3:{i:0;s:2:"35";i:1;s:2:"33";i:2;s:2:"50";}

when I use

 $value= 'a:3:{i:0;s:2:"35";i:1;s:2:"33";i:2;s:2:"50";}'
 $data_array = json_decode($value);
 var_dump($data_array);

this returns null.how can I return the values, in this case its 35 33 and 50.

u_mulder · Accepted Answer · 2013-06-06 18:42:54Z

5

This is not json data. This is serialized data. Use unserialize to get an array.

$value= 'a:3:{i:0;s:2:"35";i:1;s:2:"33";i:2;s:2:"50";}'
$data_array = unserialize($value);
var_dump($data_array);

answered Jun 6, 2013 at 18:42

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Comments

phpisuber01 · Accepted Answer · 2013-06-06 18:43:02Z

4

That is not JSON. It's a serialized array. Use unserialize() instead of json_decode.

answered Jun 6, 2013 at 18:43

phpisuber01

7,7453 gold badges25 silver badges26 bronze badges