| 1 |
rodolico |
1 |
DBDatabase
|
|
|
2 |
methods
|
|
|
3 |
__construct( $databaseName, $tableDefinitionArray = '', $displayOptions = '' )
|
|
|
4 |
toHTML
|
|
|
5 |
toArray
|
|
|
6 |
getTable( $name )
|
|
|
7 |
doAdmin( $returnPage = 'admin.php' ) // no longer in use
|
|
|
8 |
properties
|
|
|
9 |
$databaseName // string with the name of the database
|
|
|
10 |
$tables // array of DBTables
|
|
|
11 |
$displayOptions; // array, not used
|
|
|
12 |
$defaultTable; // string with name of default table for processing
|
|
|
13 |
|
|
|
14 |
|
|
|
15 |
DBTable
|
|
|
16 |
methods
|
|
|
17 |
__construct( $tableName, $displayName = '', $displayColumns = '', $displayQuery = '', $columnDefinitionArray = '', $queries = '' )
|
|
|
18 |
makeQuery( $type = 'list' )
|
|
|
19 |
columnDefinitionsArrayToObject ( $arr )
|
|
|
20 |
getOneRowQuery ( $keyValues )
|
|
|
21 |
join ( $arrays, $glue = ',', $pre='', $post='' )
|
|
|
22 |
getSelectQuery( $type='list', $parameters = '' )
|
|
|
23 |
toArray( $parameters = '' )
|
|
|
24 |
toHTML( $id='' )
|
|
|
25 |
properties
|
|
|
26 |
$tableName;
|
|
|
27 |
$columns;
|
|
|
28 |
$displayName;
|
|
|
29 |
$displayColumns;
|
|
|
30 |
$displayQuery;
|
|
|
31 |
$queries;
|
|
|
32 |
|
|
|
33 |
DBRecord
|
|
|
34 |
methods
|
|
|
35 |
__construct( $table, $keyValues = '' )
|
|
|
36 |
loadFromDatabase ( $keyValues = '' )
|
|
|
37 |
saveToDatabase()
|
|
|
38 |
* toArray
|
|
|
39 |
toHTML( $keyValues = '' )
|
|
|
40 |
properties
|
|
|
41 |
$table;
|
|
|
42 |
$keyValues;
|
|
|
43 |
|
|
|
44 |
DBColumn
|
|
|
45 |
methods
|
|
|
46 |
__construct ( $columnName, $definition = '', $value='')
|
|
|
47 |
__toString()
|
|
|
48 |
valueTemplate( $newValue = '' )
|
|
|
49 |
headerTemplate( $newValue = '' )
|
|
|
50 |
inputTemplate( $newValue = '' )
|
|
|
51 |
replaceTokens ( $string, $values )
|
|
|
52 |
makeSafeSQLValue ( $value = '' )
|
|
|
53 |
displayHTML ($template = '')
|
|
|
54 |
HTMLColumnName ($template = '')
|
|
|
55 |
HTMLInputField ($template = '')
|
|
|
56 |
properties
|
|
|
57 |
$columnName; // name in database
|
|
|
58 |
$primaryKey; // true if this is a member of the primary key
|
|
|
59 |
$displayName; // human readable name, uses $columnName if not defined
|
|
|
60 |
$value; // in most cases, can hold the actual value (not type file or manyToMany)
|
|
|
61 |
$required; // if false, may be set to null
|
|
|
62 |
$default; // for not null columns, what value to use if it is null. Also displayed on creation of an insert new row screen
|
|
|
63 |
$readOnly; // if set, an input field will not be created for this column; it will be displayed instead.
|
|
|
64 |
$width; // width of input field and/or html display
|
|
|
65 |
$nullable; // true/false if it can be null (as opposed to empty)
|
|
|
66 |
|