Class: Quick CSV import

This class can be used to import data from CSV (Comma Separated Value) files into a given MySQL database table.

It parses a given CSV file to extract the field names. Then it imports the data into the MySQL database using a LOAD DATA INFILE query to import the data in a much faster way than using SQL INSERT queries.

If necessary, the class can also create the database table using the CSV file headers to retrieve the table field names.

UPDATE: From now you can set the encoding table which is used to parse the file.

Salah satu format data yang masih banyak dipakai adalah Comma Separated Value (CSV)...

As some of my posts they usualy start by a question on a forum i write ( you can find them in the about page )...

Familiar programist described how he gave the draft, where it was necessary to speed up the work site, made by fellow Hindus...

Society of ukrainian developers

Find lots of fun and entertainment

Your little database

My tech blog

Quick_CSV_import class

Class using example

Example source of CSV file