Mysql

[Anon]

I'm trying to create a datebase with a field of comments for my subscribers. My problem is that if my subscribers write in the comment field using apostrophes these comments are not to be accepted by mysql because generates error. At the moment the field has the denomination of Text.
Thank-you for the help Louis

[Anon]

Hi Louis,

Try using the Php function addslashes() on the string that is being sent to MySql. (Assuming that you ARE trying to insert data into the db using PHP that is...)

Clarissa

[Anon]

Hi Clarissa,
can you please give me an example, I didn't quite understand much. This is my code.
<?
mysql_connect"localhost","user","psw");
mysql_select_db("datebase");
mysql_query("INSERT INTO table (id, sesso, eta, email, professione, argomento, intervento) VALUES ('', '$sesso', '$eta', '$email', '$professione', '$argomento', '$intervento')");
?>
Thank-you again. Louis

[Anon]

is $argomento the variable holding the comments from the form?

If so add the following line:
$argomento=addslashes($argomento)

i.e.
<?
$argomento=addslashes($argomento)
mysql_connect"localhost","user","psw");
mysql_select_db("datebase");
mysql_query("INSERT INTO table (id, sesso, eta, email, professione, argomento, intervento) VALUES ('', '$sesso', '$eta', '$email', '$professione', '$argomento', '$intervento')");
?>

Let me know if that works!

Clarissa

[Anon]

Sorry Clarissa, but your advice doesn't work. I even tried to put in several positions "$argomento=addslashes($argomento);" but can't put it in my datebase my commentsif using apostrophes.
Thank-you again Louis

[Anon]

Ok - Another solution would be to do a search for the apostrophes and replace them with &acute;

ereg_replace ("'", "&acute;", $argomento)

Let me know...

[Anon]

Clarissa I really don't know what to say. Anyway you have been very kind in trying to help me. Seems I need to talk to someone directly. Hope goes better next time. Louis

[Anon]

Sorry couldn't be of any help.
I have had the same problem in the past and the "ereg_replace()" method
worked - seeing as the reason the insert statement fails is because MySQL
gets confused as to where the string it is inserting into the DB ends -
Good luck

[Anon]

Louis you need toi run your addslashes funtion before the query line like:

$argomento = addslashes($argomento);
mysql_query("INSERT INTO table (id, sesso, eta, email, professione, argomento, intervento) VALUES ('', '$sesso', '$eta', '$email', '$professione', '$argomento', '$intervento')");

By the Way Cool Name!

-Louie

[Anon]

Also check out your php.ini file.

Somewhere in the file is the magic_quotes section.

A couple months ago I had the same problems and if I remember correctly I turned all the magic_quotes OFF.

Just something else to look at.