Please read readme.htm before reading this document
The internal table contains the information about all the fields of the table
you want to manage with DaDaBIK; each record of the internal table represents
a field of your main table. Edit the internal table by opening http://your_host/your_dir/admin.php
an clicking on "Internal table manager"; for each field you can select:
- label_field (what will be displayed as label in the form)
- type_field, select among:
- text (a text box)
- textarea (a textarea box)
- password (a password text box, it means asterisks instead of characters)
- insert_date (the current date will be automatically inserted in this
field when you insert a new record in your table; you should not include
an insert_date field in the insert form)
- update_date (the current date will be automatically inserted in this
field when you update a record in your table; you should not include an
update_date field in the insert form)
- date (three select field: day, month, year)
- select_single (an HTML select field)
- select_multiple_menu (an HTML select multiple field)
- select_multiple_checkbox (some checkboxes)
- ID_user (the current user detected with the PHP function get_user()
will be automatically inserted in this field when you insert a new record
in your table; you should not include an ID_user field in the insert form)
- password_record (a unique ID generated by using the PHP function unique_ID()
in conjunction with microtime(), getmypid() and md5() will be automatically
inserted in this field when you insert a new record in your table; you
should not include a password_record field in the insert form)
- content_field, the content determines what check procedure DaDaBIK should
use during an insert, select among
- alphabetic (only alphabetic characters allowed)
- alphanumeric (all characters allowed)
- numeric (only numeric characters allowed)
- web (only URL with a correct syntax allowed)
- email (only e-mail address with a correct syntax allowed)
- phone (only phone number with a correct syntax - e.g. +39025689781 -
allowed)
- city (don't use it for the moment)
- present_search_form_field (1 if it should be present in the search form,
otherwise 0)
- present_results_search_field (1 if it should be present in the results
page, otherwise 0)
- present_details_form_field (1 if it should be present in the details page,
otherwise 0)
- present_insert_form_field (1 if it should be present in the insert form,
otherwise 0)
- present_ext_update_form_field (don't use it for the moment)
- required_field (1 if it's required during the insert procedure, otherwise
0)
- check_duplicated_insert_field (1 if the field should be checked for possible
duplication during the insert procedure, otherwise 0)
- other_choices_field (1 if the field, a select_single one, can accept also
values different from the pre-set options during an insert)
- select_options_field (specify the possible options of a select field e.g.
~~teacher~manager~student~ - in this example the first option is blank-)
- foreign_key_field (if you want to drive the possible options of a select
field from another table, you have to specify here the name of the table/field
you want to use separated by a ".", e.g. products_table.desc_product;
you can also specify a customized SQL statement, in this case you have to
add "SQL:" ad the beginning, e.g. "SQL: select distinct ID_product,
desc_product from products_table" produce a select field with several
couple "ID_product desc_product" as options
- db_primary_key_field (the name of the database that contains the table you
want to use in order to fill your select field, if this field is blank DaDaBIK
uses the $db_name specified in config.php)
- select_type_field (specify "exactly","like",">"or
"<" or a group of this operator separated by "/", e.g.
"like": DaDaBIK use always the like operator for this field during
the search; "like/>/<": DaDaBIK creates for this field a menu
with the operators like, >, <, the user can choose the correct one)
- prefix_field (for text and textarea fields you can choose a prefix default
value for your field, e.g. "http://" if your field need to be filled
with a Web url; the prefix will be displayed directly in the insert form,
but if the user don't fill the field it will be considered as blank)
- default_value_field (for text and textarea fields you can choose a default
value for your field, the value will be displayed directly in the insert form)
- width_field (the width of the input box, useful with text, password and
textarea box)
- height_field (the width of the input box, useful with textarea box)
- maxlength_field (the maximum number of characters allowed in the input
box, useful with text and password box)
- hint_insert_field (the text of an hint that will appear during the insert/update
procedure near the input field in the form)
- order_form_field (the order with which the fields will appear in the form,
1 - the field will be the first in the form, 2 - the field will be the second
etc.)
- separator_field (you could leave the default one, ~)