Hi,
I'm trying to loop thru an unserialized array pulled from mysql. First I
serialized the array before storing it:
------------------------------------------------------------------------
$sql�="UPDATE�$table_name�set�performer_id='"�.�addslashes(serialize($perfor
mer_id))�.�"'�WHERE�lineup_id=$lineup_id";
------------------------------------------------------------------------
This seems to work. mysql stores $performer_id as:
a:3:{i:0;s:2:"12";i:1;s:1:"1";i:2;s:1:"3";}
The next time I grab $performer_id from mysql I want to unserialize it and
loop thru it with foreach():
------------------------------------------------------------------------
$sql�="SELECT�performer_id�FROM�lineup�WHERE�lineup_id=$lineup_id";
$result_pid�=�@mysql_query($sql,�$connection)�or�die("Couldn't execute query
perfomer ID.");
while�($row�=�mysql_fetch_row($result_pid))�{
$result_pid�=�unserialize($result_pid);
foreach�($result_pid�as�$performer_id)�{
(some�more�code�here)
}
------------------------------------------------------------------------
But this gives me an error "Warning: Invalid argument supplied for
foreach()". I used var_dump before and after I unserialized just to check
that the result set actually contained data.
The first var_dump produced "array(1) { [0]=> string(44)
"a:3:{i:0;s:2:"10";i:1;s:1:"6";i:2;s:2:"17";}" }". Looks good, but var_dump
after unserializing gives "bool(false)".
I also tried using reset() after the first var_dump, and stripslashes(), but
got the same error. Can anyone see what I'm doing wrong? Thanks!
Jim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
