Instant MySQL™ Code Generator - PHP Form Generator - CRUD Tool (create, read, update, delete)

This PHP / MySQL™ form generator saves web developers TONS of time, paying for itself almost immediately.

What's new? This version supports the display of `n` columns in List mode + auto-generates links used to toggle the display of the remaining columns (for occasional viewing). Toggle links exist in phpvs_sakila.customer.php, phpvs_sakila.address.php, phpvs_sakila.change_log.php, phpvs_sakila.customer_list.php and a few other scripts. Some of the demo scripts lack toggle links because the tables have very few columns.

phpMyEdit works with MyISAM tables where MySQL™ column 0 is the primary key, or a unique key. phpMyEdit does not support multi-key tables or INNODB tables. Data used for this demo is a modified version of Sakila schema (converted to MyISAM type tables). For best results, your server environment should include UTF-8 character sets, MySQL™ Version 5.1+ with MyISAM type tables (not INNODB type tables), and PHP Version 5.3+.

Instantly create a phpMyEdit script by selecting one of 25 tables listed below (in a new window).

Name	Engine	Collation
actor	MyISAM	utf8_general_ci
actor_info	VIEW
address	MyISAM	utf8_general_ci
category	MyISAM	utf8_general_ci
change_log	MyISAM	utf8_general_ci
city	MyISAM	utf8_general_ci
country	MyISAM	utf8_general_ci
customer	MyISAM	utf8_general_ci
customer_list	VIEW
film	MyISAM	utf8_general_ci
film_actor	MyISAM	utf8_general_ci
film_category	MyISAM	utf8_general_ci
film_list	VIEW
film_list2	VIEW
film_text	MyISAM	utf8_general_ci
inventory	MyISAM	utf8_general_ci
language	MyISAM	utf8_general_ci
nicer_but_slower_film_list	VIEW
payment	MyISAM	utf8_general_ci
rental	MyISAM	utf8_general_ci
sales_by_film_category	VIEW
sales_by_store	VIEW
staff	MyISAM	utf8_general_ci
staff_list	VIEW
store	MyISAM	utf8_general_ci
MySQL server version: 5.5.21-55 PHP version: 5.2.17

Links to existing phpMyEdit scripts.
* Note: some of the VIEW tables have been broken while users experimenting with the data.

Purchase for $35 (US) using buttons at php-html-form.com and all 3 versions of the form generator will be emailed to you, this version plus 2 prior versions demo'ed at php-form-generator.com.

Pre-purchase questions?
Contact Doug Hockinson at
(720) 334-7850 or by email:
doug@hockinson.com.

What's included?

Approximately 107 files in (7 folders) and the ability to instantly create forms used to Add, Change, coPy, Delete, List, and Search MySQL database records.

Basically the file set amounts to 1 main script, 7-8 include files, 68 language label include files, 2 trigger file examples, 2 CSS files, and a basic Javascript date picker. No database schema is provided, other than the change_log schema, usage of which is highly recommended.

A single (main) script is located above the /resources/ folder. The main script can be easily renamed to integrate into existing projects.

The resources folder can be renamed as long as you change that name in the main file, as well as in 7-8 "include files" in the /inc/ folder (use your text editor to carefully search & replace occurrences of "resources").

Variables common to all the phpMyEdit forms can be viewed at ./resources/inc/config.php (which also contains the database connection and some required functions). Users may want to redefine certain variables individually within the generated scripts (e.g. to increase the default record limit from 10 to 20 records in List mode).

Options for the form generator were formerly displayed in an HTML form, which became cumbersome to maintain. Options for this version of the form generator are hard coded in an included .PHP script. See readme.txt.

Alternate, older versions of the form generator can be found here and here.

If you have pre-purchase questions, please call Doug Hockinson at (720) 334-7850 or send email to doug@hockinson.com.

Data used for this demo is a modified version of Sakila schema (converted to MyISAM type tables)

If interested in obtaining a package deal which includes web hosting plus a custom content management system (with built-in form generator, user registration & log-in system, FancyBox photo gallery, etc.), contact doug@hockinson.com. Doug's CMS drives most of the the websites listed below.

php-html-form.com | php-form-generator.com | phpvs.com | hockinson.com

Keywords: php form code generator, php code generator, code generator for php, code generator php, php database code generator, form code generator, web code generator, database code generator, html form code generator

Doug Hockinson provides web hosting and PHP programming for 84 businesses as of May 14, 2012. Most of the following websites were developed in partnership with Web Designer Cymax Media, LLC. All sites are running on a dynamic content management system which uses PHP scripting and MySQL™ database.