TM::MyCSV: Manage CSV files like database tables
| Recommend this page to a friend! |
 Author |
 |
|
Innovation award Nominee: 1x Winner: 1x | |||||||||||||||||||
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.
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 |
|
|||||||||||||||||||||||
| 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 |
 |
|
| Innovation Award |
 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 |
| Ratings | Utility | 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 | Download | Why 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 |
| 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.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
| 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.
|
