PHP CSV to Data Dictionary: Generate data dictionary from CSV file

Class: csvdict
Version: 1.0 5/15/2015

Copyright 2015 Wagon Trader

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.


Description:

This class generates a data dictionary from data supplied in a csv file.

It can display a human readable data dictionary.

It can return the SQL query statement to create the database table.

It can return the SQL query statements to insert the data into the table.


Files:

csvdict.class.php - Main class

example.php - Example usage script

sample.csv - Sample csv file


Installation:

Upload files to a web accessible location on your server (eg. public_html)


Configuration:

The class is configured to work with most server configurations.


Usage:

The included example.php file includes examples on instantiating the class and basic operation instructions.

Complete method usage is documented in the class.