Load data infile mysql not working in php script

Question

I've this code to load data from text file into MySQL table. but I don't know why it is not working.

My php code:

self::$mysqliStmts=DBCon::ConnectToDB();
self::$data=DBCon::QueryDataWithoutProcessing("LOAD DATA INFILE 'C:\wamp\www\php\gagster\Others\friends.txt' INTO TABLE gagster.friends");      
mysqli_close(self::$mysqliStmts);

public static function QueryDataWithoutProcessing($query)
{
    self::ConnectToDB();
    self::$QueryResult=self::$mysqli->query("$query");      //process query
    mysqli_close(self::$mysqli);                            //close connection
    return self::$QueryResult;                              //return result 
}

When I write any other query in place of this query it works fine.Only this query is causing problems.

I ran the query in mysql workbench and there also it is working fine.

Daniel · Accepted Answer · 2012-08-27 12:06:24Z

3

"Windows path names are specified using forward slashes rather than backslashes. If you do use backslashes, you must double them." - http://dev.mysql.com/doc/refman/5.1/en/load-data.html

answered Aug 27, 2012 at 12:06

Daniel

3,8065 gold badges32 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

Load data infile mysql not working in php script

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