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
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
