public static function getAllCategoriesFromDatabase($dbConn) { $categoryIds = readFromDatabase::readEntireColumnFromTable($dbConn, array(self::ID_COLUMN_NAME), self::TABLE_NAME); $categories = array(); foreach ($categoryIds as $categoryId) { $category = new Category($dbConn, $categoryId[self::ID_COLUMN_NAME]); $categories[$category->getId()] = $category->getName(); } return $categories; }
public static function getAllProgramsFromDatabase($dbConn) { $programIds = readFromDatabase::readEntireColumnFromTable($dbConn, array(self::ID_COLUMN_NAME), self::TABLE_NAME); $programs = array(); foreach ($programIds as $programId) { $program = new Program($dbConn, $programId[self::ID_COLUMN_NAME]); $programs[$program->getId()] = $program->getName(); } return $programs; }
public static function getAllEpisodesFromDatabase($dbConn) { $episodeIds = readFromDatabase::readEntireColumnFromTable($dbConn, array(self::ID_COLUMN_NAME), self::TABLE_NAME); $episodes = array(); if (count($episodeIds)) { foreach ($episodeIds as $episodeRow) { $episode = new Episode($dbConn, $episodeRow[self::ID_COLUMN_NAME]); $episodes[$episode->getId()] = $episode; } } return $episodes; }