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

Valerio Giuffrida

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: 37
All time rank: 81130 in Italy Italy
Week rank: 195 Up8 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
Downloadcsv2sql-2006-02-12.zip 2KB
Downloadcsv2sql-2006-02-12.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,834
This week:0
All time:2,146
This week:488Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.