phpMyEdit: MySQL MyISAM Table Editor or PHP / HTML Form Generator

phpMyEdit is a mature Open Source programming utility which you might call a MySQL™ table editor, form generator, or PHP script builder. As a mature Open Source PHP script, phpMyEdit is no longer under active development however bug fixes are occasionally applied to files residing in the phpMyEdit CVS Repository.

phpMyEdit is very powerful, saves countless hours of hand coding custom PHP / HTML forms, and works very well for what it was intended to accomplish. Most of the Feature Requests found in the phpMyEdit Forum are unlikely to be implemented anytime soon, as most requests are simply beyond the intended phpMyEdit scope.

phpMyEdit comes with a setup script which is used to create a PHP "calling script" script. The calling script works with an included PHP class file and various language files to enable interaction with the configured MySQL MyISAM database table.

Features of phpMyEdit forms include: list records, search / query records, add record, view record, change / update record, copy a record, and delete record. Most users need little else, though advanced features exist which include change log usage, triggers, and basic support for Javascript validation. Language files exist to control labels displayed on INPUT field buttons based on the language preference of the user's web browser.

phpMyEdit requires MyISAM type tables having a structure such that the first column in the table (MySQL Column 0) is the primary key field (usually an auto incremented integer field).

phpMyEdit works only with MyISAM type tables (not with INNODB tables, nor tables having multiple key columns).

With some additional effort, phpMyEdit TEXTAREA fields can be made WYSIWYG using TinyMCE by downloading the mce-cal extension. Personally, I rarely need WYSISYG fields and don't feel the configuration hassle for TinyMCE is worth the effort.

phpMyEdit can be downloaded from platon.sk. After making a few forms and becoming familiar with phpMyEdit, users are encouraged to download the latest version of the class file from the phpMyEdit CVS Repository.

If the first column in your MySQL table is an auto increment integer field (or a field which otherwise contains unique values) phpMyEdit works very well for just about everyone. phpMyEdit supports many native MySQL Functions (e.g. CONCAT, FROM_UNIXTIME, DATE_FORMAT) as well as validation of user input via Javascript regular expressions.

Those of you who seek to create MySQL tables will often use either phpMyAdmin (supplied by most web hosts) or Adminer.

MySQL / PHP Form Generator

You can also save yourself a day's worth of programming and purchase the PHP Form Generator which will create all the required scripts for 100 different tables in about 30 seconds. Works with MyISAM tables where column 0 is the primary key.

Beta

10 August 2010 - Beta phpMyEdit Form Generator is not yet available for purchase.