Bootstrap v5+ HTML5 Form Builder / Code Generator

The table named `app_form_event` 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_event"

  • Name = app_form_event
  • Engine = MyISAM
  • Version = 10
  • Row_format = Dynamic
  • Rows = 11
  • Avg_row_length = 117
  • Data_length = 1288
  • Max_data_length = 281474976710655
  • Index_length = 8192
  • 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 = Basic personal events calendar or list of reminders

SHOW CREATE TABLE `phpvs_demo` . `app_form_event`;

CREATE TABLE `app_form_event` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'none',
  `event_text` text CHARACTER SET utf8 NOT NULL COMMENT 'textarea',
  `event_url` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT 'url',
  `datetime_local` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'datetime-local',
  `start_date` date DEFAULT NULL COMMENT 'date,required',
  `start_time` time DEFAULT NULL COMMENT 'time',
  `end_date` date DEFAULT NULL COMMENT 'date',
  `end_time` time DEFAULT NULL COMMENT 'time',
  `repeat_month` enum('Every','January','February','March','April','May','June','July','August','September','October','November','December') CHARACTER SET utf8 NOT NULL COMMENT 'select',
  `repeat_day_of_month` enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31') CHARACTER SET utf8 NOT NULL COMMENT 'select',
  `repeat_day_of_week` enum('Every','Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') CHARACTER SET utf8 NOT NULL COMMENT 'select',
  `updated` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'none',
  `token` varchar(32) COLLATE utf8_unicode_ci NOT NULL 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_hid` (`hidden`),
  KEY `idx_del` (`deleted`),
  KEY `idx_sd` (`start_date`) USING BTREE,
  KEY `idx_rm` (`repeat_month`) USING BTREE,
  KEY `idx_rd` (`repeat_day_of_month`) USING BTREE,
  KEY `idx_ed` (`end_date`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Basic personal events calendar or list of reminders'

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'phpvs_demo' AND TABLE_NAME = 'app_form_event' 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
12event_texttexttexttextarea65535NO0utf8utf8_general_ci
23event_urlvarchar(255)varcharurl255NO0utf8utf8_general_ci
34datetime_localvarchar(16)varchardatetime-local16NULLYES1utf8utf8_unicode_ci
45start_datedatedatedate,required10NULLMULYES1
56start_timetimetimetime8NULLYES1
67end_datedatedatedate10NULLMULYES1
78end_timetimetimetime8NULLYES1
89repeat_monthenum('Every','January','February','March','Ap
ril','May','June','July','August','September'
,'October','November','December')
enumselect9MULNO0utf8utf8_general_ci
910repeat_day_of_monthenum('1','2','3','4','5','6','7','8','9','10'
,'11','12','13','14','15','16','17','18','19'
,'20','21','22','23','24','25','26','27','28'
,'29','30','31')
enumselect2MULNO0utf8utf8_general_ci
1011repeat_day_of_weekenum('Every','Sunday','Monday','Tuesday','Wed
nesday','Thursday','Friday','Saturday')
enumselect9NO0utf8utf8_general_ci
1112updateddatetimedatetimenone19current_timestamp()NO0
1213tokenvarchar(32)varcharnone32NO0utf8utf8_unicode_ci
1314hiddentinyint(1) unsignedtinyintnone [3]03MULNO0
1415deletedtinyint(1) unsignedtinyintnone [3]03MULNO0

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