Receiving mail, parsing an attachment - a CSV file and adding data to the database in PHP. What is the fastest way to do everything?

Question

PHP

There is a task to regularly check the mailbox to which reports are sent in CSV format and parse the data into the database. How to make it easier? It is possible to manage only IMAP? Are there lightweight CSV parsing libraries?

Answer 1

I found an excellent series of materials just on this issue: www.electrictoolbox.com/parsing-google-analytics-data-with-php/

Answer 2

In PEAR, there are no ready-made parsers: both work with mail, and a parser of everything, and work with a database with the necessary abstraction. If you don't mind of course ;-)

Answer 3

> Are there lightweight CSV parsing libraries?
en.php.net/manual/en/function.fgetcsv.php

Answer 4

MySQL can automatically load CSV files into the database
LOAD DATA INFILE
dev.mysql.com/doc/refman/5.1/en/load-data.html
(didn't use it in practice, check it out)

Answer 5

I think I'll try the imap functions and fgetcsv first.