phpMyEdit is a PHP form generator or table editor for MySQL

PHP Multi Form Generator (MFG)

What is phpMyEdit?

The latest version of the form generator is published at www.php-html-form.com

phpMyEdit is a MySQL™ Table Editor and PHP Form Generator. phpMyEdit is a great Open Source utility for PHP / MySQL™ database developers. phpMyEdit facilitates selecting a database table and generating a PHP script used to create forms to List, Add, Change, Copy, View, or Delete records.

phpMyEdit represents the fastest way to create forms (PHP code) to interact with a MySQL MyISAM table. phpMyEdit expects the first column to be the primary key (unique field) and does not work in situations where two or more columns form the primary key. Aside from not handling tables with multiple key columns, phpMyEdit will do just about anything else you need done. A basic JOIN to one other table can usually be achieved but complex joins are not possible.

phpMyEdit is essentially comprised three PHP scripts which work together to create data entry forms for MySQL™ database tables. There is a Setup script which generates a "calling script" (table-specific form) which uses an included class file to do all the hard work. The "calling script" contains a few global settings along with series of arrays holding the properties of each column in the selected MySQL™ table. At the end of the "calling script" the main class file in included, and the displayed result is a PHP/HTML form

The difference between the free phpMyEdit and the PHP Form Generator is that PHP Form Generator can generate up to 100 phpMyEdit-based scripts in less than 30 seconds (one script for each table in the configured database). Works with most PHP versions + MySQL™ MyISAM tables where the first column is a unique identifier (e.g. auto_increment column). PHP Form Generator includes numerous cheat sheets, examples, and stylesheets not available elsewhere.

Click here for a newer version, which offers toggle links and may be easier to integrate into existing projects.

Try the free version of phpMyEdit to see if it meets your needs. Locate the CVS and download the current version of the class file. Versions offered for sale below come with complex style sheets and options configured to meet the needs of most users (saving a day's worth of experimentation and/or trial and error).

Buyers receive all 3 versions:

PHP Form Generator (Sakila) toggle links + easier integration into existing projects, output options are hard-coded in a PHP script.
PHP Form Generator (MFG) well suited to placement in a password protected folder, output options are selected using an HTML form.
PHP Form Generator (MFG alternate) potentially work with multiple databases with all output placed in a single password protected folder

Various examples are posted at phpMyEdit cheat sheet.

Payment options for PHP Form Generator ($39 US)
		Payment via PayPal should result in a ZIP files being emailed as soon as the sale is confirmed. If not received in a few minutes, check your Spam folder. (If not received within 15-20 minutes, send email).
		Allow up to 24 hours for delivery via email when selecting Google Checkout.
All sales are final. No refunds. Refund policy abandoned due to abuse by the PHP-clueless. If you lack basic skills with PHP / MySQL, don't buy this product! Buyers must to be able to read and follow simple English instructions. PHP-literate users will find this project saves them countless hours of work. Pre-sales questions? Click here.

3 ZIP files which you would receive via email:

The "sakila" version demonstrated at http://www.php-html-form.com/sakila/ will arrive as an attachment named sakila.zip.

Use the "sakila" version if you intend to integrate with an existing application or want the toggle links to display in List mode. This newer and more generic version uses hard coded options instead of an HTML form to select options. It features toggle links (not found in the other versions) and may be easier to integrate into existing projects. In order to temporarily disable the creation of toggle links, open the file at /sakila/resources/inc/create_script.php:
// To disable creation of toggle links, set $cfg['preference']['toggle'] = 0;
$cfg['preference']['toggle'] = 1;

The attachment mfg571.php will be the original version and best suited to simply placing the files in a password protected admin folder /mfg5/ for use by a single user (or multiple users if you add a secure log-in).

The attachment mfg571-alt.php is an alternate version of the original, which makes it easier to work with multiple databases (at the above alternate version link click on What's Different). You probably won't use this version.

How does phpMyEdit work?

Users need to run the Setup script once for each table. The Setup script generates the basic "calling script" (PHP script) which can be customized in various ways. The "calling script" then works with the included class file in order to view, change, copy, delete, or list records.

The Setup script was used to create this calling script based on the following `example` table schema.

CREATE TABLE `example` (
  `id` mediumint(6) unsigned NOT NULL auto_increment,
  `first_name` varchar(30) NOT NULL default '',
  `last_name` varchar(30) NOT NULL default '',
  `telephone` varchar(20) NOT NULL default '',
  `mobile_phone` varchar(20) NOT NULL default '',
  `address1` varchar(40) NOT NULL default '',
  `address2` varchar(40) NOT NULL default '',
  `city` varchar(40) NOT NULL default '',
  `state_province` varchar(30) NOT NULL default '',
  `postal_code` varchar(10) NOT NULL default '',
  `country` varchar(30) NOT NULL default 'USA',
  `email_address` varchar(50) NOT NULL default '',
  `birth_date` date NOT NULL default '0000-00-00',
  `deleted` tinyint(1) NOT NULL default '0',
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

phpMyEdit Features

Many phpMyEdit users first create their "admin" form to manage records. Then, if data is destined to be publicly displayed, a copy of the "admin" form is made, and user permissions in the public form are restricted to only list or view records. In the public script, permissions for certain page modes (add, change, copy, and delete) are easily disabled.

phpMyEdit is multi-language capable with respect to labels used for navigation links and INPUT buttons. Dozens of included language files support many popular languages plus common character sets including UTF-8. Non-English users may need to edit certain language files and apply PHP's utf8_encode() to labels containing accented characters.

Advanced users will often can create their own PHP scripts to act as triggers, or to impact the values contained in certain columns.

phpMyEdit Requirements and Limitations

phpMyEdit expects the first column in each MyISAM table to be the unique identifier, typically an auto-incremented integer field or column holding unique values.

phpMyEdit requires a web server (Apache recommended), PHP interpreter without any special modules, and MySQL™ relational database management system . phpMyEdit was developed and tested using Apache 1.3.23, PHP 4.1.2 and MySQL™ 3.23.47 under Linux Mandrake 8.2. It should work well on the same or similar systems, but also on different configurations.

Users must possess the ability to use phpMyAdmin or similar software to design their MySQL™ database tables.

Limitations: multiple keys are not supported. For example, 2+ columns comprising a single UNIQUE KEY will not work with phpMyEdit.

This website will eventually be replaced by more recent content compiled at php-html-form.com

Content Management System

I also have a custom PHP/MySQL content management system which is configured primarily for Linux hosting with the cPanel brand of website control panel. The CMS is running 100 websites has tons of features including user registration, Fancybox Photo Gallery, phpMyEdit form generator, and PHP code generator all built into the CMS. No documentation exists yet. I would need to install the system on your cPanel-based server and probably spend an hour on the telephone with you to get you acclimated. The cost, depending on the required support, would run $300 or more. phpMyEdit based forms are typically used to add HTML content. This CMS was written in such a way that include files can easily be added to a database field in order to generate content for a specific page ID.

Coupon code JK26M0JQRT is good for a one-time discount of $9.94 on new web hosting accounts with HostGator.com (the largest privately owned web host in the USA).

PHP Form Generator Home | PHP Form Generator Demo