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:

• 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)
• present_search_form_field (1 if it should be present in the search form, otherwise 0)
• required_field (1 if it's required during the insert procedure, otherwise 0)
• present_results_search_field (1 if it should be present in the results page, otherwise 0)
• check_duplicated_insert_field (1 if the field should be checked for possible duplication during the insert procedure, otherwise 0)
• 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)
  • generic_file (an input field that allow the user to browse in his filestystem and upload a file. You need to specify the allowed file extensions in config.php)
  • image_file (the same as the above, but in this case DaDaBIK supposes that the file is an image and so show it when the record is displayed. You need to specify the allowed file extensions in config.php)
  • 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)
• separator_field (you could leave the default one, ~)
• 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)
• 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)
• label_field (what will be displayed as label in the 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.)