Wednesday, 15 July 2015

When adding to MYSQL database, apostrophes change to ' and are backslashed -



When adding to MYSQL database, apostrophes change to ' and are backslashed -

i switched new server , when add together new topics forum, apostrophes become ' come in database, while apostrophes backslashed.

for example:

mike's website becomes: mike\'s website. while in database becomes: mike\' website.

i have checked see if magic_quotes on via php.ini -- off.

i have spent days troubleshooting, no available reason why.

strangely, when utilize ' creating topic in forum, returns apostrophe! assuming there of language problem. forum programmed utilize utf-8, , database.

i checked database entries before switch, , oddly, recorded apostrophes ' , not ' ... should. know utilize striplashes(), don't want since worked without them before!

what apache/mysql settings causing occur?

furthermore, characters < > become html code characters.

mysql database

No comments:

Post a Comment