Technical Documentation

IDCategoryReq.Element Action
929mixedno$zz['fields'][n]['separator_before'] - true: will put a separation before this field, to improve form layout. - column_begin, column, column_end: put form in two columns - text bla blubb: will put bla blubb below `<hr>`-Separator

Relations: $zz['fields'][n]['separator']

Show
465mixedno$zz['fields'][n]['separator'] - true: will put a separation behind this field, to improve form layout. - column_begin, column, column_end: put form in two columns - text bla blubb: will put bla blubb below `<hr>`-SeparatorShow
779string: filenameno$zz['fields'][n]['set_folder'] path of folder, files in this folder will be presented for selection (no subfolders), names of chosen files will be saved in database.

Relations: select

Show
780booleanno$zz['fields'][n]['set_show_all_values'] all values will be shown, even if current set does not include value (useful in conjunction with set_folder, when files are deleted from directory)

Relations: select; $zz['fields'][n]['set_folder']

Show
640string: SQLno$zz['fields'][n]['set_sql'] similar to set, lets you get comma separated values from an SQL query that will be treated similar as a mysql SET field

Relations: select

Show
638arrayno$zz['fields'][n]['set_title'] similar to enum_title in combination with set_sql: if = true, uses second field from sql-query as set_title

Relations: select; $zz['fields'][n]['set']

Show
395arrayno$zz['fields'][n]['set'] array for set

Relations: $zz['fields'][n]['show_values_as_list']; select

Show
782booleanno$zz['fields'][n]['show_hierarchy_same_table'] set to true: checks if ID in select is equal to main ID and if so, does not display it to user to avoid recursion

Relations: $zz['fields'][n]['show_hierarchy']

Show
416integerno$zz['fields'][n]['show_hierarchy_subtree'] ID of top hierarchy value, if not set NULL will be used

Relations: select; $zz['fields'][n]['show_hierarchy']

Show
419booleanno$zz['fields'][n]['show_hierarchy_use_top_value_instead_NULL'] if record is saved, no NULL will be used but show_hierarchy_subtree-ID instead

Relations: select; $zz['fields'][n]['show_hierarchy']

Show
417string: fieldno$zz['fields'][n]['show_hierarchy'] shows hierarchy in selects, value must be set to corresponding SQL field name

Relations: select

Show
386booleanno$zz['fields'][n]['show_id'] Normally, id fields get class record_id {display: none;}, show_id stops zzform from doing that

Relations: id

Show
178booleanno$zz['fields'][n]['show_title'] display record: show field title in TH (mainly for subtables, for aesthetic reasons)Show
298booleanno$zz['fields'][n]['show_values_as_list'] puts all enum/select values in a radio button list, not in select/option-elements, no matter how many values are available

Relations: select; $zz['fields'][n]['set']; $zz['fields'][n]['enum']

Show
423integerno$zz['fields'][n]['size_select_too_long'] if set, this will be the size of input if a select is not shown but input field instead

Relations: select

Show
405integerno$zz['fields'][n]['size'] Maximum length of characters that may be entered in input field, size of input field, standard for number 16, for time 8 and for all other fields 32 (or maxlength if smaller)Show
872arrayno$zz['fields'][n]['sql_character_set'] Character sets for fields in 'sql'-query (if different collations among the database are used); used for checking reselects

Relations: $zz['fields'][n]['sql']; select

Show
896arrayno$zz['fields'][n]['sql_fieldnames_ignore'] list of field names that will be ignored for checking a text input against a list of values from the database

Relations: select

Show
415arrayno$zz['fields'][n]['sql_ignore'] doesn't display fields of sql query in form view. this is useful if you need the fields for an identifier field; array, fields won't display in form view.

Relations: $zz['fields'][n]['sql']; select

Show
467booleanno$zz['fields'][n]['sql_index_only'] only show index field (e. g. for SHOW COLUMNS ... queries)

Relations: select

Show

Export (CSV Excel)

348 records total

in