i have a form which let's me import a file into a mysql table. it gives the user an option to type in what the escape character will be ex "\".
this is an sql statement that works, "LOAD DATA INFILE 'provinces.csv' REPLACE INTO TABLE FIELDS TERMINATED BY ';' ESCAPED BY '\' LINES TERMINATED BY '\n'". there are two servers in this scenario. mine and production server. just to see, i echo the $escape_character. on mine, "/" becomes "//" and on production, "/" stays "/", mind you i don't do any strip or add slashes. Why is it that to be able to execute the query on the production server i need to stripslashes() to the $escape_character variable and i don't need to at home especially considering my server is the one showing more slashes on echo $escape_character? also, why do i not need to escape the lines terminated field?
