<?php

class language{
	
	public static function get_all_languages($wrapperObj, $name='code', $case='')
	{
		$languageArr = array();
		$query = "SELECT language_code, language FROM language ORDER BY language_code";
		$result = $wrapperObj->executeQuery($query, []);
		if ($result === false) {
		    show_pdo_error($query, $wrapperObj->getLastStatement());
		}
	
		foreach ($result as $RowData) {
			if($case=='lowercase'){
				$RowData['language'] = strtolower($RowData['language']);
				$RowData['language_code'] = strtolower($RowData['language_code']);
			}
			if($name=='language'){
				$languageArr[$RowData['language']] = $RowData['language_code'];
			}else{
				$languageArr[$RowData['language_code']] = $RowData['language'];
			}
		}
		return $languageArr;
	}
	
}
	
?>