Jump to content

csv upload to mysql using php and html form


nade93

Recommended Posts

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?

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.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.