What is phpMyEdit?

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.

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.

Demo: PHP Form Generator

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.

Features include search capability, pagination, user permissions (view, change, copy, and/or delete), three navigation types (text, graphic, or button links), optional email notification of add / change / delete actions, extensive CSS stylesheet classes, and change_log support.

phpMyEdit is probably the fastest method of creating a basic web form (PHP script) to interact with a MySQL™ database.

phpMyEdit might be described as a PHP form script or a MySQL™ table editor. The end result is a PHP script that allows users to view individual records, change a record, copy an existing record to a new record, delete a record, or list all records in a sortable, searchable, and paginated layout.

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.

PHP Form Generator Home | PHP Form Generator Demo