How to save an array in one cell?

Question

How do I store a complete array in database in symfony. My content of the array is a shopping cart:

article_id / article  / amount / price

example:

1 / knife / 4 / 4$
2 / for / 6 / 2$

How can I store the complete array in one cell?

Thanks in advance!

Might want to check out serialize (php.net/manual/en/function.serialize.php) — Doug Owings
– Doug Owings, Commented Jun 25, 2011 at 14:30

Michael Berkowski · Accepted Answer · 2011-06-25 14:35:13Z

1

You may use the object column type of doctrine. This will serialize() and deserialize() your contents.

Michael Berkowski

271k47 gold badges451 silver badges395 bronze badges

answered Jun 25, 2011 at 14:30

Arend

3,7722 gold badges29 silver badges38 bronze badges

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

Comments

Arjan · Accepted Answer · 2011-06-25 14:31:49Z

1

You could serialize() the array before storing it in the database and use unserialize() after retrieving it.

answered Jun 25, 2011 at 14:31

Arjan

9,8941 gold badge33 silver badges43 bronze badges

Rajasekar Gunasekaran · Accepted Answer · 2011-06-25 18:16:41Z

1

Serialize() & unserialize() reference

answered Jun 25, 2011 at 18:16

1,8393 gold badges27 silver badges43 bronze badges