bulk insert into mysql (CSV file-Codeigniter)

I need function or code for bulk insert categories into mysql data开发者_StackOverflow中文版base.I am using codeigniter for my project.

---

START TRANSACTION;

DELETE FROM `mytable`;

LOAD DATA INFILE '/var/www/something.csv'
INTO TABLE `mytable`
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ''
LINES TERMINATED BY '\r\n'
(email, login, pass)

COMMIT;

this can be run directly in mysql to import data from a CSV