Insert textarea in PHP ... not accepting '

[saintbe]

I've written a simple php-script that puts info in a sql-DB.

One of the areas to fill in is a textarea... and it work fine for general text. Howerer as soon as there is a ' in the textarea the entry is not put in the DB ... the old entry remains ...

Isn't there some php-funtion that allows me to put ' in the textarea and the SQL-DB just accepts it ? Or do I have to find another method ?
I've already used a php-funtion to retain the breaks in the textarea by the ln2br function... I was wondering if there is some funtion like that that allows me to use ' in my textarea and enter it in the DB.

Thx.
Kim.

[saintbe]

Never mind... I found it

When I added the info into the DB I did it like this :

... INSERT into TABLE info='$info' ...

The ' in this line is interpreted with the ' from the textarea ... this was my problem. Fixed it with the \'

Grtz.
Kim.

[anfpunk]

Don't manually code in the \. Everything entered into the database that is not completely controlled by you should have the addslashes() function ran on it like this:

$var = addslashes($var);

and when you are getting the var out of the db you should do:

$var = stripslashes($var);


stripslashes() will escape every character that needs to be in the database.