Slashes in database data

[ziycon]

When i submit data to the database like the example below:

"Sean's car is broken"

It ends up like this in the database:

\"Sean\'s car is broken\"

How can i stop this from happening?

[Markus]

Sounds like you've got magic_quotes turned on.

[ziycon]

So i just get my host to turn it off, if they wont turn it off, is there any other way to fix it?

Will putting this into the .htaccess file work:

php_flag magic_quotes_gp c off

[Markus]

So i just get my host to turn it off, if they wont turn it off, is there any other way to fix it?

Will putting this into the .htaccess file work:

Yes, and you just told me it. :)

[ziycon]

Is there any draw backs or knock on effects from turning off magic quotes?

[Markus]

Is there any draw backs or knock on effects from turning off magic quotes?

No, apart from it not escaping your data with slashes. It's being dropped from PHP completely in PHP 6 - signaling it's pointlessness.

[ziycon]

Cool, thanks for that.

[pbmods]

For more fun with magic quotes:

http://php.net/magic_quotes