<?php

class channel{
	
	public static function get_all_channels($wrapperObj, $key='', $case='')
	{
		$channelArr = array();
		$query = "SELECT channel_id, channel FROM channel ORDER BY channel_id";
		$result = $wrapperObj->executeQuery($query, []);
		if ($result === false) {
		    show_pdo_error($query, $wrapperObj->getLastStatement());
		}
	
		foreach ($result as $RowData) {
			if($case=='lowercase'){
				$RowData['channel'] = strtolower($RowData['channel']);
			}
			if($key=='channel_name'){
				$channelArr[$RowData['channel']] = $RowData['channel_id'];
			}else{
				$channelArr[$RowData['channel_id']] = $RowData['channel'];
			}
		}
		return $channelArr;
	}
	
}
	
?>