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, ~)