<?php
// 一行区切り "~"
// 項目区切り ","

//===============================================
//	CommonUtilities
//	備考		：	
//	更新		：	2014/09/25 KMK-kuroda
//===============================================
$HOST = "192.168.100.153";
$DB = "cnbs";
$USER = "postgres";
$PASS = "am#71ZJ*";

try
{

	//===============================================
	//	GETパラメータの受け取り
	//	備考		：	
	//	更新		：	2014/09/25 KMK-kuroda
	//===============================================
	$area = isset($_GET["area"]) ? htmlspecialchars($_GET["area"]) : "";
	
	//$constId = "2";
	//$appId = "2";
	//$androidId="961b1a243878b000";
	//$positions = "36.9079452,139.93820552,241.0,1354165853407,0.0\\^36.90794527,139.9382055,246.0,1354165854407,0.0";
	
	//================================================
	//	データベース接続
	//	備考		：	
	//	更新		：	2014/09/25 KMK-kuroda
	//================================================
	$conn = pg_connect("
		host	=	". $HOST. "
		dbname	=	". $DB. "
		user	=	". $USER. "
		password=	". $PASS. "
	");
	if (!$conn)
	{
		throw new Exception("データベースへの接続に失敗しました");
	}

	// SELECT
	$refTsTerm = "SELECT * FROM nakagusuku.block";
	$refTsTerm .= " WHERE area = " . $area . " ORDER BY row ASC, col ASC;";

	if (!($resRefTsTerm = pg_query($conn, $refTsTerm)))
	{
		throw new Exception("データ読み込みに失敗<br />". $resRefTsTerm. "<br />". pg_last_error(). "<br />");
	}

	for ($i = 0 ; $i < pg_num_rows($resRefTsTerm) ; $i++){
		$rows = pg_fetch_array($resRefTsTerm, $i, PGSQL_ASSOC);
		print($rows['block_pkid']);
		print("," . $rows['mode']);
		print("," . $rows['enabled']);
		print("," . $rows['area']);
		print("," . $rows['row']);
		print("," . $rows['col']);
		print("," . $rows['counter']);
		print("," . $rows['countermax']);
		print("," . $rows['update'].'<br>');
	}
}
catch(Exception $exc)
{
	print $exc->getMessage();
}

//===============================================
//	Postgresql終了処理
//	備考		：	
//	更新		：	2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);

?>
