Store an array in a database

Anon

Hi.

I want to store a multidimensional array in a blob field. How do I best accomplish that?
I know that I could use implode to store it as a string, then use explode to make it as an array again after I got it from the database, but this seems to a hard way to do it, especially when the array is made up of several dimensions?

Does anyone have any tips on how to solve my problem?

Thanks,

Martin

Anon

Needed to say is that the database is an mySQL database.

Prev mess

Hi.

Does anyone have any tips on how to solve my problem?

Thanks,

Martin

toma42

Serialize the array and add slashes to it the do an insert statement. To get the data back, SELECT it and unserialize it.

$sql = "INSERT INTO table '" . addslashes(serialize($someArray)) . "'";

Anon

That did it!

I knew there would be a function that could solve it, I just didn't know which one =)

Thanks,
Martin

Tom Anderson wrote:

Serialize the array and add slashes to it the do an insert statement. To get the data back, SELECT it and unserialize it.

$sql = "INSERT INTO table '" . addslashes(serialize($someArray)) . "'";