PHP Classes
elePHPant
Icontem

PHP CSV to MySQL Import: Import data from CSV files to MySQL SQL dump files

Recommend this page to a friend!
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2015-02-23 (1 year ago) RSS 2.0 feedNot enough user ratingsTotal: 278 All time: 7,175 This week: 1,068Up
Version License PHP version Categories
csv-to-mysql 1GNU Lesser Genera...5.0PHP 5, Databases, Files and Folders
Description Author

This package can import data from CSV files to MySQL SQL dump files.

It can parse a given CSV file and extract the data values to generate a file with SQL statements to insert the values in a MySQL table.

It uses a special configuration file to detect the types of the MySQL table columns.

It is also aware of MySQL reserved words, so it does not try to create table invalid field names.

The package can also execute the generated SQL statements to insert the table data in a given MySQL database.

Picture of Charles Hays
Name: Charles Hays <contact>
Classes: 1 package by
Country: United States United States

  Files folder image Files  
File Role Description
Plain text file CSVtoMySQL.php Class The main class file.
Accessible without login Plain text file regex_mysql_data.txt Data The regex mapping file to determine what mysql data type each field should be.
Accessible without login Plain text file reserved_mysql_words.txt Data A file with a list of reserved mysql words.

 Version Control Unique User Downloads Download Rankings  
 0%
Total:278
This week:0
All time:7,175
This week:1,068Up