CSV to SQL database converter: Import data from a CSV file into a database
| Recommend this page to a friend! |
Author
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.
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.
| Classes of Michal Palma | > | CSV to SQL database converter | > |  Download .zip .tar.gz |
> |  Support forum (4) |
> |  Blog |
> |   Latest changes |
|
|||||||||||||||
| Groups | Dependencies | Applications |  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 |
| Packages needed by this class |
| Class | Download | Why it is needed | Dependency |
|---|---|---|---|
| XML 2 Array | .zip .tar.gz |
To read XML configuration | Required |
| CSV managing class | .zip .tar.gz |
To read CSV file | Required |
| SQL databases interface | .zip .tar.gz |
To write to database (any supported by it) | Required |
| Applications that use this package |
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
| Files |
| File | Role | Description |
|---|---|---|
| config.xml |
Data | Configuration data |
| Csv2Db.class.php |
Class | Csv2Db class |
| Csv2DbCfg.class.php |
Class | Csv2DbCfg class |
| Csv2DbInterface.class.php |
Class | Csv2DbInterface class |
 readmeFirst.txt |
Doc. | Read me |
| test.csv |
Data | CSV file to testing |
| _preload.php |
Aux. | preload script |
| ___case_of_use.php |
Example | Case of use |
 Install with Composer - Download all files: csv2db.tar.gz csv2db.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-2016