I'm trying to create a page using php and mysql where users can upload a csv file.
I've written the code below which doesnt seem to work.
Can anyone help me????
<?
include("connectdb.php");
?>
<BODY>
<?
if (isset($submit))
{
$sql = "LOAD DATA LOCAL INFILE '$uploadedfile' INTO TABLE category FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";
$result = mysql_query($sql);
if($result > 0)
{
echo "<center><h1>Upload Successful</h1></center>";
}
else
{
echo "<center><h1>Upload Failed</h1><p> Could not upload file $uploadedfile</center><p>";
echo "$sql";
}
}
else {
?>
<FORM NAME="form1" ACTION="<?php echo "$PHP_SELF"; ?>" METHOD="post" enctype="multipart/form-data">
<P>Select file to upload: <INPUT TYPE=FILE NAME="uploadedfile" value=http://www.phpbuilder.com/board/archive/index.php/""></P>
<P><INPUT TYPE=SUBMIT NAME="submit" VALUE="Submit"></P>
</FORM>
<? } ?>
</BODY>
I've written the code below which doesnt seem to work.
Can anyone help me????
<?
include("connectdb.php");
?>
<BODY>
<?
if (isset($submit))
{
$sql = "LOAD DATA LOCAL INFILE '$uploadedfile' INTO TABLE category FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'";
$result = mysql_query($sql);
if($result > 0)
{
echo "<center><h1>Upload Successful</h1></center>";
}
else
{
echo "<center><h1>Upload Failed</h1><p> Could not upload file $uploadedfile</center><p>";
echo "$sql";
}
}
else {
?>
<FORM NAME="form1" ACTION="<?php echo "$PHP_SELF"; ?>" METHOD="post" enctype="multipart/form-data">
<P>Select file to upload: <INPUT TYPE=FILE NAME="uploadedfile" value=http://www.phpbuilder.com/board/archive/index.php/""></P>
<P><INPUT TYPE=SUBMIT NAME="submit" VALUE="Submit"></P>
</FORM>
<? } ?>
</BODY>