CODEWITHSUNDEEP
phpmysqlserialization
AviateX14
AviateX14

Reputation: 760

Serialized multidimensional stored in MySQLi does not print past first array

Confusing title, the basics are that I'm saving a fully sorted and ordered multidimensional array from a script and into MySQL. I then, on another page, pull it from the database and unserialize it, and then proceed to print it out with this,

$s = "SELECT * FROM gator_historical_data WHERE channelid = '{$chanid}'";
$r = $link->query($s);

$comboarray = array();

while ($row = mysqli_fetch_assoc($r)) {
    $comboarray[] = unserialize($row['dataarray']);
}

foreach ($comboarray as $item) {
    $desc = $item['content']['description'];
    $title = $item['content']['title'];
    $datetime = $item['datetime'];
    // ... ^^^ problems getting array data
}

The problem is that it doesn't take the full array from MySQL, only the first entry and thus only prints the first 'array'. So where the returned value from dataarray looks like this (var_dump): http://pastebin.com/raw.php?i=Z0jy55sM the data stored into the unserialized $comboarray only looks like this (var_dump): http://pastebin.com/raw.php?i=Ycwwa924

TL;DR: Pulling a serialized multidimensional array from a database, unserializing and it loses all arrays after the first one.

Any ideas what to do?

Upvotes: 1

Views: 270

Answers (1)

hakre
hakre

Reputation: 197659

The string you've got is a serialized string plus something more at the end that is also a serialized string again and again:

a:3:{s:6:"source";s:25:"World news | The Guardian";s:8:"datetime ...
... story01.htm";}}a:3:{s:6:"source";s:16:"BBC News - World";
                  ^^^

This format is not supported by PHP unserialize, it will only unserialize the first chunk and drop everything at the end.

Instead create one array, serialize it and store that result into the database.

Alternatively you can try to recover for the moment by un-chunking the string, however in case the paste was done right, there are more issues. But on the other hand the paste obvious isn't the done fully correct.

Upvotes: 2

Related Questions