Databases: CSV to SQL database converter
Michal Palma (contact me)
This package can be used to import data stored in CSV files into a database.
The main class can import the data into a table named by imported CSV-file name. Table in database is like image of CSV file, query "DROP TABLE IF EXISTS `<CSV-filename>`" is called before table creation!
The types of the columns and other details can be defined in a separate configuration XML file. This package comes with one class that can parse and extract the configuration details.
The import class uses an external package to provide DBMS independent access to the database in order to store the imported data.
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Good (91.7%)
| Good (91.7%)
| Sufficient (75.0%)
| Good (83.3%)
| -
| -
| Sufficient (70.8%)
| 132 |
Click here for detailed information about this class on phpclasses.org
Class
Csv2DbInterface class
Php Handleiding