Continued from page 1
You'll see that I used
addSlashes() function. That's because when crossword object was serialized it contained characters like double quotes. These had to be escaped before crossword could be saved to database.
Now having saved a crossword object to a database I had to have a way to get it back. Surely, if there was a method to serialize an object there had to be one to unserialize an object, right? And yes, there is: unserialize().
As you'd expect, unserialize() works same way as serialize(), but in opposite direction. You give it some serialized data and it returns thing that was serialized. To get crossword back all I had to do was something like "unserialize($crosswordData)."
Here's a look at code:
$xwordId = (get_magic_quotes_gpc()) ? $xwordId : addslashes($xwordId); $sql = "SELECT xword_id, xword_obj, xword_name, xword_age from w3b_xword where xword_id=$xwordId"; $result = parent::getSQL($sql); $row = parent::getRow($result);
if(parent::getNumRows($result)>0){ $crossword = unserialize($row['xword_obj']); }
And that's it. Obviously serialize() and unserialize() are pretty handy functions to have around. And in my case I couldn't do without them.
Kevin Davies is the webmaster of Crossword Heaven (http://www.crosswordheaven.com) - a site that lets you create and solve crosswords online. If you're a webmaster you can also link to crosswords. Crosswords are a great way to keep your visitors on your site and keep them returning.
