Jump to content


Photo

MYSQL 5 Stripping addslashes() on Insert of new record


  • Please log in to reply
2 replies to this topic

#1 JimChuD

JimChuD
  • Members
  • PipPip
  • Member
  • 15 posts

Posted 03 July 2006 - 03:01 PM

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

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 03 July 2006 - 03:24 PM

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.

#3 JimChuD

JimChuD
  • Members
  • PipPip
  • Member
  • 15 posts

Posted 03 July 2006 - 03:29 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users