Login   Register  
PHP Classes
elePHPant
Icontem

Class: TM::MyCSV

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Thiemo Mättig  >  TM::MyCSV  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog (1)  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: TM::MyCSV
Support forum Support forum
Base name: mycsv
Description: Manage CSV files like database tables
Related classes: , , , , , , ,
Version: -
PHP version: 4.0.5
License: Free for non-commercial use
All time users: 960 users
All time rank: 3065
Week users: 1 user
Week rank: 2467
Picture of Thiemo Mättig
Author: Thiemo Mättig <e-mail contact>
Packages: 2 Browse this author's classes Browse this author's classes
Country: Germany Germany - PHP jobs in Germany
Age: 35
All time rank: 26414 in Germany Germany
Week rank: 1634 Down93 in Germany Germany Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x


  Detailed description  
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.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Files and Folders Listing, accessing and manipulating files and folders View top rated classes
Group folder image Content management Components and tools to manage content View top rated classes

  Screenshots Screenshots   Rate classes User ratings   Dependencies  
  Applications   Related links   Files Files  
  Files folder image Screenshots  
Editing the CSV text files table structure in the Administrator.
File Role Description
Accessible without login Image file MyCSVAdmin_Structure.png Screen Editing the CSV text files table structure in the Administrator.
Accessible without login Image file MyCSVAdmin_Edit_with_Join.png Screen Editing a CSV table row in the Administrator with a join (lookup) to another CSV table.


  Innovation Award  
PHP Programming Innovation award winner
August 2009
Winner
 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

  User ratings  
There are not enough user ratings to display for this class.

  Packages needed by this class  
Class Dependency Why it is needed
TM::Apeform
Conditional
 Only for the Administrator class and script, to display all the forms.

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
Official website of the TM:MyCSV class Detailed description and examples for the class on my personal website

  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
Plain text file MyCSV.class.php Class Main class
Accessible without login HTML file MyCSV_manual.html Doc. Manual and API reference
Plain text file MyCSV_MySQL.class.php Class Extended Class
Accessible without login Plain text file test.php Test PHPUnit 1 Unit Test

  Files  /  Files folder image 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
  Plain text file MyCSVAdmin.class.php Class Administrator Main Class
  Accessible without login HTML file MyCSVAdmin_manual.html Doc. Administrator Manual and API reference

Download all files: mycsv.tar.gz mycsv.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.