Print serialized array values in smarty

English forums
, ,
1

I have a MySQL table which have data like this in a column:

a:6:{s:3:"EAN";N;s:5:"Plant";s:4:"Y023";s:15:"StorageLocation";s:4:"YAFS";s:9:"StockType";s:1:"0";s:11:"QuantityISO";s:3:"PCE";s:11:"QuantityUOM";s:6:"25.000";}

and i want to pick one value for example “QuantityUOM” and show in table in admin list. What i am having trouble is data is coming from model and looping through all articles in template and showing data but then this one column have serialized array data from which i want to pick one value and show.

How can i unserialize this serialized data and show value in smarty template?

2

image
image1339×641 84.5 KB

1 Like
3

Yes i already searched as you can see the pictures, but it doesn’t seem to be working. That’s why i posted in the forum. :slightly_smiling_face:

4

“doesn’t seem to be working” is not a qualified problem description. Is there no output at all? Parse error? Shop exception?
Also, are you sure your serialized data is in correct format? I’m getting errors when unserializing it

1 Like
5

Don’t know why it wasn’t posting so i attached the image. :roll_eyes:

Screenshot_6
Screenshot_6571×477 14.6 KB

6

looks like you forgot to unserialize it.
Make var_dumps of your data in every step (before unserializing, after unserializing, foreach item), so you know in every step what your data looks like.

7

Sorry if i have created confusion but i used the foreach loop like that:

[{foreach from=$item->some_table__oxadditional->value | unserialize item=finalItem}]

   <td>$finalItem.Plant</td>

[{/foreach}]
8

you need smarty delimiters around your [{ code }], otherwise smarty does not recognize it.

Also, as already mentioned before: make var_dumps of your data in every step.
If you had done [{$finalItem|@var_dump}], you would know why your foreach does not work.

1 Like