cPanel PHP MySQL web hosting

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.

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


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.

PHP Programmer    Custom Web Design    MySQL™ CRUD Application

web hosting