how to Un Serialized array

Open v2boy opened this issue 5 years ago • 1 comments

a:2:{i:0;a:6:{s:8:"order_id";i:4643;s:7:"item_id";i:3584;s:4:"name";s:96:"Asd 1box of 10pcs";s:3:"qty";i:1;s:7:"shipped";i:0;s:6:"status";s:11:"not-shipped";}i:1;a:6:{s:8:"order_id";i:4643;s:7:"item_id";i:3585;s:4:"name";s:62:"Fashion kids pink Asd";s:3:"qty";i:5;s:7:"shipped";i:0;s:6:"status";s:11:"not-shipped";}}

Jul 12 '20 15:07 v2boy

you cannot unserialize whole string at once. Only one key which you want at a time.

SELECT getPhpSerializedArrayValueByKey(_input_string,key_you_want_to_unserialize)

More : https://github.com/Nobiles2/MySQLToolBox/blob/master/getPhpSerializedArrayValueByKey_README.md

Nov 19 '20 20:11 pawan-saxena