Read data from csv file into cakephp array

Question

I am developing an application in cakephp where I want to import the csv file and save the data into database.

So I need some help in reading csv file into an array after which I will do some validation and insert data into database.

I have searched a lot but could not find the solution.

Thanks in advance.

This might help http://stackoverflow.com/a/13558050/1226894 – Baba Mar 20 '13 at 13:47 — Baba, Mar 20 '13 at 13:47

score 5 · Accepted Answer · edited Jun 23 '14 at 19:55

5

You should use CakePHP's already-existing csv datasource in a custom model.

See here for how to use them.

Then you can just use your normal $model->find() operations on it! Simple!

edited Jun 23 '14 at 19:55

Timber

answered Mar 20 '13 at 13:48

Ivo

score 1 · Answer 2 · answered Mar 20 '13 at 13:47

1

Try with fgetcsv(), here's the doc: fgetcsv()

answered Mar 20 '13 at 13:47

ulentini

2 Answers2