Saving an Array to Database

[eluser]GrahamDj28[/eluser]
I use json_encode and json_decode.
Found it to be more reliable then serialize

Save to database

Code:

$string = json_encode($array);

json_encode wil return a string just like serialize does.
You can now save it to your DB. Don't forget to escape your string when saving it!

When retriving it from the database

Code:

$result = json_decode($db_result['your_json_string']);

This wil turn the json string into an object. To get the array do

Code:

$result = (array)json_decode($db_result['some_column']);

I don't know how you are returning your DB results, so this is just as an example.

Hope this helps you out!