shinmojiwgview

File "avg.php"

Full path: /www/shinmoji/wg/view/avg.php
File size: 2.63 KiB (2689 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php
$num = isset($_POST["num"]) ? htmlspecialchars($_POST["num"]) : "50";

print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>水位監視システム</title>";
print "</head>";

print "<body>";
print "<center>";
print "<font size=\"3\"><b>";
print "水位監視システム<br>-平均水位データログ-";
print "【五洋建設株式会社】";
print "</b></font>";
print "</center>";
print "<hr />";

try
{
	$conn = pg_connect("
	host	=	192.168.100.153
	dbname	=	cnbs
	user	=	postgres
	password=	am#71ZJ*
	");
	if (!$conn)
		throw new Exception("データベースへの接続に失敗");
	
	$selectAvg = "SELECT pid, macid, avg_3s, avg_30s, avg_1m, avg_10m, avg_1h, avg_2h, avg_24h, regdate FROM shinmoji.wg_avg WHERE macid='1' ORDER BY regdate DESC LIMIT ". $num. ";";
	//print $selectAvg. "<br>";
	$res = pg_query($conn, $selectAvg);
	if (!$res)
		throw new Exception("SQLエラー：". $selectAvg);
	
	print "<center>";
	
	print "表示件数：";
	print "<form method=\"post\">";
	print "<input type=\"text\" name=\"num\" value=\"". $num. "\" style=\"width:40px;\">";
	print "<input type=\"submit\" name=\"btnchnum\" value=\"件数変更\">";
	print "</form>";
	print "<br>";
	
	print "<table border=\"1\" style=\"width:80%\">";
	print "<tr bgcolor=\"#6666ff\"><th>機械ID</th><th>3秒平均[mv]</th><th>30秒平均[mv]</th><th>1分平均[mv]</th><th>10分平均[mv]</th><th>1時間平均[mv]</th><th>2時間平均[mv]</th><th>24時間平均[mv]</th><th>登録</th>";
	
	$rowcnt = pg_num_rows($res);
	for($i = 0; $i < $rowcnt; $i++)
	{
		$row = pg_fetch_assoc($res, $i);
		//var_dump($row);
		//print "<br>";
		print "<tr align=\"center\">";
		print "<td>". $row["macid"]. "</td>";
		print "<td>". $row["avg_3s"]. "</td>";
		print "<td>". $row["avg_30s"]. "</td>";
		print "<td>". $row["avg_1m"]. "</td>";
		print "<td>". $row["avg_10m"]. "</td>";
		print "<td>". $row["avg_1h"]. "</td>";
		print "<td>". $row["avg_2h"]. "</td>";
		print "<td>". $row["avg_24h"]. "</td>";
		print "<td>". $row["regdate"]. "</td>";
		print "</tr>";
	}
	print "</table></center>";
}
catch(Exception $exc)
{
	print "<font color=\"#ff0000\">";
	print $exc. "<br>";
	print "</font>";
}
pg_close($conn);

/*
print "<p style=\"text-align:right;\">";
print "<a href=\"../index.html\">戻る</a>";
print "</p>";
*/
print "<hr>";
print "<center>";
print "<font size=\"3\" face=\"Arial\"><b><i>";
print "penta-ocean";
print "</i></b></font>";
print "</center>";
?>

PHP File Manager