Php unserialize array of serialized

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!

What do you mean but it does'nt return all the values? Check the table through the mysql workbench or something to make sure the data is actually there. To unserialize you can use implode() on the arrays, or list() while looping thru them to assign each value to an variable — aleation
– aleation, Commented Mar 13, 2013 at 9:13

Prasanth Bendra · Accepted Answer · 2013-03-13 09:13:13Z

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);

answered Mar 13, 2013 at 9:13

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jcubic · Accepted Answer · 2013-03-13 09:13:29Z

1

if q4 is string serialized using serialize function then you need to use unserialize function.

$g2 = array();
foreach(mysql_fetch_array($g1) as $row) {
    $g2[] = unserialize($row[0]);
}

answered Mar 13, 2013 at 9:13

jcubic

67k58 gold badges251 silver badges466 bronze badges

Comments

thelastshadow · Accepted Answer · 2013-03-13 09:14:53Z

0

You need to iterate over the rows

like:

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

while($row = (mysql_fetch_array($g1))) {
    $g2[] = $row;
}

assuming you serialized the data with PHP the answer is the unserialize() method

answered Mar 13, 2013 at 9:14

thelastshadow

3,6604 gold badges37 silver badges37 bronze badges

Collectives™ on Stack Overflow

Php unserialize array of serialized

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related