LOAD DATA LOCAL INFILE PHP Error

• xf117a

  Old Hand

  Points: 335

  More actions

  January 24, 2015 at 4:40 am

  #99989

  Hi All,

  I hope someone can help me with a problem I recently run into.

  I am currently working on a wordpress plugin and I am trying to populate a database table via a CSV file. I am using the famous LOAD DATA LOCAL INFILE but I am getting some error which I hope someone can help resolve for me.

  When I use LOAD DATA LOCAL INFILE I get the error "File not Found" and

  When I use LOAD DATA INFILE I get the error "Access Denied for user .. "

  I have tested them out on the server as well as WAMP. I also tried changing the permissions of the file but I am still getting the same errors.

  Code:

  function load_table() {

  global $wpdb;

  $filename = 'upper_db_.csv';

  $table_nme = $wpdb->prefix . "upper_winds";

  $sql = "LOAD DATA INFILE '" . $filename . "'

  INTO TABLE $table_nme

  FIELDS TERMINATED BY ','

  ENCLOSED BY '\"'

  ESCAPED BY '\"'

  LINES TERMINATED BY ''

  ";

  $wpdb->query($sql);

  }

  Thanks, would very much appreciate your help.

  HowtoFlyaHelicopter.com

• xf117a

  Old Hand

  Points: 335

  More actions

  January 24, 2015 at 7:27 am

  #1772904

  OK I may have found the issue but I still need some help. Whilst I am escaping the " I have found out that the path \ are not being inserted into the actual path. Tried to escape them but having some trouble.

  Any ideas how I can get around this?

  Thanks

  HowtoFlyaHelicopter.com

• xf117a

  Old Hand

  Points: 335

  More actions

  January 29, 2015 at 6:18 am

  #1773958

  For anyone who may run into something similar this is the code I used to get this working.

  $filename = str_replace("//","//////",__DIR__ ."/file.csv");

  HowtoFlyaHelicopter.com