Zend Certified Engineer

phpguru.org

Quality PHP, Javascript and C# code
Download RGraph: HTML5 canvas graph library... Home ~ Downloads ~ FAQs ~ Licensing
RSS Feed RSS Feed
Follow me on Twitter Follow me on Twitter

Articles

HTML5

Javascript

PHP5

PHP4


Bookmark with delicious Stumble! this site tweet this site

Table Editor Comparison

Everybody loves a good table editor. Right? Well perhaps not, but they do however save you an ass load of time when it comes to providing GUIs for "punters". Personally, when I was looking round for a decent one, I couldn't find one that did everything I wanted so I ended up doing the usual thing, and wrote it myself. Not everyone wants to do that though, so since I'm such a nice guy, here's a comparison of the feature sets of a few common ones. Hopefully unbiased, but lets face it, mines the best. :-)

Bear in mind that it's not an exhaustive list, but most of the major features are listed. Any omissions or errors, let me know.

Feature Comparison

Feature MySQL TableEditor phpMyEdit dbPerceptor
Type Library Library Application
License PHPGuru GPL GPL
PHP Version 4.3+ 4.1.2+ 4
Installation Coding Required Utility Provided Configuration Required
URL Link Link Link
Add Record Yes Yes Yes
Edit Record Yes Yes Yes
Copy Record Yes Yes No
View Record Yes Yes Yes
Delete Record Yes Yes Yes
Multiple Deletes at once Yes No Yes
Search Yes Yes No
Advanced Search Yes No No
CSV Download Yes Commercial Extension No
Enable Disable Above Functions Yes Yes Yes
File Upload No With patch & callbacks Yes
Custom Callbacks Supported Pre-Display (per column), Data Filter, Post Add/Edit/Copy/Delete Pre/Post actions via include files No
Record Paging Yes Yes Yes
Record Sorting Yes Yes Yes
Multiple Sort Fields No Yes Yes
Record Filtering Yes Yes No
Required Fields (Add/Edit) Yes Yes Yes
Custom Field Types (Add/Edit) Date/Time/Datetime, Email, Password, Bitmask Password, Calendar and Richtext HTML editing via extensions Spellcheck, Rich Text, Word Count, Calendar
Field/Column Hiding Yes Yes Yes
Multiple Nav Styles No Yes No
Look/Feel Manipulation Yes Yes Yes
Multilanguage Support No Yes No
Logging User Actions Any via Custom Callback Function MySQL Table and Email No
Foreign Key Support (ie. 1:M) Yes Yes Yes
Table Join Support Yes Yes No



RGraph: HTML5 canvas graph library

Example graph made using RGraph

If you're interested in web development, then you may also be interested in RGraph: HTML5 canvas graph library. It uses HTML5 features to produce a wide variety of graph types. Because it moves the creation of graphs from the server to the client, it can significantly reduce the load on your server and your bandwidth usage.