uploading a text file to db

muppy

I must upload a text file to a table in a mysql db.

after connecting to db, i used this query

$query = "LOAD DATA LOCAL INFILE '/path/_file_name' INTO TABLE tableFIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'";

but it gives me this error:

Parse error: parse error in
/path/file_name.php on line 11

I tried modifing the query sobstituting ENCLOSED BY '"' with ENCLOSED BY '\"'

But an other error appears:

You have an error in your SQL syntax near ''' at line 2

Where is the error??
Many thanks
Andrea

brad_fears

This works for me:

$query = "LOAD DATA LOCAL INFILE '/path/_file_name' INTO TABLE tableFIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'";

echo $query;

OUTPUT:

LOAD DATA LOCAL INFILE '/path/_file_name' INTO TABLE tableFIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'

--Brad Fears

muppy

i tried, but it gives me this error:
You have an error in your SQL syntax near '\r\n'' at line 1
Thanks
Andrea

brad_fears

I put an extra set of backslashes at the end of the query statement in order to echo the result and see the '\r\n'. You may need to remove them in order to actually run the query. So your line should look like this:

$query = "LOAD DATA LOCAL INFILE '/path/_file_name' INTO TABLE tableFIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'";

muppy

It works! Many many thanks
Muppy