A list of tables found in the database `phpvs_demo2015` database appears below.

Create a phpMyEdit script by clicking either Yes or No under the TOGGLE column. Your TOGGLE selection specifies whether or not to create links that enable you to add columns to List mode on-the-fly.

TABLE TOGGLE ENGINE ROWS AVG_ROW COLLATION INDEX LENGTH COMMENT
demo_customers NoYes MyISAM 123 1,406 utf8_general_ci 4,096
demo_employees NoYes MyISAM 27 849 utf8_general_ci 2,048
demo_offices NoYes MyISAM 6 1,111 utf8_general_ci 3,072
demo_products NoYes MyISAM 108 268 utf8_general_ci 7,168

Installation of the provided `change_log` schema is required.

CREATE TABLE IF NOT EXISTS `change_log` (
  `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user` varchar(50) NOT NULL DEFAULT '',
  `host` varchar(255) NOT NULL DEFAULT '',
  `operation` varchar(50) NOT NULL DEFAULT '',
  `tab` varchar(50) NOT NULL DEFAULT '',
  `rowkey` varchar(255) NOT NULL DEFAULT '',
  `col` varchar(255) NOT NULL DEFAULT '',
  `oldval` mediumtext,
  `newval` mediumtext,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_tab` (`tab`),
  KEY `idx_col` (`col`),
  KEY `idx_operation` (`operation`),
  KEY `idx_rowkey` (`rowkey`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='See the change_log features of phpMyEdit';

"Yes" selections occur most often with tables having an unusually large number of columns. Where toggle links are selected, set $omit_div_container = 1; to use 100% of the Bootstrap display width.

Column comments found during the next step can be optionally configured using $pme['help_method'] to be displayed as Help in the phpMyEdit script.

Go Back

PHP Form Generator, PHP Form Builder MySQL Table Editor
Manage records in a MySQL™ MyISAM database. Features: list, add, change, copy, update, view, or delete records.
Instantly generate a PHP script to work with MySQL™ MyISAM type tables using MySQLi connection methods with utf8 character sets. A phpMyEdit script will be created for the selected table. Requirements: LAMP or WAMP server environments with PHP 5+ and MySQL™ 5+ installed, plus a basic understanding of how to use PHP, MySQL™, and phpMyAdmin to create MyISAM type database tables.