Jump to content

Archived

This topic is now archived and is closed to further replies.

JimChuD

MYSQL 5 Stripping addslashes() on Insert of new record

Recommended Posts

Hi,
Im having a problem with mysql 5. I find when i insert a post and i do a addslashes to the post that in the database the slashes that should normally appear dont exist..?

however as soon as i tried it on my other server which is running mysql 4 it works fine and theres the slashes.

i did a search on the forum to find nothing related i just wondered if anyone else has encountered this issue and if any resolve was found.
I have had a look through the mysql manual yet turned up nothing....

any advice would be appreciated.
regards
Jim

Share this post


Link to post
Share on other sites
The slashes are stripped automatically by PHP when you get the content out of the database (regardless of the state of magic_quotes_gpc). However if you look in side the mysql database using PHPMyAdmin or via the command line the slashes will still be there.

Share this post


Link to post
Share on other sites
i just noticed that hehe :)
sorry i was being an idiot on one server the magic_quotes_gpc is off and the other is on.

Appreciated :)

Regards
Jim

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.