Php反序列化序列化数组

Question

I have a SQL column where i store serialized values. I want to interogate the table, get all the column values, unserialize them and then work on the data in the resulted array.

 $g1 = mysql_query("SELECT q4 FROM qa");
 $g2 = (mysql_fetch_array($g1)); 

but $g2 don't return all the column values. Also, after i get all the values in a $g2 array, how i should unserialize the resulted array of arrays? Thank you!

Answer 1

Try this :

$g1   = mysql_query("SELECT q4 FROM qa");
$val  = array();
while($g2   = mysql_fetch_array($g1)){
    $val[]  = unserialize($g2['q4']);
}

echo "<pre>"; 
print_r($val);