PHP Classes

TM::MyCSV: Manage CSV files like database tables

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (12)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Ratings Unique User Downloads Download Rankings
StarStarStarStarStar 85%Total: 1,932 All time: 2,039 This week: 117Up
Version License PHP version Categories
mycsv 1.0.0Free for non-comm...4.0.5Databases, Files and Folders, Content...
Description 

Author

This package can be used to manage CSV text files like database tables. The class combines most benefits of SQL tables and PHP arrays including a powerfull method for sorting rows.

The class manages CSV files with support for storing, retrieving and deleting rows of data and also to add and remove columns from those files.

Inserted row identifier column values may be auto-incremented. The row retrieval is binary safe, may obey a given column sorting criteria similar to SQL ORDER BY clause, limit the number of retrieved rows similar to LIMIT clause, and support joins like with SQL LEFT OUTER JOIN.

A separate sub-class allows importing and exporting data to MySQL database tables.

Another class can generate a HTML forms based administration interface for accessing and editing data from a directory of CSV files, as well as alter their columns.

Innovation Award
PHP Programming Innovation award winner
August 2009
Winner


Prize: One copy of the Zend Studio
PHPMyAdmin is an application that became very popular because it provides a Web based user interface to let the users manager MySQL databases used by PHP Web sites.

This package provides a similar Web based user interface for managing data in CSV files.

Manuel Lemos
Picture of Thiemo Kreuz
  Performance   Level  
Name: Thiemo Kreuz <contact>
Classes: 2 packages by
Country: Germany Germany
Age: 47
All time rank: 27512 in Germany Germany
Week rank: 387 Down15 in Germany Germany Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Screenshots  
  • MyCSVAdmin_Structure.png
  • MyCSVAdmin_Edit_with_Join.png
  Files folder image Files  
File Role Description
Files folder imageMyCSVAdmin (4 files)
Accessible without login Plain text file ChangeLog.txt Doc. Change log
Accessible without login Plain text file example_filter.php Example How to search in a CSV table
Accessible without login Plain text file example_mysql_to_csv.php Example How to dump a MySQL table into CSV
Accessible without login Plain text file example_products.php Example How to create and sort tables, insert and delete rows
Accessible without login Plain text file MyCSV.class.php Class Main class
Accessible without login HTML file MyCSV_manual.html Doc. Manual and API reference
Accessible without login Plain text file MyCSV_MySQL.class.php Class Extended Class
Accessible without login Plain text file test.php Test PHPUnit 1 Unit Test

  Files folder image Files  /  MyCSVAdmin  
File Role Description
  Accessible without login Plain text file ChangeLog.txt Doc. Administrator Change Log
  Accessible without login Plain text file index.php Appl. Administrator Main Script and Configuration
  Accessible without login Plain text file MyCSVAdmin.class.php Class Administrator Main Class
  Accessible without login HTML file MyCSVAdmin_manual.html Doc. Administrator Manual and API reference

Downloadmycsv-2009-09-02.zip 77KB
Downloadmycsv-2009-09-02.tar.gz 76KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
TM::Apeform Download .zip .tar.gz Only for the Administrator class and script, to display all the forms. Conditional
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,932
This week:0
All time:2,039
This week:117Up
 User Ratings  
 
 All time
Utility:100%StarStarStarStarStarStar
Consistency:100%StarStarStarStarStarStar
Documentation:93%StarStarStarStarStar
Examples:93%StarStarStarStarStar
Tests:68%StarStarStarStar
Videos:-
Overall:85%StarStarStarStarStar
Rank:6