<?php

	// Postgresql date to regular US Date format
	function SqlToUSDate($sqlDate, $time=false) 
	{
		if ($sqlDate == "") {
			return "";
		}
		if ($time) {
			$usDate = substr($sqlDate,5,2) . "/" . substr($sqlDate,8,2) . "/" . substr($sqlDate,0,4) . " " . substr($sqlDate,11,2) . ":" . substr($sqlDate,14,2) . ":" . substr($sqlDate,17,2);
		}
		else
		{
			$usDate = substr($sqlDate,5,2) . "/" . substr($sqlDate,8,2) . "/" . substr($sqlDate,0,4);	
		}
		return $usDate;
	}
	
	// Convert PostgreSQL boolean INPUT FORM value t=CHECKED f=""
	function GetFormBoolean($value) 
	{
		if ($value == "t") {	
			return "CHECKED";
		}
		else {
			return "";
		}
	}
	
	//	Sanitize input so only regular characters, numbers and a few special characters are allowed
	function CheckInput($strData) {
		//preg_match_all('/[a-zA-Z0-9_-]/', $strData, $array);
		preg_match_all('/[-a-zA-Z0-9_-|.|\x2F]/', $strData, $array);
		$count = sizeof($array[0]);
		$strRet = "";
		for ($i = 0; $i < $count; $i++) {
			$strRet = $strRet . $array[0][$i];
		}
		return $strRet;
	}
	
	// Get Month Name
	function GetMonth($value) {
		$month = "";
		switch ($value) {
			
			case 1:
				$month = "JAN";
				break;
			case 2:
				$month = "FEB";
				break;
			case 3:
				$month = "MAR";
				break;
			case 4:
				$month = "APR";
				break;
			case 5:
				$month = "MAY";
				break;
			case 6:
				$month = "JUN";
				break;
			case 7:
				$month = "JUL";
				break;
			case 8:
				$month = "AUG";
				break;
			case 9:
				$month = "SEP";
				break;
			case 10:
				$month = "OCT";
				break;
			case 11:
				$month = "NOV";
				break;
			case 12:
				$month = "DEC";
				break;	
		}
		return $month;
	}
?>