PHP Classes

csv2sql: Convert CSV files into SQL INSERT statements

Recommend this page to a friend!
  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 (10 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,775 All time: 2,135 This week: 1,002Up
Version License Categories
csv2sql 1.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: 28
All time rank: 77331 in Italy Italy
Week rank: 1587 Down71 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  
This week:0
All time:2,135
This week:1,002Up