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.

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

up vote 4 down vote

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

answered Jun 6 at 18:43

phpisuber01
2,4791113

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

up vote 5 down vote

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 at 18:42

u_mulder
21018

2 Answers