LOAD FILE MySQL & PHP

Question

Trying to load a CSV into a MySQL database. Can't get it to work...

SQL Query =

$query = "LOAD DATA LOCAL INFILE `$ptempName` INTO TABLE `students` FIELDS TERMINATED BY ','  LINES TERMINATED BY '\r' ESCAPED BY ',' ENCLOSED BY '" . '"' . "   ('StudentNumber', 'FirstName', 'LastName' , 'Gender' , 'Year', 'Email', 'DOB', 'Phone', 'Notifications');";
$result = mysql_query($query)or die ('Error: '.mysql_error ());

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` INTO TABLEstudents` FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' ESCAP' at line 1

tadman · Accepted Answer · 2013-11-29 19:26:53Z

2

Backticks are used to escape database, table and column names only.

For strings you can usually use single or double quotes, as in '$ptempName'.

Be absolutely sure you have properly escaped this value if you are getting it from a user. When using mysql_query you are playing with fire.

answered Nov 29, 2013 at 19:26

tadman

212k23 gold badges237 silver badges266 bronze badges

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

Collectives™ on Stack Overflow

LOAD FILE MySQL & PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related