Zend Certified Engineer

phpguru.org

Free PHP, Javascript and C# code
Home ~ Downloads ~ FAQs ~ Search ~ Licensing ~ Forums

Blog Categories

[Index] [Popular]

Me

Recent comments

Articles

PHP5

PHP4

Javascript

C#

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 GPL 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

Link to me

If you use any of the code on this site (and if you don't I guess) or it makes your life easier, I'd appreciate a link - http://www.phpguru.org. Thanks!

RSS Feed for Comments

Comments

Author: Chris Padfield
Posted: 25th June 2005 18:59
One feature you could add that would be very nice would be AJAX style direct editing. Double click on a field and it lets you edit it. If you impelmented that in with the validation and hooks, would be amazing :)
Quote
Author: Hendy Irawan
Posted: 26th June 2005 01:09
Very cool!

Why isn't phpMyAdmin there?
Quote
Author: Richard Heyes
Posted: 26th June 2005 02:00
Hendy Irawan:
> Very cool!
>
> Why isn't phpMyAdmin there?

It doesn't fit the same category. The apps/libraries compared here are aimed at end users for managing specific tables, whereas phpMyAdmin is a database administration tool.
Quote
Author: Daniel
Posted: 29th June 2005 17:47
How about DaDaBIK from http://dadabik.org/ ?
Quote
Author: Elantrix
Posted: 20th September 2005 11:16
Richard Heyes:
> Hendy Irawan:
> > Very cool!
> >
> > Why isn't phpMyAdmin there?
>
> It doesn't fit the same category. The
> apps/libraries compared here are aimed at end
> users for managing specific tables, whereas
> phpMyAdmin is a database administration tool.

phpMyAdmin is also designed to just handle tables too. I personally never needed anything else.
Quote
Author: Vince
Posted: 19th October 2005 14:18
>> phpMyAdmin is also designed to just handle tables too. I personally never needed anything else.

Me too, but wouldn't give it to users, which is the main use of this version.
Great work.
Look forward to being able to add a CSV file upload feature ;-)
Quote
Author: Rafia alotibi
Posted: 17th November 2005 14:14
Multiple Sort Fields now is Support
if Field Type is set inputType will Be checkbox
also if Field Type is enum inputType Be will radio

View Data list
http://www.arabportal.net/TableEditor/Datalist.png

View Add/Edit Record
http://www.arabportal.net/TableEditor/EditAdd.png

Example code
http://www.arabportal.net/TableEditor/example.phps

You can get the New code
http://www.arabportal.net/TableEditor/TableEditor_New.phps
Quote
Author: Rafia alotibi
Posted: 21st November 2005 13:13
Sorry, I meant above the feature of "Multiple Field TYPE support" not "Multiple Sort Fields" so this is a correction.
Quote
Author: mattpaul
Posted: 9th June 2006 00:36
nice functionality + clean UI but I was a little disappointed to see all layout / presentation living in the same single PHP file which makes your project a tad more difficult to extend

mp
Quote
Author: Richard Heyes
Posted: 26th June 2007 11:00
mattpaul:
> nice functionality + clean UI but I was a little
> disappointed to see all layout / presentation
> living in the same single PHP file which makes
> your project a tad more difficult to extend

You could say that's an advantage. Just one file to move or copy around and very easy to keep up to date. Only having one file was very much intentional.
Quote
Author: Elantrix
Posted: 7th October 2007 19:33
Vince:
> >> phpMyAdmin is also designed to just handle
> tables too. I personally never needed anything
> else.
>
> Me too, but wouldn't give it to users, which is
> the main use of this version.
> Great work.
> Look forward to being able to add a CSV file
> upload feature ;-)

A lot of hosting companies now use PHPMyAdmin as their primary database editing tool because it easily integrates into most setups and is simple and powerful not only to the professionals, but also for the general users with little knowledge of MySQL or databases in general.
Quote
Author: Lesley
Posted: 26th October 2007 17:06
Elantrix:
> Vince:
> > >> phpMyAdmin is also designed to just
> handle
> > tables too. I personally never needed
> anything
> > else.
> >
> > Me too, but wouldn't give it to users, which
> is
> > the main use of this version.
> > Great work.
> > Look forward to being able to add a CSV file
> > upload feature ;-)
>
> A lot of hosting companies now use PHPMyAdmin
> as their primary database editing tool because
> it easily integrates into most setups and is
> simple and powerful not only to the
> professionals, but also for the general users
> with little knowledge of MySQL or databases in
> general.

Elantrix, you are totaly outside. I have used all of this "tools" to creating backend administration for sites ,witch I can provide for my users(customers) latter.
I have also working with PhpMyAdmin, but this is for webmasters (Creating Database, Export, Import, even Drop...) so this have nothing in comune with the products presented above.

Nice article ! Thanx.
Quote

Post Comment

Your name:
Your email:
(Don't worry, I won't spam you. Also, if you do put your email address in here, you'll get notified of new comments. If you don't, you won't.)
Comments:
  Do not post support type questions please
 
CAPTCHA image If you can't read the CAPTCHA then press the submit button to get another. Your comment will re-appear (as if by magic...).
Captcha image
Home ~ Downloads ~ FAQs ~ Search ~ Licensing ~ Forums
© 2005-2008 Copyright Richard Heyes
Last modified: 16:58 29th December 2006