CSV to mysql databse!!!

[eluser]Rabbi[/eluser]
I want to know, is there any method or way to convert CSV file to mysql with CodeIgniter?

I know it with phpMyAdmin. But i want to know with CodeIgniter, is it possible?

Please tell me.

[eluser]Developer13[/eluser]
Yes of course it's possible.

[eluser]EEssam[/eluser]
I think you should code the good part of that yourself, however it's pretty easy.

[eluser]Randy Casburn[/eluser]
It is a MySQL SQL statementLOAD DATA INFILE

Very simple.

Randy

[eluser]Rabbi[/eluser]
Ok thanks everybody.
Can you show me, how to do it in CodeIgniter?

[eluser]Pascal Kriete[/eluser]
Here's a quote from what Randy posted:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Then check out this user guide page and put 2 and 2 together.

[eluser]Rabbi[/eluser]
Thanks got it now.

[eluser]marcoss[/eluser]
WTF! Use MySQL to import a CSV? how would you debug that? validate data? split large files? etc, etc, etc.

Data should be validated before being used in a database, use one of the many CSV parsers available and prepare your data first.

I would recommend http://code.google.com/p/parsecsv-for-php/, does what it says and supports PHP 4/5.