load data local infile problem

fimbria

hi,

im trying to create a simple php page that where a user selects a text file on their local machine that they can submit the file content to a mysql database table. The first part of the code is where the file is select , then with an form action the user the sumbit that address to the query...where it should add the details of where the file can be found, to the variable "$fileload". Which then is included in the sql query.

The problem is that it is not submitting anything to the database?? can anyone see why?

Thanks for any help in advance

Fimbria

<?php

include "db.php";
if(!isset($fileload)){

print"<form name=\"frm\" method=\"post\" action=\"add3b.php\">";
print"Enter address of file (e.g. <b>filename</b>.txt)<br><br>
Address of File:";
print"<br><input type=\"file\" name=\"fileload\" size=\"30\"><br>";

print"<br><br><input type=\"submit\">";
print"</form>";

}else{

$query="LOAD DATA LOCAL INFILE '$fileload'
INTO TABLE test FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r'
IGNORE 1 LINES";

mysql_query($query);

print"File Added: $fileload";
}

?>
</body>
</html>

Bunkermaster

$fileload should be $_POST['fileload']

try to add

mysql_query($query) or die(mysql_error()." line ".__LINE__);

to see if the query works.

To allow LOAD DATA mysql has to be started with some specific flags turned on. Look in the mysql manual.

fimbria

i tried adding the error part to the code and got the following error message:

File 'C:\Documents and Settings\user\Desktop\test.txt' not found (Errcode: 2)

but i have just selected the file so i know that the file exists...what are these flags you are talking about....?(new to mysql so...)

Thanks for you time

Fimbria

Bunkermaster

read this :
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

I am sorry. I only read your post kinda fast during coffee break.

What you need to do is execute the query on the uploaded file (don't know if you can use the temp file). So your script has 2 twists. Upload and load.

I'll add a lill code I made some time ago in which you'll find a few funny things (it does the upload and import for me in systems where the LOAD DATA is not working)