PHP Classes

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    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 381 This week: 1All time: 6,720 This week: 560Up
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
Age: 53
All time rank: 3601477 in United States United States
Week rank: 411 Up48 in United States United States Up

  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:381
This week:1
All time:6,720
This week:560Up