PHP mysql_query automatically stripping slashes?

Question

I am echoing the statement out right above the mysql_query statement, and for some reason the slashes in the csv file are being stripped? I get the error you can see below. Any insights?

echo "LOAD DATA LOCAL INFILE '" . $csv . "' INTO TABLE mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES";
mysql_query("LOAD DATA LOCAL INFILE '" . $csv . "' INTO TABLE mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES") or die(mysql_error());

ERROR:

LOAD DATA LOCAL INFILE 'C:\FileClean\output\6eai1mikqkidpe1re77e8a6jn2trial_new.csv' INTO TABLE mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' IGNORE 1 LINES

Can't find file 'C:FileCleanoutput6eai1mikqkidpe1re77e8a6jn2trial_new.csv'

yo can see what $csv equals in the statement I echoed out above (right below "ERROR") — A_funs
– A_funs, Commented Feb 16, 2012 at 20:22

itsmequinn · Accepted Answer · 2012-02-16 20:22:09Z

1

You need to escape the slashes by adding another slash in front of each in the $csv file path.

example:

C:\\FileClean\\output\\6eai1mikqkidpe1re77e8a6jn2trial_new.csv

answered Feb 16, 2012 at 20:22

itsmequinn

1,0841 gold badge9 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davethegr8 · Accepted Answer · 2012-02-16 20:23:36Z

1

\ is a special character--the string escape character--so it's probably doing strange things. Try addslashes to make them \\ instead.

answered Feb 16, 2012 at 20:23

davethegr8

11.7k5 gold badges41 silver badges61 bronze badges

Comments

MysticXG · Accepted Answer · 2012-02-16 20:24:14Z

0

You have to escape the slashes in $csv, like so:

"C:\\FileClean\\output\\6eai1mikqkidpe1re77e8a6jn2trial_new.csv"

answered Feb 16, 2012 at 20:24

MysticXG

1,44710 silver badges10 bronze badges

Collectives™ on Stack Overflow

PHP mysql_query automatically stripping slashes?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related