public static function Get($max = null) { global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "StartPages"; if (is_numeric($max)) { $query .= " LIMIT " . $max; } $result = $MySQL->query($query); $count = $result->num_rows; $retval = array(); for ($i = 0; $i < $count; $i++) { $values = $result->fetch_assoc(); $retval[] = StartPage::GetByAssoc($values); } return $retval; }
$item = Task::GetByAssoc($values); echo "{ \"Category\": \"Tasks\", \"Item\": "; echo $item->ToJSON(); echo " }"; if ($i + $previousCount < $totalCount - 1) { echo ", "; } } }); } if ($availableTables["StartPages"]) { $lookupTables[] = new LookupTable("StartPages", "startpage_Title", function ($table, $totalCount, $previousCount) { $result = $table->Result; for ($i = 0; $i < $result->num_rows; $i++) { $values = $result->fetch_assoc(); $item = StartPage::GetByAssoc($values); echo "{ \"Category\": \"StartPages\", \"Item\": "; echo $item->ToJSON(); echo " }"; if ($i + $previousCount < $totalCount - 1) { echo ", "; } } }); } header("Content-Type: application/json; charset=UTF-8"); echo "{ "; $lookup = $_GET["query"]; $totalCount = 0; foreach ($lookupTables as $lookupTable) { $query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . $lookupTable->TableName;