[RESOLVED] unserialize() [function.unserialize]: Error at offset 45393 of 65533 bytes

[praveenp]

Hi

Unserialize function is not working properly when large data is serialized. If i serialize short data then working fine.

Actually i am searching the data based on conditions then serializing the search result and storing into database, when unserialized giving below notice

Notice: unserialize() [function.unserialize]: Error at offset 45393 of 65533 bytes

I am using PHP 5.0.1 version.

I searched forums but not find answer.

Please any one can help me.

Thanks in advance.

Praveen

[bradgrafelman]

How are you serializing the data? How are you storing it? How are you retrieving it?

[praveenp]

Preparing array with all details and while storing using serialize() function.
When required getting the data from the database and unserializing using unserialize() function

Exmpale

$aryDetails = array();
$aryDetails[0] = array('fname'=>'Praveen', 'lname'=>'Kumar', ......etc);
..
..
..
$aryDetails[100] = array('fname'=>'Carol', 'lname'=>'Lander', ......etc);

$serializeData = serialize($aryDetails);

// Storing this data into data base

mysql_query("INSERT INTO sample(sno, content) VALUES (1, '".addslashes($serializeData )."')", $con);

// getting data from this table when required

$query = mysql_query("SELECT content FROM sample", $con);
$resultSet = mysql_fetch_assoc($query);

$content = $resultSet['content'];

$aryResultDetails = unserialize($content);

If count of $aryDetails array is less then working fine, if it is big like count 100 then it is not working while unserializing.

Thanks
Praveen

[bradgrafelman]

For one, [man]addslashes/man should never be used to prepare data for a SQL query - instead, you should be using a DBMS-specific escaping function (such as [man]mysql_real_escape_string/man).

Second... what type of column is content ?