Line 92... |
Line 92... |
92 |
An additional entry in the table will be created with $this->rootNodeValue as its index, to allow root level
|
92 |
An additional entry in the table will be created with $this->rootNodeValue as its index, to allow root level
|
93 |
items to have a parent.
|
93 |
items to have a parent.
|
94 |
*/
|
94 |
*/
|
95 |
private function loadData ( ) {
|
95 |
private function loadData ( ) {
|
96 |
$query = "select * from $this->tableName";
|
96 |
$query = "select * from $this->tableName";
|
97 |
if ( ! isnull( $this->recordList ) )
|
97 |
if ( ! is_null( $this->recordList ) )
|
98 |
$query .= " where $this->keyField not in (" . implode( ',',$this->recordList ) . ')';
|
98 |
$query .= " where $this->keyField not in (" . implode( ',',$this->recordList ) . ')';
|
99 |
$inputRows = queryDatabaseExtended( $query ); // get everything from the table
|
99 |
$inputRows = queryDatabaseExtended( $query ); // get everything from the table
|
100 |
$inputRows = $inputRows['data']; // we only care about the data
|
100 |
$inputRows = $inputRows['data']; // we only care about the data
|
101 |
$this->inputRecords = array(); // initialize inputRecords to empty
|
101 |
$this->inputRecords = array(); // initialize inputRecords to empty
|
102 |
// main loop, will read the query results in one row at a time
|
102 |
// main loop, will read the query results in one row at a time
|