Templates - Web Data Base

Each table of the database is defined in a definition file (def_*.php). Several definition files are provided as templates. Example: def_adressen.php (list of addresses). A definition file contains constants (define), arrays (array), functions (function) and strings.

Examples of constants:
define("ID_FIELD","ID"); // this is the ID field (every table has another)
define("DEFAULT_ORDER_BY"," ORDER BY Name ASC,Vorname ASC");

Examples of arrays:
$arrFelder=array(
  "ID" // 0
 ,"Name" // 1
 ,"Vorname" // 2
 ,"Adresse" // 3
 ...
$arrNotUsedFelderNummer = array(11,12,13);
$arrFelderFormularBreite=array( // T,3=textarea,3 rows
  "0,0" // "ID" // 0
 ,"40,99" // ,"Name" // 1
 ,"40,99" // ,"Vorname" // 2
 ,"40,99" // ,"Adresse" // 3
 ...

Example of a function:
function SpecialTextConvert($T) {
$S=str_replace("\xCE" . "\x94","[Delta]",trim($T));
$S=str_replace("\xE2" . "\x80" . "\x93","-",trim($S)); // long dash
return $S;
}

Examples of strings:
$TableStructureEmpty = "("
 ."`ID` int(16) NOT NULL auto_increment,"
 ."`Name` text collate utf8_general_ci NOT NULL,"
 ."`Vorname` text collate utf8_general_ci NOT NULL,"
 ."`Adresse` text collate utf8_general_ci NOT NULL,"
 ...
$tmpOptions="M=" . $sprach_text[70] . "[ID]";