TM::MyCSV (csv, File Manager, CSV export, export csv)

Name:	TM::MyCSV Support forum
Base name:	`mycsv`
Description:	Manage CSV files like database tables
Related top rated classes:	csv, File Manager, CSV export, export csv
Version:	`-`
Required PHP version:	`4.0.5`
License:	Free for non-commercial use
All time users:	686 users
All time rank:	3140
Week users:	3 users
Week rank:	2392

	Screenshots		Author		Groups		Detailed description

	User ratings		Dependencies		Applications		Related links		Files

Screenshots

Editing the CSV text files table structure in the Administrator.

File	Role	Description
`MyCSVAdmin_Structure.png`	Screen	Editing the CSV text files table structure in the Administrator.
`MyCSVAdmin_Edit_with_Join.png`	Screen	Editing a CSV table row in the Administrator with a join (lookup) to another CSV table.

Author

Name:	Thiemo Mättig `<e-mail contact>`
Published packages:	2 Browse this author's classes
Country:	Germany - PHP jobs in Germany
Home page:	`http://maettig.com/`
Age:	33
All time rank:	217
Week rank:	564

Innovation Award

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

Groups

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

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.

User ratings

Not yet rated by the users

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.

If you know an application of this package, send a message to the author to add a link here.

Files

File	Role	Description
`ChangeLog.txt`	Doc.	Change log
`example_filter.php`	Example	How to search in a CSV table
`example_mysql_to_csv.php`	Example	How to dump a MySQL table into CSV
`example_products.php`	Example	How to create and sort tables, insert and delete rows
`MyCSV.class.php`	Class	Main class
`MyCSVAdmin`
`ChangeLog.txt`	Doc.	Administrator Change Log
`index.php`	Appl.	Administrator Main Script and Configuration
`MyCSVAdmin.class.php`	Class	Administrator Main Class
`MyCSVAdmin_manual.html`	Doc.	Administrator Manual and API reference
`MyCSV_manual.html`	Doc.	Manual and API reference
`MyCSV_MySQL.class.php`	Class	Extended Class
`test.php`	Test	PHPUnit 1 Unit Test

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.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: TM::MyCSV

Innovation Award