/functions_advanced.php

Description

A collection of functions that make use of the Database

Includes
include_once ("SQLFunctions.php") (line 8)
Functions
arrayToStrings (line 46)

Converts an array into a string with ; as a seperator

void arrayToStrings (array $values)
  • array $values: values array to convert
clearDependency (line 361)

Clears the dependency of forms that have a given type and dependency

void clearDependency (int $dependency, string $type)
  • int $dependency: dependency Dependecy of the form that we wanna lookup
  • string $type: type Formtype of the form we wanna lookup
getDependency (line 381)

Returns the dependency of a form

void getDependency (int $id)
  • int $id: id ID of the form from which we want to get the dependency
getFieldsForTable (line 118)

Creates an drop down menu content with all fieldnames from a table

void getFieldsForTable (string $tab, string $selected, [bool $remove_primary = true])
  • string $tab: tab Table the table from which we select the fieldnames
  • string $selected: selected the value that should be selected in the menu
  • bool $remove_primary: remove_primary whether to remove the primary integer keys
getFieldType (line 149)

Returns the type of the field form the target database

void getFieldType (string $table, string $field)
  • string $table: table Table the table in which we wanna lookup the
  • string $field: field Field which we wanna lookup
getFormsByType (line 281)

Returns all forms of a given Type

void getFormsByType (string $type)
  • string $type: type Formtype we want to lookup
getFormsWithDependency (line 334)

Returns forms of a given type whith a given dependency

void getFormsWithDependency (int $dependency, string $type)
  • int $dependency: dependency Dependecy of the form that we wanna lookup
  • string $type: type Formtype of the form we wanna lookup
getMenu (line 70)

Creates an HTML menu from a database query

void getMenu (string $tab, string $condition, string $value, string $menuname, int $column_show, int $column_submit)
  • string $tab: tab Table to select from
  • string $condition: condition field which should have a certain value
  • string $value: value the value we question
  • string $menuname: menuname name of the menu
  • int $column_show: column_show Column that should be displayed
  • int $column_submit: column_submit Column that should be submited
getPossibleAppearance (line 176)

Returns the possible appearances array for a given fieldtype

void getPossibleAppearance (string $field_type)
  • string $field_type: field_type an ADODB fieldtype
getPossibleTablesAfterJoin (line 93)

Returns tables that are joined in the form

void getPossibleTablesAfterJoin (int $form_id)
  • int $form_id: form_id form we are working on
makeMenu2 (line 306)

Displays an entire drop down menu built from a values array The displayed value will be submitted

void makeMenu2 (string $menuname, bool $should_submit, stringarray $values, string $selected_value)
  • string $menuname: menuname Name of the menu
  • bool $should_submit: should_submit If the menu should be submited on change
  • stringarray $values: values array with the values
  • string $selected_value: selected_value Value that should be selected
makeMenuMultyArray (line 230)

Displays and drop down menu based on an multy array

void makeMenuMultyArray (string $menuname, boolean $should_submit, string $values, int $value, int $name)
  • string $menuname: menuname Name of the menu
  • boolean $should_submit: should_submit if the menu should be submitted on change
  • string $values: values the multidimensional array with the values
  • int $value: value Column with the values that should be submitted
  • int $name: name Column with the values that should be displayed
makeMenuMultyArray2 (line 256)

Displays and drop down menu based on an multy array with additional parameters

void makeMenuMultyArray2 (string $menuname, boolean $should_submit, string $values, int $value, int $name, string $selected_value, [mixed $formname = "form"])
  • string $menuname: menuname Name of the menu
  • boolean $should_submit: should_submit if the menu should be submitted on change
  • string $values: values the multidimensional array with the values
  • int $value: value Column with the values that should be submitted
  • int $name: name Column with the values that should be displayed
  • string $selected_value: name selected_value the value that should be selected
primaryIntKeyExists (line 393)

Returns the primary Integer key of $table - or false if none exists

void primaryIntKeyExists (stringarray $tables)
  • stringarray $tables: tables tables we wanna get the integer primary key from
removeDBeasyTablesFromArray (line 32)

Removes the dbeasy-tables from the given array and returns the reduced array

void removeDBeasyTablesFromArray (stringarray $arr)
  • stringarray $arr: arr array from which we want to remove the DBEasy Sytem table names
removeEntryFromArray (line 15)

Removes an entry from a given array and returns this reduced array

void removeEntryFromArray (array $arr, string $entry)
  • array $arr: arr an arbitrary array
  • string $entry: entry an entry to this array

Documentation generated on Thu, 15 Jul 2004 08:23:56 +0200 by phpDocumentor 1.3.0RC3