Menu
Community /Pin to ProfileBookmark
@NogDogMar 01.2011 — #I'd start by verifying that something was actually retrieved from the DB, such as with mysql_num_rows(). At least then you would know whether it's a query error or something else. @NogDogMar 01.2011 — #
Double quotes should not matter, assuming the string was wrapped in single quotes in the SQL. Also, any back-slashes used in the SQL (such as by using mysql_real_escape_string()) should not have ended up in the actual data, just as in PHP if you do an [b]echo """;[/b] the output would just be the double quote without the slash. But all that aside, your debug code would certainly be useful to find out what was actually retrieved from the DB -- if anything -- so that we can find out what to focus on. ? (I'm placing my bet on some silly typo we haven't seen/noticed yet.)@NogDogMar 03.2011 — #
Does it actually have the <?php and ?> tags in the database? (They should not be part of the serialized value.)@NogDogMar 03.2011 — #The direct problem is this part of the serialized array:
The "s:59" part means that the value is a string that is 59 characters long, but the value provided is only 54 characters long. As to why, you'll have to look at how the data got created in the first place. For a quick fix, you could directly change it to "s:54" in the DB.@NogDogMar 03.2011 — #
Maybe a scoping issue? (E.g.: if it's only within a function on the header script.) Or if you are including the header script via URL instead of a file system path/name?
Unserialize stopped working?!?!?
Hi, I’m banging my head against a brick wall trying to figure this one out…
I have this array….
[code=php]
<?php
array (
‘ebay_mode’ => ‘sandbox’,
‘sitename’ => ‘The On-line Chemical & Packaging Experts’,
‘timezone’ => ‘+6’,
‘header_image_max_height’ => ‘150’,
)
?>
I have serialized it and inserted it into the database and it looks like this…
[code=php]
<?php
a:4:{s:9:”ebay_mode”;s:7:”sandbox”;s:8:”sitename”;s:59:”APC-Pure.com – The On-line Chemical & Packaging Experts”;s:8:”timezone”;s:2:”+6″;s:23:”header_image_max_height”;s:3:”150″;}
?>
I have a working query…
[code=php]
<?php
$preferences = mysql_query(“SELECT * FROM preferences WHERE pref_name = ‘siteprefs'”) or die (mysql_error());
while ($prefs = mysql_fetch_array($preferences))
{
$pref = unserialize($prefs[‘pref_value’]);
}
?>
The wierd thing is this was working!! I don’t think I changed anything as I have been working on something else but I suppose there may be a conflict somewhere. I just can’t find it!!
[code=php]
<?php
echo $pref[‘sitename’];
?>
The above echo statement gives me nothing at all on screen!! Very frustrating as I’m going to feel like a right numpty if someone points out a silly error somewhere!!
Hoping someone does ?
Regards
Smithster
Sign in
to post a comment13 Comments(s) ↴
0
@NogDogMar 01.2011 — #0
@NogDogMar 01.2011 — #You need strip slashes, I would be surprised if you could store serialized data without escaping all of those double quotes.
My [I]guess[/I] is that when unserialize is seeing the string with slashes in it, it just said "this isn't a serialized object at all, return null/false".
When you try to echo null/false you don't get an error, it just doesn't have any output at all.
Try this bit of debug code:
[code=php][/QUOTE]
<?php
$preferences = mysql_query("SELECT * FROM preferences WHERE pref_name = 'siteprefs'") or die (mysql_error());
while ($prefs = mysql_fetch_array($preferences)) {
echo "<pre>[",get_type($prefs),"][",get_type($prefs['pref_value']),"]
",unserialize($prefs['pref_value']),"
-------------------------------------</pre>n";
}
?>
[/code]
Double quotes should not matter, assuming the string was wrapped in single quotes in the SQL. Also, any back-slashes used in the SQL (such as by using mysql_real_escape_string()) should not have ended up in the actual data, just as in PHP if you do an [b]echo """;[/b] the output would just be the double quote without the slash. But all that aside, your debug code would certainly be useful to find out what was actually retrieved from the DB -- if anything -- so that we can find out what to focus on. ? (I'm placing my bet on some silly typo we haven't seen/noticed yet.)
0
@NogDogMar 03.2011 — #...
I have serialized it and inserted it into the database and it looks like this...
[code=php]
<?php
a:4:{s:9:"ebay_mode";s:7:"sandbox";s:8:"sitename";s:59:"APC-Pure.com - The On-line Chemical & Packaging Experts";s:8:"timezone";s:2:"+6";s:23:"header_image_max_height";s:3:"150";}
?>
[/code]
...[/QUOTE]
Does it actually have the <?php and ?> tags in the database? (They should not be part of the serialized value.)
0
@NogDogMar 03.2011 — #The direct problem is this part of the serialized array:<i>
</i>s:59:"APC-Pure.com - The On-line Chemical & Packaging Experts"
The "s:59" part means that the value is a string that is 59 characters long, but the value provided is only 54 characters long. As to why, you'll have to look at how the data got created in the first place. For a quick fix, you could directly change it to "s:54" in the DB.
0
@NogDogMar 03.2011 — #thanks for pointing that out, I never knew the numbers represented the number of chars! However, since posting the above string, I have re-serialized the string, and just checked it and it is the correct string length. I still don't know why I have to recreate the query on every page even though it is on the header.php page which is included in every page![/QUOTE]
Maybe a scoping issue? (E.g.: if it's only within a function on the header script.) Or if you are including the header script via URL instead of a file system path/name?