cPanel PHP MySQL web hosting

Instant MySQL™ Code Generator - phpMyEdit (PHP) Form Generator

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.1.56
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.

  1. actor
  2. actor_info
  3. address
  4. category
  5. change_log
  6. city
  7. country
  8. customer
  9. customer_list (VIEW)
  10. film
  11. film_actor
  12. film_category
  13. film_list* (VIEW)
  14. film_list2* (VIEW)
  15. film_text
  16. inventory
  17. language
  18. payment
  19. rental
  20. sales_by_film_category * (VIEW)
  21. sales_by_store * (VIEW)
  22. staff
  23. staff_list * (VIEW)
  24. store

Purchase using buttons at
php-form-generator.com
and all 3 versions of the form generator will be emailed to you.
(this version plus 2 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.
cPanel PHP MySQL web hosting

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


2012 Special: For information on how to obtain these scripts for FREE contact doug@hockinson.com. As a HostGator.com affiliate, I receive a commission from HostGator.com when my unique Coupon Code is used at the time of sign-up for NEW HostGator.com web hosting accounts AND hosting is paid in advance (prepaid) for one year (12 months) at the time of sign-up. You must have a complete and fully functional website which is NOT currently hosted at HostGator.com and you must be willing to relocate that site to HostGator.com, at which point the commission should appear in my Affiliate Control Panel. After the commission appears in my affiliate control panel, then I'll email all 3 versions of the form generator to you.

In a nutshell: you use my Coupon Code when creating a NEW hosting account AND paying HostGator.com about $96 for 12 months of "Baby Plan" hosting, then I verify that HostGator.com authorizes my commission and I email these scripts to you at no charge. If interested, you can request the coupon code by submitting your domain name to doug@hockinson.com.

This offer may be withdrawn at any time and is null and void if you already host with HostGator.com, or if your website is unprofessional, or if HostGator.com fails to authorize a commission because your website violates their Terms of Service.


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 81 businesses as of January 25, 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.

Webmaster - PHP Programmer    Colorado Web Designer    web hosting
phpMyEdit form generator for PHP and MySQL™