NYCPHP Meetup

[Daniel Convissor]

On Mon, Mar 26, 2007 at 07:58:50PM +0530, Aniesh joseph wrote:
> 
> I have to read large CSV file upto 10 MB size. I tried to read each line by
> using getcsv() method, but cannot worthy. I have to make some checking the
> contents of the CSV files such as any duplicate row, or any row missing
> contents etc.

getcsv() is the way to go.  As you read each line, check it for sanity 
then run an insert or update query.  The query can be designed to 
gracefully handle duplicates.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409