Login   Register  
PHP Classes
elePHPant
Icontem

csv2sql: Convert CSV files into SQL INSERT statements

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-02-12 (8 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,740 This week: 1All time: 2,090 This week: 1,442Up
Version License Categories  
csv2sql 1.0GNU General Public Lice...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: 26
All time rank: 75129 in Italy Italy
Week rank: 1116 Down49 in Italy Italy Down

  Files folder image Files  
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

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,740All time:2,090
 This week:1This week:1,442Up