public static function GetByName($name) { global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "Pages WHERE page_Name = '" . $MySQL->real_escape_string($name) . "'"; $result = $MySQL->query($query); $values = $result->fetch_assoc(); return Page::GetByAssoc($values); }
$item = Place::GetByAssoc($values); echo "{ \"Category\": \"Places\", \"Item\": "; echo $item->ToJSON(); echo " }"; if ($i + $previousCount < $totalCount - 1) { echo ", "; } } }); } if ($availableTables["Pages"]) { $lookupTables[] = new LookupTable("Pages", "page_Title", function ($table, $totalCount, $previousCount) { $result = $table->Result; for ($i = 0; $i < $result->num_rows; $i++) { $values = $result->fetch_assoc(); $item = Page::GetByAssoc($values); echo "{ \"Category\": \"Pages\", \"Item\": "; echo $item->ToJSON(); echo " }"; if ($i + $previousCount < $totalCount - 1) { echo ", "; } } }); } if ($availableTables["Tasks"]) { $lookupTables[] = new LookupTable("Tasks", "task_Title", function ($table, $totalCount, $previousCount) { $result = $table->Result; for ($i = 0; $i < $result->num_rows; $i++) { $values = $result->fetch_assoc(); $item = Task::GetByAssoc($values);