[RESOLVED] insert apostrophe and other special chars into mysql

[nuttynibbles]

hi,

i understand to insert special chars especially apostrophe, we could add addslashes or mysq_escape_string which is better.

however, im working on an import function which insert data from csv to 3 different database. i notice that in the database, there isn't backslashes for special chars.

so i prob cant addslashes since it will produce a '\' on the live site am i right.

my question is how can we add special chars like apostrophe into the db without the backslashes

tks in adv

[Weedpacket]

If all of the databases are using MySQL, then [man]mysql_real_escape_string[/man] would be the appropriate choice.

But if you were using the [man]PDO[/man] extension to begin with, there would be no need for any extra escaping, because it would be handled automatically and the question about what function to use would be a dead issue.

[nuttynibbles]

tks that works