Quick CSV import
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Classes of Alexander Skakunov | > | Quick CSV import | > | Download .tar.gz .zip | > |  Support forum (29) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||||
| Author | ||
 |
|
Innovation award Nominee: 2x Winner: 1x | |||||||||||||||||||
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.
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.
| Groups |  Screenshots |
 User ratings |
||||
| Trackback | Applications | Related links |  Files |
|||||
| 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 |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| 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... |
| 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 |
| 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 |
If you know an application of this package, send a message to the author to add a link here.| Related links | ||
| Link | Description |
|---|---|
| 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 |
||
| 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 |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2012