Error by mysql when a field include an apostrophe.

[spino]

I have an application done in php, mysql, and apache2 created in linux.
I had a transfer into the wonderful xampp ... but now I have a problem.

When a field contains an apostrophe the query aborts. This don't happens in Linux.

To explain me better, I attach an example:

INSERT INTO anagrafica (idanagrafica, tipodocumento, editore, collocazione, annoedizione, titolo, id_autore, annotazioni, file, user_agg, data_agg) values ($idanagrafica, $tipodocumento, '$editore', '$collocazione', $annoedizione, '$titolo', $autore, '$annotazioni', '$file', '$user_agg', '$data_agg');

fails if one or more fields like '$titolo' , '$collocazione', '$editore' etc. contain an apostrophe inside.

Please can some body help me?

[MC10]

I believe that you use the addslashes() function in PHP in order to escape the ' so that they get inputted correctly into the MySQL database. See this for more information.

[Altrea]

or even better the mysql_real_escape_string()-function

or even more better the mysqli-prepared-statements model

[spino]

Tank you to both for help me
Now I have something to think about
Bye