Hi guy's,
I wanted to insert a text file into a table through a php script but it seems to be wrong some where else..
upload.php
if(!$userfile && !$submit)
{
print "<TABLE border=\"1\" bordercolor=\"#000000\" cellpadding=\"10\" cellspacing=\"10\" align=\"center\">
<TR bgColor=\"#aaccff\">
<TH>DUMP-SCHEMA</TH>
</TR>
<TR bgColor=\"800000\">
<TD align=\"center\"><FONT COLOR=CYAN><b>Select Any CSV/TAB_DEL TEXT FILE</b></FONT></TD>
</TR>
<TR><TD>
<FORM enctype=multipart/form-data method=\"post\" action=\"options.php\">
<INPUT type=\"file\" name=\"userfile\">
<INPUT type=hidden name=MAX_FILE_SIZE value=125000><BR>
</TD>
</TR>
<TR><TD><input type=\"text\" name=\"terminated\" size=\"1\" maxlength=\"2\"> : <b>Fields Terminated By</b></TD>
</TR>
<TR bgColor=\"CYAN\">
<TD align=\"center\">
<INPUT TYPE=\"SUBMIT\" NAME=\"submit\" VALUE=\"SUBMIT\" onmouseover=\"javascript:this.style.backgroundColor='#ffffff'; javascript:this.style.color='#7E93AA';\" style=\"COLOR: #ffffff; BACKGROUND-COLOR: #7E93AA\" onfocus=\"javascript:this.blur()\" onmouseout=\"javascript:this.style.backgroundColor='#7E93AA'; javascript:this.style.color='#FFFFFF';\"></TD>
</FORM>
</TR>
</TABLE>
<body bgproperties=\"fixed\" background=\"./images/TECHBOOKS.bmp\"></font></b> ";
}
if($submit)
{
$term =addslashes($terminated);
$dump_query= "LOAD DATA infile \"$userfile\" INTO TABLE job_information FIELDS TERMINATED BY \"$terminated\"";
$dump_query = stripSlashes($dump_query) ;
$dump_query=trim($dump_query);
if(!mysql_query($dump_query,$dbLink))
print mysql_error();
}
?>
============
Error
but I'm getting error some thing like this..
File 'c:MyWebapachephpupload_tmp_dirphp4132.TMP' not found (Errcode: 2)
Thanx in advance..
