[PHP] Problem while retrieving data from cookie with unserialize

[Sævar Öfjörð]

Hi, I’m having this problem:

I set a cookie using this:

                        $sql = "UPDATE member SET cookie=$cookie WHERE
".
                          "id = $this->id";
                        $this->mysql->query($sql);
                        $cookie =
urlencode(serialize(array($_SESSION['username'], $cookie)));
                        setcookie('auth', $cookie, time() + 31104000,
'/', 'www.reddast.is');

And then when I check the cookie using this:

                list($username, $cookie) =
@unserialize(urldecode($cookie));


using this query:

                "SELECT * FROM member WHERE (username = $username) AND
(cookie = $cookie)";

it looks like this when I debug the script and see the actual query that
is sent to Mysql:

                "SELECT * FROM member WHERE (username = 'ofjord') AND
(cookie = '\'86aa5f7e6469efe09a17089957f59b0f\'')";


I hope someone has any answers on this.

Best regards,
Sævar Öfjörð Magnússon
[EMAIL PROTECTED]
ICELAND


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php