PHP Classes

csv2sql: Convert CSV files into SQL INSERT statements

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  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 (9 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,761 This week: 1All time: 2,107 This week: 1,194Up
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: 27
All time rank: 76329 in Italy Italy
Week rank: 953 Down46 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,761All time:2,107
 This week:1This week:1,194Up