How to convert a json string saved in mysql database to php JSON Object

Question

I have an issue with converting a string in json format to json object in php. I am saving a json string into database using ajax save. I want to convert the string into json for doing further operation. I used json_decode but with no help.

JSON STRING IN MYSQL DATABASE:

"{\"title\":\"Sachin vs shoaib akhtar and company..Unseen (BAAP BAAP HI HOTA HAI ) ....flv\",\"titleEsc\":\"Sachin vs shoaib akhtar and company..Unseen (BAAP BAAP HI HOTA HAI ) ....flv\",\"url\":\"http://www.youtube.com/watch?v=WOJlDpoL7tw\",\"pageUrl\":\"http://www.youtube.com/watch?v=WOJlDpoL7tw\",\"cannonicalUrl\":\"www.youtube.com\",\"description\":\"Sachin hitting cluless shoaib akhtar and company everywhere in ground..This is one f many innings where shoaib akhtar was brutually assaulted by sachin tendu...\",\"descriptionEsc\":\"Sachin hitting cluless shoaib akhtar and company everywhere in ground..This is one f many innings where shoaib akhtar was brutually assaulted by sachin tendu...\",\"images\":\"http://i2.ytimg.com/vi/WOJlDpoL7tw/hqdefault.jpg\",\"video\":\"yes\",\"videoIframe\":\"<iframe id=\\\"20131122120255WOJlDpoL7tw\\\" style=\\\"display: none; margin-bottom: 5px;\\\" width=\\\"499\\\" height=\\\"368\\\" src=\\\"http://www.youtube.com/embed/WOJlDpoL7tw\\\" frameborder=\\\"0\\\" allowfullscreen></iframe>\"}"

I am getting this field through mysql select. What i want to do is convert the string into JSON Object.

Rohan Kumar · Accepted Answer · 2013-11-22 07:08:19Z

3

Try json_decode() like,

$array=json_decode($yourjson,true);
var_dump($array);

For Object

$object=json_decode($yourjson);
var_dump($object);

answered Nov 22, 2013 at 7:08

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

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

1 Comment

George Joffin Joy Over a year ago

thanks Rohan that did the trick.But when i tried this without assigning to a variable like $array it was not showing strange... anyway fast reply...really appreciate buddy!! :)

Collectives™ on Stack Overflow

How to convert a json string saved in mysql database to php JSON Object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related