" in mySql update via PHP

[Anon]

Hi!

I've a problem updating mysql database through php.

If new value contains inverted commas("), none of my "solutions" works..

i've tryed many ways, last one was replacing " with \" like this:

str_replace('"','\"',$rec[0]) before executing command...

but after executing mysql_query everything after " gets lost 🙁

I used update syntax(update table set...) The value are collected from form elements...

Q: How can I update database so that inverted commas wouldn't "get lost".

Thanks🙂

[lawnmowerman]

Say, for example, you have the following variable:

$name = 'Richard "Rich" Alloway';

Now, we can agree that $name now contains:
Richard "Rich" Alloway

In order to safely convert this to something which can be placed into a SQL statement, you need to use the addslashes() function:

$name = addslashes( $name );

This will populate $name to contain data like this:
Richard \"Rich\" Alloway

The variable is now safe to use.

In order to convert the variable back to it's non-slashed form:

$name = stripslashes( $name );

Hope this helps!

-Rich