# Print serialized array values in smarty

**URL:** <https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053>\
**Category:** English forums\
**Tags:** oxid6, development, dev-talk\
**Created:** [December 11, 2019, 1:50pm UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053 "2019-12-11T13:50:45Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mohsin\_Javaid](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/mohsin_javaid/32/1406_2.png) [@Mohsin\_Javaid](https://forum.oxid-esales.com/u/Mohsin_Javaid)\
**Post date:** [December 11, 2019, 1:50pm UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/1 "2019-12-11T13:50:45Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![vanilla\_thunder](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/vanilla_thunder/32/72_2.png) [@vanilla\_thunder](https://forum.oxid-esales.com/u/vanilla_thunder)\
**Post date:** [December 11, 2019, 5:02pm UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/2 "2019-12-11T17:02:59Z")

</div>

![image](https://forum.oxid-esales.com/uploads/default/original/2X/6/6c51e81b5616bc3cc265ed8efdba8856a30e4fef.png)

---

<div class="post-metadata">

**Author:** ![Mohsin\_Javaid](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/mohsin_javaid/32/1406_2.png) [@Mohsin\_Javaid](https://forum.oxid-esales.com/u/Mohsin_Javaid)\
**Post date:** [December 12, 2019, 5:25am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/3 "2019-12-12T05:25:53Z")

</div>

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. 🙂

---

<div class="post-metadata">

**Author:** ![vanilla\_thunder](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/vanilla_thunder/32/72_2.png) [@vanilla\_thunder](https://forum.oxid-esales.com/u/vanilla_thunder)\
**Post date:** [December 12, 2019, 8:26am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/4 "2019-12-12T08:26:04Z")

</div>

“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

---

<div class="post-metadata">

**Author:** ![Mohsin\_Javaid](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/mohsin_javaid/32/1406_2.png) [@Mohsin\_Javaid](https://forum.oxid-esales.com/u/Mohsin_Javaid)\
**Post date:** [December 12, 2019, 9:08am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/5 "2019-12-12T09:08:42Z")

</div>

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

 ![Screenshot_6](https://forum.oxid-esales.com/uploads/default/original/2X/f/f66871ab3eddedcf85f80f1c3345af364611b721.png)

---

<div class="post-metadata">

**Author:** ![vanilla\_thunder](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/vanilla_thunder/32/72_2.png) [@vanilla\_thunder](https://forum.oxid-esales.com/u/vanilla_thunder)\
**Post date:** [December 12, 2019, 9:28am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/6 "2019-12-12T09:28:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mohsin\_Javaid](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/mohsin_javaid/32/1406_2.png) [@Mohsin\_Javaid](https://forum.oxid-esales.com/u/Mohsin_Javaid)\
**Post date:** [December 12, 2019, 9:34am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/7 "2019-12-12T09:34:33Z")

</div>

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}]
```

---

<div class="post-metadata">

**Author:** ![vanilla\_thunder](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/vanilla_thunder/32/72_2.png) [@vanilla\_thunder](https://forum.oxid-esales.com/u/vanilla_thunder)\
**Post date:** [December 12, 2019, 9:57am UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/8 "2019-12-12T09:57:24Z")

</div>

> [@Mohsin\_Javaid](#):
>
> `<td>$finalItem.Plant</td>`

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.

---

<div class="post-metadata">

**Author:** ![system](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/system/32/4245_2.png) [@system](https://forum.oxid-esales.com/u/system)\
**Post date:** [July 13, 2026, 7:41pm UTC](https://forum.oxid-esales.com/t/print-serialized-array-values-in-smarty/96053/9 "2026-07-13T19:41:59Z")

</div>