TM::MyCSV: Manage CSV files like database tables

Recommend this page to a friend!

  Author  
Picture of Thiemo Kreuz
Name: Thiemo Kreuz <contact>
Classes: 2 packages by
Country: Germany Germany
Age: 43
All time rank: 27613 in Germany Germany
Week rank: 246 8 in Germany Germany
Innovation award
Innovation award
Nominee: 1x

Winner: 1x


  Detailed description   Download .zip .tar.gz   Install with Composer  
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.

  Classes of Thiemo Kreuz  >  TM::MyCSV  >  Download .zip .tar.gz  >  Support forum  >  Blog (1)  >  Latest changes  
Name: TM::MyCSV
Base name: mycsv
Description: Manage CSV files like database tables
Version: 1.0.0
PHP version: 4.0.5
License: Free for non-commercial use
All time users: 1822 users
All time rank: 2139
Week users: 1 user
Week rank: 242
 
  Groups   Screenshots   User ratings  
  Dependencies   Applications   Related pages   Files  

  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

  Screenshots  
MyCSVAdmin_Structure.png
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.


  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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Perfect (100%) Perfect (100%) Good (93%) Good (93%) Sufficient (68%) - Good (85%) 6
Month: Not yet rated by the users

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

  Applications that use this package  
No pages of applications that use this class were specified.

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


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

  Files  
File Role Description
MyCSVAdmin (4 files)
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
MyCSV_manual.html Doc. Manual and API reference
MyCSV_MySQL.class.php Class Extended Class
test.php Test PHPUnit 1 Unit Test

  Files  /  MyCSVAdmin  
File Role Description
   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

Install with Composer - 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.

For more information send a message to info at phpclasses dot org.