How do i use the LOAD DATA INFILE

[natman3]

I must first create a form with <input type="file" but how do i use the script in load data infile to create a .php page text box with a browse button to select the file.

[leatherback]

Hey Natman,

Maybe this can help? (It does need some tinkering: It is part of a larger script I wrote a while back)

$directory = "uploads/"; 

if ($file) { 
    $fileName = "$date" . "_" . "$file_name"; 
    if (copy($file, $directory . $file_name)) { 
        print "your file <B>" . $file_name . " (" . $file_size . " kb)</B> was successfully uploaded"; 
        unlink($file); 
    } 
    else { 
        print "your file could not be uploaded"; 
    } 
} 

print " 
<FORM ACTION=\"" . $PHP_SELF . "\" METHOD=\"POST\" enctype=\"multipart/form-data\"> 
upload file: 
<INPUT TYPE=\"file\" NAME=\"file\" SIZE=\"20\"><BR> 
<INPUT TYPE=\"SUBMIT\" NAME=\"SUBMIT\" value=\"upload file\"> 
</FORM> 
";