File "data_calc_view.php"

Full path: /www/db_bk/bk/2/data_calc_view.php
File size: 1.03 KiB (1058 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
$REGIST_TABLE = "wave_height.data_01_cal";

$HOST = "192.168.100.153";
$DB = "arduino";
$USER = "postgres";
$PASS = "postgres";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");

$sql = "SELECT * FROM " .$REGIST_TABLE ." ORDER BY datetime";
$res = pg_query($conn,$sql)or die("SQL ERROR!!<br />". $sql.pg_last_error());
$data_ct = pg_num_rows($res);


print "<TABLE BORDER='1'>";
print "<TR><TD>DATE</TD><TD>INT</TD><TD>x</TD><TD>y</TD><TD>H</TD><TD>T</TD></TR>";

for($i = 0;$i < $data_ct ;$i++)
{
	$row = pg_fetch_array($res,$i);
	
	print "<TR>";
	print "<TD>" .$row[0] ."</TD>";
	print "<TD>" .$row[2] ."</TD>";
	print "<TD>" .$row[3] ."</TD>";
	print "<TD>" .$row[4] ."</TD>";
	print "<TD>" .$row[5] ."</TD>";
	print "<TD>" .$row[6] ."</TD>";
	print "</TR>";

}
print "</TABLE>";



pg_close($conn);


?>