Quick CSV import (csv, csv import, import, import csv)

Name:	Quick CSV import Support forum
Base name:	`quick_csv_import`
Description:	Import CSV data into a MySQL database table
Related top rated classes:	csv, csv import, import, import csv
Version:	`-`
Required PHP version:	`-`
License:	BSD License
All time users:	9309 users
All time rank:	69
Week users:	79 users
Week rank:	33

	Screenshots		Author		Groups		Detailed description

	User ratings		Trackback		Applications		Related links		Files

Screenshots

File	Role	Description
`csv.png`	Screen	Screenshot of an example at work

Author

Name:	Alexander Skakunov is available for providing paid consulting. Contact Alexander Skakunov .
Published packages:	8 Browse this author's classes
Country:	Ukraine - PHP jobs in Ukraine
Home page:	`http://i1t2b3.com/`
Age:	27
All time rank:	67
Week rank:	33

Groups

PHP 5	Classes using PHP 5 specific features	View top rated classes
Databases	Database management, accessing and searching	View top rated classes
Files and Folders	Listing, accessing and manipulating files and folders	View top rated classes

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.

User ratings

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Sufficient (70.0%)`	`Sufficient (73.3%)`	`-`	`Sufficient (68.3%)`	`-`	`-`	`Not sure (49.2%)`	1282
Month:	Not yet rated by the users

Trackback links

Link	Description
CSV to MySQL	Salah satu format data yang masih banyak dipakai adalah Comma Separated Value (CSV)...
parsing csv file with php and inserting into mysql database	As some of my posts they usualy start by a question on a forum i write ( you can find them in the about page )...
Quick CSV import with visual mapping	Several years ago I created PHP class Quick_CSV_Import to import CSV files to a database table very quickly (LOAD DATA INFILE statement)...
Quick work with data files	Familiar programist described how he gave the draft, where it was necessary to speed up the work site, made by fellow Hindus...

Latest blog trackback links

Applications that use this class

Link	Description
Dobrotvor	entertaining education
Rival Alert	Rival Alert
The endless art	my blog (Russian)
developers.org.ua	Society of ukrainian developers
Fun Era	Find lots of fun and entertainment
I wanna be developer project	(Russian)
I want to be free	My tech blog
Koodix	Your little database
zillion	(Russian)
devcon.org.ua	devcon.org.ua

If you know an application of this package, send a message to the author to add a link here.

Files

File	Role	Description
`Quick_CSV_import.php`	Class	Quick_CSV_import class
`Quick_CSV_import_example.php`	Example	Class using example
`example.csv`	Data	Example source of CSV file

Download all files: quick_csv_import.tar.gz quick_csv_import.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: Quick CSV import