Technical Documentation

Show a record

Submit data …
ID 630
Category array
Required no
Element $page['head']
Description de
Default value
Mother ID $page | [627]
Updated 26 Jun 2011 23:44:24
IDCategoryReq.Element Action
6arrayyes$zz Description of database table and fieldsShow
751arrayno$zz['conditional_fields'] Show
752arrayno$zz['conditional_fields'][n] Show

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

754booleanno$zz['conditional_fields'][n]['remove_template'] Show
753integerno$zz['conditional_fields'][n]['template_field'] Show
758stringno$zz['conditional_fields'][n]['max_records'] Show
756stringno$zz['conditional_fields'][n]['table_name'] Show
755stringno$zz['conditional_fields'][n]['title'] Show
757string: SQLno$zz['conditional_fields'][n]['sql'] Show
204arrayno$zz['conditions'] Numerical indexed array of conditionsShow
798booleanno$zz['conditions'][n]['add']['always'] if set to true this means that the corresponding condition is always true if a record will be addedShow
910booleanno$zz['conditions'][n]['add']['where'] if set to true, WHERE restrictions will be checked by this condition ($zz['conditions'][n]['where'] must be set)

Relations: $zz['conditions'][n]['where']

943integerno$zz['conditions'][n]['subrecord'] index of subrecord in table definition this condition can be applied toShow
203stringno$zz['conditions'][n]['scope'] * record: with 'having' or 'where'; add['sql'], add['key_field_name'] * query: with 'sql' and 'key_field_name' * value: with 'sql' and 'field_name' * access: with 'function' and custom fields * upload (thought of, not yet implemented) * where: with 'field_name', triggers if a WHERE is set in the query for this field_name (shortcut in fields definition possible) * multi: if script is called via zzform_multi() * subrecord: with subrecord and where * noid: if an ID is so far not set (add before insert) * editing: checks where and POST value for a given field_name and if the adjoining query returns true, the condition is met (useful for adding/changing records, where a condition depends on a field value)Show
207string: fieldno$zz['conditions'][n]['add']['key_field_name'] To make clear if a condition is true or not while adding a record. Key field name; the corresponding value from $zz_conf['add'] will be used for the SQL query in 'sql'.

Relations: $zz['conditions'][n]['add']['sql']; $zz_conf['add']

212string: fieldno$zz['conditions'][n]['field_name'] Show
815string: functionno$zz['conditions'][n]['function'] use function which has to return a list of allowed IDs (ID => true)Show
206string: SQLno$zz['conditions'][n]['add']['sql'] To make clear if a condition is true or not while adding a record. SQL query ending with `WHERE key_field_name = ` where value of 'key_field_name' will be added. Together with the 'where' or 'having'-condition, if this SQL query returns more than 0 lines, the condition is considered as true. If no line is returned, the condition is considered as false.

Relations: $zz['conditions'][n]['add']['key_field_name']; $zz_conf['add']

211string: SQLno$zz['conditions'][n]['having'] Show

348 records total