File "recv.php"

Full path: /www/ttest/arduino/read_mgr/recv.php
File size: 1.63 KiB (1669 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
$data = isset($_GET["dt"]) ? htmlspecialchars($_GET["dt"]) : "";
//$data = "18005490A295314946~1800549FA200315817~18005490A18A315823~1800549FA100315826~";
if (strcmp($data, "") == 0)
	exit(1);

$conn = pg_connect("
host	=	192.168.100.153
dbname	=	cnbs
user	=	postgres
password=	am#71ZJ*
");
if (!$conn)
	exit(1);

$rows = explode("~", $data);

$datacnt = count($rows) - 1;
for($i = 0; $i < $datacnt; $i++)
{
	$tagid = substr($rows[$i], 0, 7);
	$state = substr($rows[$i], 7, 1);
	$recvid = substr($rows[$i], 8, 2);
	$rssi = substr($rows[$i], 10, 2);
	
	//print "======<br>";
	//print $tagid. "<br>";
	//print $state. "<br>";
	//print $recvid. "<br>";
	//print $rssi. "<br>";
	
	$selectTag = "SELECT tagid FROM nakagusuku.worker_position WHERE tagid='". $tagid. "';";
	//print $selectTag. "<br>";
	$response = pg_query($conn, $selectTag);
	if (pg_num_rows($response) > 0)
	{
		// update
		//print "update<br>";
		$updateTag = "UPDATE nakagusuku.worker_position SET state='". $state. "', update=current_timestamp WHERE tagid='". $tagid. "';";
		//print $updateTag. "<br>";
		$response = pg_query($conn, $updateTag);
	}
	else
	{
		// insert
		//print "insert<br>";
		$insertTag = "INSERT INTO nakagusuku.worker_position (dispno, tagid, state, update, regdate) VALUES (DEFAULT, '". $tagid. "','". $state. "',current_timestamp, current_timestamp);";
		//print $insertTag. "<br>";
		$response = pg_query($conn, $insertTag);
	}
	
	$loginsert = "INSERT INTO nakagusuku.worker_log (tagid, state, recvid, rssi, regdate) VALUES ('". $tagid. "','". $state. "','". $recvid. "','". $rssi. "',current_timestamp);";
	$response = pg_query($conn, $loginsert);
}
pg_close($conn);
?>