PHP Classes

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

Recommend this page to a friend!
     
  Info   Screenshots Screenshots   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (34)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 50%Total: 23,001 This week: 2All time: 24 This week: 78Down
Version License PHP version Categories
quick_csv_import 1.0.0BSD License3PHP 5, Databases, Files and Folders
Description Author

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.

Recommendations

Read huge Excel file
Read excel file of min 43MB and export values to MySQL

Import Excel CSV into MySQL table
I want to import CSV file to MySQL table

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

Picture of Alexander Skakunov
Name: Alexander Skakunov is available for providing paid consulting. Contact Alexander Skakunov .
Classes: 9 packages by
Country: Ukraine Ukraine
Age: 40
All time rank: 232 in Ukraine Ukraine
Week rank: 190 Down3 in Ukraine Ukraine Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

Screenshots  
  • csv.png
  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

Downloadquick_csv_import-2006-08-23.zip 26KB
Downloadquick_csv_import-2006-08-23.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:23,001
This week:2
All time:24
This week:78Down
User Ratings User Comments (8)
 All time
Utility:72%StarStarStarStar
Consistency:71%StarStarStarStar
Documentation:-
Examples:71%StarStarStarStar
Tests:-
Videos:-
Overall:50%StarStarStar
Rank:2321
  

  Applications that use this package  
Zero to Hero
entertaining education
The endless art
my blog (Russian)
I wanna be developer project
(Russian)
I want to be free
My tech blog

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


  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

For more information send a message to info at phpclasses dot org.