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;
}
