upload csv to database

[nagasea]

Anybody know how to do this (upload csv to database), I know I can use phpMyAdmin (insert file) to do this task. But I'm prefer to create one because I want to add some features to work with my current project.

[bad76]

Hi,
do af rom to submit the csv file.
Then load the file into a var and process it with explode():

 
$sep=";";
$data = file($filename);
$lun=count($data);

for($i=1; $i<($lun+1); $i++)
{
  $row=explode($sep,$data[$i]);

// now with SQL:
// insert into table '$row[0]','$row[1]','$row[2]','$row[3]'...

}