Need script to upload csv to mysql db

[ro1960]

I'm looking for a script to upload a comma or tab separated values text file to an exisiting mysql db. I'm fairly new to PHP/mySQL.

[leatherback]

Hi,

have you looked at fgetcsv

:

function getmetadatafile($fpath, $delimiter)
{
$fp = fopen($fpath ,"r");

$i = 0;

while ($data = fgetcsv($fp, 1000, $delimiter))
  {
  $outdata[$i] = $data;
  $i++;
  }
fclose ($fp);
return $outdata;
}

?>

[ro1960]

Thanks for your prompt reply, but like I said I'm very much of a newbie and what I need is the whole solution from upload form to confirmation page. I also don't see in your script how it interacts with the database.

[leatherback]

Oh,

Hm.. THen I think you should have a look at the manual (On php.net) which has a lot of user comments.

What you would need: A form to select the right file, and submit this to a PhP file for processing.

THere:

You need to get the data about the file from the $FILES variable (Look at the content of $FILES by placing print_r($_FILES); at the begiining of the processing script).

You can use the script I gave you to retrieve the values of the file into an array, where each value is in a new array[] sub-variable.

Then you need to look at mysql_query()
for the further enetering data into the database.

J.