[El Forum]

[eluser]yagie[/eluser]
Can someone help me how to import CSV file into database including mapping using Codeigniter?

I don't know how. I'm looking for the example but I haven't found it.

Thanks..

[El Forum]

[eluser]Clooner[/eluser]
You could use fgetcsv to read the csv file and then run a foreach and insert each row using AR.

Code:

$data = fgetcsv($filehandle)
foreach ($data as $item)
   $this->db->insert('table', array('id' => $item[0], 'name' => $item[1]));

[El Forum]

[eluser]Clooner[/eluser]
Actually this is not how it works when I think about it. You'll be able to find how to use fgetcsv on php.net manuals!

[El Forum]

[eluser]yagie[/eluser]
Thanks Clooner for your replay. I used library for csv (csvreader). And then, I combined it with the code "foreach" you give and it works..