File '' not found (Errcode: 2)

[netmastan]

Hi, I am trying to load text file. HEre is my code .It says errorcode 2

<?php

require_once("mainfile.php");
global $dbi;

echo "<input type=\"hidden\" name=\"file\" value=\"C:\\hadith.txt\">";

$sql=" LOAD DATA LOCAL INFILE '$file'  INTO TABLE hadith FIELDS TERMINATED BY '@'
 LINES TERMINATED BY '|'(volume, book, number, hadith)";

$result=mysql_query($sql,$dbi);


#$load=mysql_query("LOAD DATA LOCAL INFILE '$file1' INTO TABLE hadith FIELDS TERMINATED BY '@' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '|' (volume, book, number, hadith)",$dbi);

if( !$result)

die("Something wrong:".mysql_error());


?>

Another thing why this line says parse error

$load=mysql_query("LOAD DATA LOCAL INFILE '$file1' INTO TABLE hadith FIELDS TERMINATED BY '@' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '|' (volume, book, number, hadith)",$dbi);

I use the following code in phpmyadmin.It works. In the above code even i change file location to 'C:\WINDOWS\hadith.text' it does not work ???

LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\hadith.text' INTO TABLE hadith FIELDS TERMINATED BY '@' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '|' (volume, book, number, hadith) 

sorry guys asking for so many questions.

thanks

[RGBlackmore]

you can do a form like this:

<form method="post" action="script.php" enctype="multipart/form-data">
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>

script.php now have $form_data in the webserver; it's a temporal file uploades. You can work with it.

[netmastan]

I get this error ;

Something wrong:File 'c:windowsphp1e9.tmp' not found (Errcode: 2)

looks like it uploading in the wrong directory. BY the way I am using Apache,php and mysql on windows xp.

<?php

require_once("mainfile.php");
global $dbi;

#echo "<input type=\"hidden\" name=\"file\" value=\"C:\\hadith.txt\">";

if(!empty($submit))  {

$sql=" LOAD DATA LOCAL INFILE '$form_data'  INTO TABLE hadith FIELDS TERMINATED BY '@'
 LINES TERMINATED BY '|'(volume, book, number, hadith)";

$result=mysql_query($sql,$dbi);


#$load=mysql_query("LOAD DATA LOCAL INFILE '$file1' INTO TABLE hadith FIELDS TERMINATED BY '@' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '|' (volume, book, number, hadith)",$dbi);

if( !$result)

die("Something wrong:".mysql_error());



} else {

echo "<form method=\"post\" action=\"load.php\" enctype=\"multipart/form-data\">
<input type=\"file\" name=\"form_data\" size=\"40\">
<p><input type=\"submit\" name=\"submit\" value=\"submit\">
</form>" ;

}


?>

[netmastan]

RGBlackmore , thank you ur great help . I have fixed the probem.
php was uloanding temporary files in the wrong place.

Now , I am making a database(2000 records) out of text file ..just by a single click.

Can you amazine I was going to add these records one at a time .

I could not do it without help from this forum.

Thanks to all