PHP arrays and MySQL

Anon

Is it possible to store a PHP array (such as a list of numbers) in a single field of a MySQL database and then retrieve it later on?

How is it done?

What should the field type be?

Thanks in advance

Anon

Look at the functions serialize and unserialize:

http://www.php.net/manual/function.serialize.php

http://www.php.net/manual/function.unserialize.php

serialize(Array) will take the Array and return a string representing the layout of the array, which can be stored in a text field in a database. unserialize will return the array in the state that it was serialized. Hope that helps!

Chris King

Anon

Thanks Chris, you're a star!

Anon

A quick note about serialize/unserialze...

You might have to do some sort of processing on the string you pull from the database- I know that I've run into some difficulties because I forgot to stripslashes() on the string.

Good luck with it!

--Robert