File "send_block_area.php"

Full path: /www/nakagusuku/send_block_area.php
File size: 2.01 KiB (2058 bytes)
MIME-type: text/x-php
Charset: 8 bit

Download   Open   Back

<?php
// €кЌs‹жђШ‚и "~"
// ЌЂ–Ъ‹жђШ‚и ","

//===============================================
//	CommonUtilities
//	”хЌl		ЃF	
//	ЌXђV		ЃF	2014/09/25 KMK-kuroda
//===============================================
$HOST = "192.168.100.153";
$DB = "cnbs";
$USER = "postgres";
$PASS = "am#71ZJ*";

try
{

	//===============================================
	//	GETѓpѓ‰ѓЃЃ[ѓ^‚МЋу‚ЇЋж‚и
	//	”хЌl		ЃF	
	//	ЌXђV		ЃF	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";
	
	//================================================
	//	ѓfЃ[ѓ^ѓxЃ[ѓXђЪ‘±
	//	”хЌl		ЃF	
	//	ЌXђV		ЃF	2014/09/25 KMK-kuroda
	//================================================
	$conn = pg_connect("
		host	=	". $HOST. "
		dbname	=	". $DB. "
		user	=	". $USER. "
		password=	". $PASS. "
	");
	if (!$conn)
	{
		throw new Exception("ѓfЃ[ѓ^ѓxЃ[ѓX‚Ц‚МђЪ‘±‚ЙЋё”s‚µ‚Ь‚µ‚Ѕ");
	}

	// 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("ѓfЃ[ѓ^“З‚ЭЌћ‚Э‚ЙЋё”s<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ЏI—№Џ€—ќ
//	”хЌl		ЃF	
//	ЌXђV		ЃF	2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);

?>