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;
