Unserializing problem

Milton

Hi,

I'm trying to put an array into a database by serializing the array. This works fine and when I look at the database I can see the serialized array there. However, when I try to unserialize the array, nothing is returned.

Can anybody help me with this?

nnichols

Post the code you are using for serializing/deserializing.

The usual problem is that people forget to declare the variable before deserializing the data to it.

[deleted]

Why are you storing an array in a database? You can't work with serialized data in a database, you'll have to unserialize it for every task, inclusing simplewhere clauses.

Milton

Here's the code I've been trying to use:

To put information into the database:

$variable=array ("1","2","3");

$newarray=serialize($variable);

mysql_query("INSERT INTO table(col1) VALUES ($newarray)");

To take it out

mysql_query("SELECT * FROM table WHERE anothervalue=' ');

$anewarray=array():

$result=mysql_result($result,0,"col1");
$anewarray=unserialize($result);

print ($anewarray[0]);

It will not work

nnichols

As vincente said, there is no good reason for storing arrays in mysql as it has no native array handling.

You haven't got quotes around $newarray in your INSERT query. You should also add/strip slashes with the serialized data.

please delete your duplicate post

orangehairedboy

Here's the correct way to take it out...it will take the first row:

$result = mysql_query("SELECT * FROM table WHERE anothervalue=' '");
$first_row = mysql_fetch_array($result);

$unserialized=unserialize($first_row[col1]);

Hope this helps!

Lewis