csv upload to mysql using php and html form

[nade93]

Hi All

 

I am trying to upload a csv file to a database using php html form however, the results shows none of the data passsing through to the database and it produces 1000's of empty fields

 

here is the form

 

form action="lib/import.php" method="post" enctype="multipart/form-data">

     Type file name to import:

      <input type="file" name="filename" size="20"><br />

      <input type="submit" name="submit" value="submit"></form>

 

and here is the passing info

 

$file = $_FILES['filename'];

$sqlstatement="LOAD DATA INFILE '$file' into TABLE shop FIELDS TERMINATED BY ',' (id, merchant_name, product_name, description, category_name, Affiliate_deep_link, Affiliate_image_url, price)" ;
mysql_query($sqlstatement);
echo "it is done!"; 

 

can anyone help please?

[Buddski]

You will find that $_FILES['filename'] is actually an array.

Containing these keys:

name

type

size

tmp_name

error

 

http://www.php.net/manual/en/features.file-upload.post-method.php

 

tmp_name is the location on your server that contains the actual file.