[SOLVED] Uploading CSV file to MySQL database

[jeeves245]

Hey guys, another question

 

I currently use this code to open a CSV file (from a folder on the server) and insert it into a database:

 

$file_handle = fopen("file.csv", "rb");

while (!feof($file_handle) ) {
$line_of_text = fgets($file_handle);
$parts = explode(',', $line_of_text);

 

Then the SQL querys come after that.

 

How hard would it be to modify that to upload the CSV file using a form? (I.e. browse to the file on the computer and submit it).

I don't want the whole file just to be chucked in the database though, I need the code to save pieces into an array like the above code does.

 

I've done a lot of research on Google but most pre-made scripts are too complex for my needs.

 

Would this be hard to do?

 

Thanks in advance.

[abazoskib]

no it is not hard. http://www.tizag.com/phpT/fileupload.php

[jeeves245]

Thanks for the link.. will have a look.