<?php

class genre{
	
	public static function get_all_genres($wrapperObj)
	{
		$genreArr = array();
		$genre_query = "SELECT genre_id, genre FROM genre ORDER BY genre";
		$genre_result = $wrapperObj->executeQuery($genre_query, []);
		if ($genre_result === false) {
		    show_pdo_error($genre_query, $wrapperObj->getLastStatement());
		}
	
		foreach ($genre_result as $RowData) {
			$genreArr[$RowData['genre_id']] = $RowData['genre'];
		}
		return $genreArr;
	}
	
	/* Returns hashed array of all genres
	 * with lowercase genre names as keys
	 * snd genre id's as values
	 */
	public static function get_all_genres_hashed($wrapperObj)
	{
		$genreArr = array();
		$genre_query = "SELECT genre_id, genre FROM genre ORDER BY genre";
		$genre_result = $wrapperObj->executeQuery($genre_query, []);
		if ($genre_result === false) {
		    show_pdo_error($genre_query, $wrapperObj->getLastStatement());
		}
	
		foreach ($genre_result as $RowData) {
			$genreArr[strtolower($RowData['genre'])] = $RowData['genre_id'];
		}
		return $genreArr;
	}
	
	/* Returns hashed array of all film genres with lowercase genre names as keys
	 * and film genre id's as values
	 * @return array $filmGenreArr
	 */
	public static function get_all_film_genres_hashed($wrapperObj)
	{
		$filmGenreArr = array();
		$filmgenre_query = "select film_genre_id, genre from film_genre ORDER BY genre";
		$filmgenre_result = $wrapperObj->executeQuery($filmgenre_query, []);
		if ($filmgenre_result === false) {
		    show_pdo_error($filmgenre_query, $wrapperObj->getLastStatement());
		}
	
		foreach ($filmgenre_result as $filmRowData) {
			$filmGenreArr[strtolower($filmRowData['genre'])] = $filmRowData['film_genre_id'];
		}
		return $filmGenreArr;
	}
	
}
	
?>