Lists and forms output by this application can be accessed by clicking on Sample Output

Select a database, then select a table, and then select the code to output.
Pausing your mouse over a Task in the final menu should display some tips.
Code for the selected Task will be both displayed and written to disk.
If you click an icon on one of the forms and are unexpectedly returned
to the main menu, the requested form probably has not yet been created.

Select a database, then select a table.
2 databases found
phpvs_mfg	phpvs_mfgwp

Project Home
This application generates and displays (1) PHP scripts for use with phpMyEdit's class file, and (2) individual PHP scripts used to interact with MySQL MyISAM tables for the purpose of record manipulation (add, update, delete, view, list, compare, etc.). This application consolidates two applications available at php-form-generator.com into a single application allowing the user to potentially browse through multiple databases in order to select a particular table. Various table specific scripts are displayed, and optionally written to disk. Using the database menu, drill down to the task list by selecting a database and a table. Requirements: the first column in the table is presumed to be the unique identifier, commonly defined as an integer with auto_increment and primary_key properties. Also PHP v.4/5 and MySQL v.4/5. UTF8 Character Sets The following queries are run by default when connecting to these databases. SET NAMES UTF8 SET COLLATION_CONNECTION=UTF8_GENERAL_CI Filename conventions are "dbname.tbname.task.php" and "dbname" is used to set up the database logon. In order to configure this application for use with multiple databases, see the folder /output-php/inc/ and files dbconn.php and db_switch.php. Configuration of database connections for running this utility may be slightly different from the configuration needed to connect the generated scripts with the source database.

Disclaimer
Code generated by this project should be considered a rough draft that possibly requires further modification in order to be suitable for use in a production environment. The generated code has NOT been "extensively" tested, but it generally appears to be free of bugs. Bugs may exist from flaws within this project, or bugs may also surface when various PHP versions, MySQL versions, MySQL character sets, and operating systems are combined. For example, when certain character sets are configured in MySQL 5 tables, PHP 4.4 on Windows returns incorrect values for field length. A work-around is programmed in for this, however users may need to reverse the work-around on certain system configurations. This project was developed using PHP 4.4 and MySQL 5 on a WAMP PC. A large number of databases are available in the author's development environment. This application facilitates quickly drilling down to a particular table in order to generate either phpMyEdit based forms or PHP scripts suitable for a particular purpose. This code has proven to be highly useful when retrofitting reports and forms into existing web sites. Support for multiple-key tables is implemented up to a point, is largely un-tested, and probably has a few bugs that will require re-coding certain queries and making minor adjustments to certain forms. All the code in this project is procedural (not Object Oriented). Intermediate or advanced skills with PHP are recommended in order to alter this application. Future development on this project will be sporadic, with changes made if/when bugs are encountered by the author, or reported by users. Implementation of language labels may (or may not) be the next step in development. Pricing to be determined. If interested in acquiring a copy of this application, send email to doug@hockinson.com or leave Voicemail at (720) 208-0661.