Databases: Quick CSV import
Alexander Skakunov (contact me)
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.
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Sufficient (70.0%)
| Sufficient (73.3%)
| -
| Sufficient (68.3%)
| -
| -
| Not sure (49.2%)
| 1297 |
Click here for detailed information about this class on phpclasses.org
Php Handleiding