Im trying to use a <form> through <html> to post CSV data from a TXT file to input into MySQL.. code is :
[index.html is as follows :]
<html><body>
<form action="uploaded.php" method="get" enctype="multipart/form-data">
<input type="file" name="data" />
<INPUT TYPE="submit">
</FORM></body></html>
[uploaded.php is as follows :]
<?php
$data=$_GET['data'];
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database",$db);
$sql = "LOAD DATA LOCAL INFILE '$data' REPLACE INTO TABLE data_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r' (cvsinput1, cvsinput2)";
$result = mysql_query($sql);
?>
error im getting when running through browser i get :
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /location/uploaded.php on line 5
any help would be greatly apreciated, Thanks in Advance !!
