Bootstrap v5+ HTML5 Form Builder / Code Generator

The table named `app_form_1` 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_1"

  • Name = app_form_1
  • Engine = MyISAM
  • Version = 10
  • Row_format = Dynamic
  • Rows = 11
  • Avg_row_length = 174
  • Data_length = 1920
  • Max_data_length = 281474976710655
  • Index_length = 5120
  • Data_free = 0
  • Auto_increment = 12
  • 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_1`;

CREATE TABLE `app_form_1` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'none',
  `nickname` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text,required',
  `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `middle_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `suffix` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_street_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_street_address_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_locality` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_region` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_postal_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `home_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `personal_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default@example.com' COMMENT 'email',
  `mobile_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'tel',
  `home_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'tel',
  `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `user_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'password',
  `business_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_street_address_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_street_address_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_locality` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_region` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_postal_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_country` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'text',
  `business_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'tel',
  `business_fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'tel',
  `business_email` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT 'default@example.com' COMMENT 'email',
  `business_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'url',
  `select_enum_1` enum('Small','Medium','Large') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'select',
  `select_set_1` set('A','B','C','D','E','F','G','H','I','J') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'select',
  `check_multiple` set('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'checkmultiple',
  `radio_1` enum('A','B','C') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'radio',
  `radio_2` enum('X','Y','Z') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'radio',
  `comment_1` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'textarea',
  `date_1` date DEFAULT NULL COMMENT 'date',
  `time_1` time DEFAULT NULL COMMENT 'time',
  `date_2` date DEFAULT NULL COMMENT 'date',
  `time_2` time DEFAULT NULL COMMENT 'time',
  `datetime_local` varchar(16) COLLATE utf8_unicode_ci NOT NULL COMMENT 'datetime-local',
  `month` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'month',
  `week` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'week',
  `rating` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'number',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL COMMENT 'color',
  `range_` tinyint(4) NOT NULL DEFAULT 50 COMMENT 'range',
  `search_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'search',
  `file_input_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'file',
  `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 AUTO_INCREMENT=12 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_1' 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
12nicknamevarchar(255)varchartext,required255NO0utf8utf8_unicode_ci
23first_namevarchar(255)varchartext255NO0utf8utf8_unicode_ci
34middle_namevarchar(255)varchartext255NO0utf8utf8_unicode_ci
45last_namevarchar(255)varchartext255NO0utf8utf8_unicode_ci
56suffixvarchar(255)varchartext255NO0utf8utf8_unicode_ci
67home_street_addressvarchar(255)varchartext255NO0utf8utf8_unicode_ci
78home_street_address_2varchar(255)varchartext255NO0utf8utf8_unicode_ci
89home_localityvarchar(255)varchartext255NO0utf8utf8_unicode_ci
910home_regionvarchar(255)varchartext255NO0utf8utf8_unicode_ci
1011home_postal_codevarchar(255)varchartext255NO0utf8utf8_unicode_ci
1112home_countryvarchar(255)varchartext255NO0utf8utf8_unicode_ci
1213personal_emailvarchar(255)varcharemail255'default@example.com'NO0utf8utf8_unicode_ci
1314mobile_phonevarchar(255)varchartel255NO0utf8utf8_unicode_ci
1415home_phonevarchar(255)varchartel255NO0utf8utf8_unicode_ci
1516user_namevarchar(255)varchartext255NO0utf8utf8_unicode_ci
1617user_passwordvarchar(255)varcharpassword255NO0utf8utf8_unicode_ci
1718business_namevarchar(255)varchartext255NO0utf8utf8_unicode_ci
1819business_street_address_1varchar(255)varchartext255NO0utf8utf8_unicode_ci
1920business_street_address_2varchar(255)varchartext255NO0utf8utf8_unicode_ci
2021business_localityvarchar(255)varchartext255NO0utf8utf8_unicode_ci
2122business_regionvarchar(255)varchartext255NO0utf8utf8_unicode_ci
2223business_postal_codevarchar(255)varchartext255NO0utf8utf8_unicode_ci
2324business_countryvarchar(255)varchartext255NO0utf8utf8_unicode_ci
2425business_phonevarchar(255)varchartel255NO0utf8utf8_unicode_ci
2526business_faxvarchar(255)varchartel255NO0utf8utf8_unicode_ci
2627business_emailvarchar(255)varcharemail255'default@example.com'NO0utf8utf8_general_ci
2728business_urlvarchar(255)varcharurl255NO0utf8utf8_unicode_ci
2829select_enum_1enum('Small','Medium','Large')enumselect6NULLYES1utf8utf8_unicode_ci
2930select_set_1set('A','B','C','D','E','F','G','H','I','J')setselect19NULLYES1utf8utf8_unicode_ci
3031check_multipleset('Sunday','Monday','Tuesday','Wednesday','
Thursday','Friday','Saturday')
setcheckmultiple56NULLYES1utf8utf8_unicode_ci
3132radio_1enum('A','B','C')enumradio1NULLYES1utf8utf8_unicode_ci
3233radio_2enum('X','Y','Z')enumradio1NULLYES1utf8utf8_unicode_ci
3334comment_1texttexttextarea65535NO0utf8utf8_unicode_ci
3435date_1datedatedate10NULLYES1
3536time_1timetimetime8NULLYES1
3637date_2datedatedate10NULLYES1
3738time_2timetimetime8NULLYES1
3839datetime_localvarchar(16)varchardatetime-local16NO0utf8utf8_unicode_ci
3940monthvarchar(255)varcharmonth255NO0utf8utf8_unicode_ci
4041weekvarchar(255)varcharweek255NO0utf8utf8_unicode_ci
4142ratingtinyint(4)tinyintnumber [3]13NO0
4243colorvarchar(7)varcharcolor7NO0utf8utf8_unicode_ci
4344range_tinyint(4)tinyintrange [3]503NO0
4445search_1varchar(255)varcharsearch255NO0utf8utf8_unicode_ci
4546file_input_1varchar(255)varcharfile255NO0utf8utf8_unicode_ci
4647tokenvarchar(32)varcharnone32MULNO0utf8utf8_unicode_ci
4748updatedtimestamptimestampnone19current_timestamp()NO0
4849hiddentinyint(1) unsignedtinyintnone [3]03MULNO0
4950deletedtinyint(1) unsignedtinyintnone [3]03MULNO0

The selected table contains 50 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.