php, mysql, and special characters

[blue928]

hi, ill be brief... im using php and mysql. I am trying to use php to insert webpages into the database (php_self, for tracking purposes). some of these pages contain characters we're all familiar with, for example:

.. site.php?id=something.

when i add this to the database it cuts it off at the '?' character and only 'site.php' is entered into the database. well, i need the whole thing to be entered into the database, including special characters like '?', '"', etc.. how can i do this? I tried using ADDSLASHES() but that doesn't work.. any suggestions?

thx
blue

[wimmel]

Hi blue,

If you use $PHP_SELF to put the current filename in a database, addslashes won't help. $PHP_SELF contains only the filename, not the query string behind it.

You could solve this by using $GLOBALS[QUERY_STRING] on an apache webserver, or a similar global variable if you use another kind of webserver. If you can't find something like that with your webserver, you could convert the $HTTP_GET_VARS array to a string, seperated by ampersands.

wimmel