PHPMyEdit is a code generator, written as a set of PHP scripts, and provided and maintained as open source.
PHPMyEdit is free and open source under a GNU: General Public License, but there are commercial licenses available if you need one. Commercial licenses can be bought for a yearly rate or a flat rate that gives you a permanent commercial license.
As an essentially free PHP code generator, it does not have as many features as other paid tools, but it can still be a useful tool for generating PHP code for MySQL databases. There isn’t any built-in system for designing layouts, so you’ll need to create your own templates if you intend to use the code on a public website. For internal business use, this probably isn’t necessary.
Features of PHPMyEdit include:
- The ability to add, copy, delete and edit records
- Table lookup, sorting, paging and filtering
- Logging of user actions
- Different levels of user permissions
- Use of a number of navigation styles and the ability to change them using CSS
- Download and unpack. Position the code as a standalone project.
- Execute host/phpMyEditSetup.php, and complete the configuration information.
- Simple, straight-forward implementation
- Small code base, no dependency entanglements; making integration easier
- Conceptually fits well with the desired functionality, five primary PHP modules to encapsulate and extend the use case for user/owner/developer/blacksmith comprehension via Table-driven MDA:
- CRUD functionality based on understanding table specifications from the table
- CRUD table class generator
- Table report module
- Table information slider
- Calendar Popup extension
- System is designed as a sourdough starter, boot-strapping facility, which can be driven as a sub-routine, and can be extended polymorphically
- Open Source
- Usage Documentation (PDF, HTML and XXX Manuals)
- Language Translations
- Out of date code (deprecated functions), needs SQL API upgrade
- Errors tend to ignored; they need exposure, or fail-safe handling
Discovery Test => Driver Plan
- Use as the basis for the MDA development of BATSG1.v5.2020 as a PHP core modeling environment
- Code / define the Wentworth table structure in a manner which is recognizable and traced to R.C. Wentworth, BATSG1.
- Use PHPMyEdit code as the basis for the MVC table maintenance and reports
- Extend the report system to maintain model state as AIR Documents in EATS Sessions
- Use AIR DOM structures to extend the front-end as an EATS MDA driven dialog system
- QED, round trip integration into core
- Extend the concept for the meta model
- Extend again for the other models
- GPL license affects how the code can be sliced and diced for integration, and consequences for downstream.
- Solution: EATS can be EPL for Java, GPL for PHP; that is not a big issue. The issue is mix and match; and GPL has attitudinal issues.
- Try “simplistic” translation
- Code is written for compactness, not expressiveness, which creates a challenge.
- Code plays with DBA level understanding of database system, which adds to obfuscation of process.
- SQL to SQLi migration moves flag values from text to bit-switches, which are not well documented, which adds to complexity.
- There is a reason nobody’s touched this for a while!
- Try for a more integrative, rather than hands-off, conversion. Code has been prepared for encapsulation as a cooperative function with other code in charge of a shared database connection. Code also needs parsing and migration to namespaces, etc.
- Use namespaces
- Extract timer class
- Use C_AF_DbWrapper, already a generic interface, as the “sql” interface mechanism.
- Incoporate code as a sub-unit of EATS framing to enable full use of class loaders, error handling, exception processing, etc.
- Retain main code concept and pattern, but for the narrow focus of “code generation”, potentially dynamically, for operations on “unkown” database tables (e.g., WordPress, Drupal tables in “foreign” environments)
“PHP Generator is a code generator that allows you to create scripts that enable you to work with tables through a web-based platform. The code generated by the tool allows you to navigate, edit, sort, filter and export data from MySQL databases. It comes with 25 templates that you can customize, and you are able to set the header and footer for all of your web pages.” My Evaluation: Confusing and troubling to use, little coherent documentation.