slashes & quortes

[Anon]

Hello,

I've a problem getting the content of a textfield into my access database when i use any apostrophe. Reading them from my database works fine but writing....

I've tried ' and \' but it doesn't work.

Does anybody know how i can make this work??
I'm working with php on an NT station. I use odbc for the connection to my access database.

thanx

[matjaz]

before you write them to file, use
add_slashes (is it without _?)

after you read the contents, do that before displaying it
strip_slashes

[Anon]

I tested the input from the textarea and i saw that the sql-statement (or php?) added the slashes?! Then i tried the trick with stripslashes so the slashes were removed. It worked but it didn't do the trick with the writing...

Add- or stripslashes don't seem to work. I think the problem is with the writing TO the database.

Does anyone has/had the same problem??

[matjaz]

they work, but you still have to control that settings in php.ini [or override them in your PHP script]. use "ini_set" function. here is an example:

ini_set("magic_quotes_gpc","1")

and read both:
- magic_quotes_gpc
- magic_quotes_runtime

now you will surely make it work.