Login   Register  
PHP Classes
elePHPant
Icontem

Quick CSV import: Import CSV data into a MySQL database table

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Alexander Skakunov
Name: Alexander Skakunov is available for providing paid consulting. Contact Alexander Skakunov .
Classes: 8 packages by
Country: Ukraine Ukraine
Age: 32
All time rank: 281 in Ukraine Ukraine
Week rank: 27 Up1 in Ukraine Ukraine Equal
Innovation award
Innovation award
Nominee: 2x

Winner: 1x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Alexander Skakunov  >  Quick CSV import  >  Download Download .zip .tar.gz  >  Support forum Support forum (32)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Quick CSV import
Base name: quick_csv_import
Description: Import CSV data into a MySQL database table
Version: 1.0.0
PHP version: 3
License: BSD License
All time users: 21092 users
All time rank: 26
Week users: 18 users
Week rank: 34 Down
 
  Groups   Screenshots Screenshots   Rate classes User ratings  
  Trackback   Applications   Related pages   Files Files  

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

  Files folder image Screenshots  
csv.png
File Role Description
Accessible without login Image file csv.png Screen Screenshot of an example at work


  Recommendations  

What is the best PHP class to extract recipients from CSV file?
I need to parse a .csv emails address list and send a message


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (70%) Sufficient (70%) - Sufficient (71%) - - Not sure (49%) 1685
Month: Not yet rated by the users

  Pages that reference this package  
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 pages that reference packages Latest pages that reference packages


  Applications that use this package  
Dobrotvor
entertaining education
Rival Alert
Rival Alert
The endless art
my blog (Russian)
developers.org.ua
Society of ukrainian developers
I wanna be developer project
(Russian)
I want to be free
My tech blog
Koodix
Your little database
SunnyRentals
Feel like home when you travel
zillion
(Russian)
devcon.org.ua
devcon.org.ua
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related pages  
Quick Import with Visual Mapping
Example application that imports CSV file to database table with visual mapping of CSV columns to table columns
I want to be free
My tech blog

  Files folder image Files  
File Role Description
Plain text file Quick_CSV_import.php Class Quick_CSV_import class
Accessible without login Plain text file Quick_CSV_import_example.php Example Class using example
Accessible without login Plain text file example.csv Data Example source of CSV file

Install with Composer Install with Composer - Download 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.