Quick CSV import: Import CSV data into a MySQL database table
ReTweet Author |
 |
|
Innovation award Nominee: 3x 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.
| Classes of Alexander Skakunov | > | Quick CSV import | > |  Download .zip .tar.gz |
> |  Support forum (34) |
> |  Blog |
> |   Latest changes |
|
|
|
||||||||||||||
| Groups |  Screenshots |
Trackback |
| Applications | Related pages |  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 |
| 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
| 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
| 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 |
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 |
| 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 |
 Install with Composer - Download all files: quick_csv_import.tar.gz quick_csv_import.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
For more information send a message to
info at phpclasses dot org.Copyright (c) Icontem 1999-2017