Topic: Uploading multiple CSV files to MySQL database?

[kr33]

Hi,

Does anyone know how to upload multiple CSV files to a MySQL database?

I have a database setup in MySQL(i used myphpadmin), which already contains four tables.

I am developing a webpage using PHP, that needs to allow a user to upload (thus far) 8 CSV files which will be imported into the database, BUT these imports will be temporary, since i only need selected data/columns from each of the 8 CSV files. The selected columns will then be imported into the "MAIN" table, from which I extract data to draw graphs.

My question is...How do I upload these files, using PHP, temporarily so that I may extract the required data and replace the the old data/columns in the main table, the main table stores only the data needed for the graphs to be drawn. Thereafter, once I have "updated" the main table, the temporary tables can be deleted.

Please help ASAP...ANYONE!!!!

Much Thanks

[James Blond]

Windows scheduler?

Better solution would be deleting the file with the script you importing the files or do you use phpmyadmin to import?

maybe you create the temporary table
CREATE TEMPORARY TABLE pn_nr SELECT personalnummer FROM `table` .....

$new = "new value";
$strSQL3 = "UPDATE `table` SET `something` ='" . $new . "' WHERE `id` = " . $id_from_csv;

[kr33]

I think the temporary tables would be the best option.

Do you know where I can find examples and tutorials on using temporary tables?

And I will need to replace/update WHOLE columns of data.

Any Help?

And How would I import the CSV files using actual PHP code and NOT phpmyadmin (the CSV files are comma delimited)

Thanks

[James Blond]

To import the csv file see http://pear.php.net/search.php?q=csv&in=packages&x=5&y=5

Don't know which of these two packs I used...