Bootstrap v5+ HTML5 Form Builder / Code Generator

The table named `app_form_2` has been analyzed. Scroll down to find the link to the form you created!

Observe column comments appearing in the schema below. HTML5 input types are set using specific column comments (checkmultiple, color, date, datetime-local, email, file, month, none, number, password, radio, range, required, select, tel, text, textarea, time, url). Bootstrap Floating Labels apply to this app. Placeholder usage causes certain validation apps to complain about a placeholder being used with certain field types.

SHOW TABLE STATUS FROM `phpvs_demo` WHERE Name = "app_form_2"

  • Name = app_form_2
  • Engine = MyISAM
  • Version = 10
  • Row_format = Dynamic
  • Rows = 0
  • Avg_row_length = 0
  • Data_length = 0
  • Max_data_length = 281474976710655
  • Index_length = 1024
  • Data_free = 0
  • Auto_increment = 1
  • Create_time = 2021-09-29 14:23:20
  • Update_time = 2021-09-29 14:23:20
  • Check_time =
  • Collation = utf8_unicode_ci
  • Checksum =
  • Create_options =
  • Comment = Set comment = none to omit the field from processing

SHOW CREATE TABLE `phpvs_demo` . `app_form_2`;

CREATE TABLE `app_form_2` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'none',
  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text,required',
  `email_address` varchar(80) COLLATE utf8_unicode_ci NOT NULL COMMENT 'email,required',
  `telephone` varchar(80) COLLATE utf8_unicode_ci NOT NULL COMMENT 'tel,required',
  `interest` enum('Small','Medium','Large') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'select',
  `radio_button` enum('A','B','C') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'radio',
  `comment` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'textarea',
  `token` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'none',
  `updated` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'none',
  `hidden` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'none',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT 'none',
  PRIMARY KEY (`id`),
  KEY `idx_token` (`token`) USING BTREE,
  KEY `idx_hidden` (`hidden`) USING BTREE,
  KEY `idx_deleted` (`deleted`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Set comment = none to omit the field from processing'

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'phpvs_demo' AND TABLE_NAME = 'app_form_2' ORDER BY ORDINAL_POSITION

COLORD
POS
COLUMNCOLUMN
TYPE
DATA
TYPE
COLUMN
COMMENT
MAX
LEN
DEFAULT
VALUE
NUMERIC
PRECISION
COLUMN
KEY
EXTRANULLABLENULLCHAR
SET
COLLATION
01idsmallint(5) unsignedsmallintnone [5]5PRIauto_incrementNO0
12namevarchar(80)varchartext,required80NO0utf8utf8_unicode_ci
23email_addressvarchar(80)varcharemail,required80NO0utf8utf8_unicode_ci
34telephonevarchar(80)varchartel,required80NO0utf8utf8_unicode_ci
45interestenum('Small','Medium','Large')enumselect6NULLYES1utf8utf8_unicode_ci
56radio_buttonenum('A','B','C')enumradio1NULLYES1utf8utf8_unicode_ci
67commenttexttexttextarea65535NO0utf8utf8_unicode_ci
78tokenvarchar(32)varcharnone32MULNO0utf8utf8_unicode_ci
89updatedtimestamptimestampnone19current_timestamp()NO0
910hiddentinyint(1) unsignedtinyintnone [3]03MULNO0
1011deletedtinyint(1) unsignedtinyintnone [3]03MULNO0

The selected table contains 11 columns.

Radio buttons require an ENUM field definition and the comment = 'radio'

Single item select boxes require an ENUM field and the comment = 'select'

Multiple select checkboxes require a SET field and the comment = 'checkmultiple'

The first column is an AUTO_INCREMENT column.


Flag fields named hidden and deleted exist at the end of the table.