PHP Classes

csv2sql: Convert CSV files into SQL INSERT statements

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,834 All time: 2,146 This week: 488Up
Version License Categories
csv2sql 1.0.0GNU General Publi...Databases, Files and Folders
Description 

Author

This class can be used to convert CSV (Comma Separated Values) files into SQL INSERT statements.

It can parse a CSV file to extract the field names from the first file line and the data to insert from the remaining lines.

It generates SQL INSERT statements using the field names and data from the parsed CSV file lines.

The list of SQL INSERT statements can be returned as an array or stored in a given output file.

Picture of Valerio Giuffrida
Name: Valerio Giuffrida <contact>
Classes: 2 packages by
Country: Italy Italy
Age: 36
All time rank: 81130 in Italy Italy
Week rank: 128 Up3 in Italy Italy Up

  Files folder image Files (3)  
File Role Description
Plain text file csv2sql.class.php Class Class csv2sql
Accessible without login Plain text file example.php Example How to use csv2sql class
Accessible without login Plain text file test.csv Data CSV example file

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,834
This week:0
All time:2,146
This week:488Up