[Resolved] Entering data with a quote character

[cupboy]

I have an input form. When I enter

Test 'this'

I end up with Test \'this\'

How do I get rid of those backslashes and why do they appear in the firstplace?

By the time the data gets into the database it looks like this
'Test \'

[Norman_Graham]

Hi Cupboy

In any programming language at all, you'll find that strings are encapsulated in quotes. Sometimes single quotes, sometimes double quotes, and in the case of PHP, either are acceptable.

When a string starts, it starts with quotes. When a string ends, it ends with quotes. If you have quotes in the middle of a string, then the string ends right there and, lo and behold, you have a parse error.

If you want to use quotes in the middle of a string, you have to escape them thus:

"This is my string which contains a \"quote\" from Albert Einstein."

If you put strings into a MySQL DB and those strings contain unescaped quotes, PHP/MySQL will either throw an error or will magically escape those quotes for you, depending on how your einvironment has been set up.

If you want rid of the slashes when you get the data back out of the DB, you need to use PHP's handy stripslashes() function.

HTH

Norm

[cupboy]

I got this figured out ok now. Actually I am using SQL Server so don't want the backslash in the database. Is that how you do it with mySQL ? I haven't started using that yet. The stripslashes function helped me, and I also tested out the magic_quotes_sybase but found it better to just leave it off and double up the quotes using str_replace when submitting it to the database. Thanks.

[bradgrafelman]

Three useful functions:

• [man]stripslashes/man

• [man]addslashes/man

• [man]mysql_real_escape_string/man