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.
Demo: PHP Form Generator
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.
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
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 Multi Form Generator
The intent of the PHP Multi Form Generator (MFG) offered for sale on this site is to generate phpMyEdit-based scripts for all MySQL tables in the configured database all at one time and write them to disk in a matter of seconds.
Some MFG users find the speed and efficiency of MFG pays for itself on the first usage. Otherwise, phpMyEdit users must individually create and configure one script for each MySQL table when using the standard setup file (phpMyEdit.Setup.php). With MFG, create dozens of forms in a matter of seconds.
phpMyEdit Project Links
phpMyEdit Download, Documentation, and Support Forum at www.platon.sk
phpMyEdit Home Page, Credits, & Extensions
phpMyEdit examples on other websites
Related links:
Web Developer Resume
hockinson,
php developer resume,
php programmer resume,
php programming resume,
php resume,
php web developer resume,
resume for php developer,
resume of php developer,
web developer resume,
web developer resumes
PHP Form Generator Home
| PHP Form Generator Demo
|
