Form / Details fetch data examples

These variables and functions can be used in form view and all variants for details view.

  • Main variables:
$form_id 				// Brixy Form ID
$row_id 				// record id
$tbl_name_main_table 	// form main table name
$resource_id 			// unique id for this form view. Generated on every load
$groups 				// published groups with elements in details view
  • Common app functions:
array_keys($groups) 	// return array of group ids
form_groups($groups) 	// return array of groups id and name
  • Get full element data:
// function:
get_el_data_from_group(array $groups, string $group_name, string $el_name);
// example:
$el_status_data	= get_el_data_from_group($groups, 'forum_topics', 'status');
// result:
p($el_status_data, 'el_status_data'); // array of full data on element 'status' from group 'forum_topics'
  • Get elements data from group by group name:
// function:
group_els_by_name(array $groups, string $group_name);
// example:
$group_topics_elements = group_els_by_name($groups, 'forum_topics'); 
// result:
p($group_topics_elements, 'group_topics_elements'); // array of elements data from group with name 'forum_topics'
  • Get elements data from group by group id:
// function:
group_els_by_id(array $groups, int $group_id);
// example:
$group_topics_elements = group_els_by_id($groups, 5); 
// result:
p($group_topics_elements, 'group_topics_elements'); // array of elements data from group with id=5
  • Get element value:
// function:
get_val(array $group_elements, string $el_name);
// example:
$status_val = get_val($group_topics_elements, 'status'); 
// result:
p($status_val, 'status_val'); // visible value on element 'status' from group
  • Get element value raw:
// function:
get_val_raw(array $group_elements, string $el_name);
// example:
$status_raw = get_val_raw($group_topics_elements, 'status'); 
// result:
p($status_raw, 'status_raw'); // db value on element 'status' from group
  • Get element label:
// function:
get_label(array $group_elements, string $el_name);
// example:
$label_status = get_label($group_topics_elements, 'status');
// result:
p($label_status); // return label on element 'status'

Repeated group

  • Get elements data from repeated group:
// function: 
group_els_by_name(array $groups, string $group_name);
// example:
$group_posts_elements = group_els_by_name($groups, 'forum-topics-[tec_posts]');
// result:
p($group_posts_elements); // array of elements data from repeated group with name 'forum-topics-[tec_posts]'
  • Get value on element from repeated group:
// function:
get_val_repeat(array $repeat_group_els, string $el_name);
// example:
$val = get_val_repeat($group_posts_elements, 'status');
// result:
p($val); // return array with value on element 'status' from group 'posts'
  • Get value_raw on element from repeated group:
// function:
get_val_raw_repeat(array $repeat_group_els, string $el_name);
// example:
$val_raw = get_val_raw_repeat($group_posts_elements, 'status');
// result:
p($val_raw); // return array with value_raw on element 'status' from group 'posts'
  • Get value and value raw for each element from each row:
// function:
get_values_repeat(array $repeat_group_els)
// example:
$values = get_values_repeat($group_posts_elements);
// result:
p($values); // return array with value and value_raw for each element from group 'posts'
$values = [
	0 => [ // order in repeated group
		'element_name_1' => [
			'value' 	=> 'value_data',
			'value_raw' => 'value_raw_data',
		],
		'element_name_2' => [
			'value' 	=> 'value_data',
			'value_raw' => 'value_raw_data',
		],
	],
	1 => [ // order in repeated group
		'element_name_1' => [
			'value' 	=> 'value_data',
			'value_raw' => 'value_raw_data',
		],
		'element_name_2' => [
			'value' 	=> 'value_data',
			'value_raw' => 'value_raw_data',
		],
	],
];

Form specified

  • Show single element:
// function:
get_el(array $group_elements, string $el_name);
// example:
$el = get_el(array $group_topics_elements, 'status');
// result:
echo $el; //show element data as html node
$actions // form buttons - save, save and close, cancel ...