File "data_view.php"

Full path: /www/arduino_gps/1/data_view.php
File size: 1.54 KiB (1576 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php

print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";

$DATA_TABLE = "gps.data_01_log";
$HOST = "192.168.100.153";
$DB = "arduino";
$USER = "postgres";
$PASS = "postgres";

$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");

$sel = "SELECT * FROM " .$DATA_TABLE ." ORDER BY datetime desc limit 100";
$res = pg_query($conn,$sel);
$ct = pg_num_rows($res);

print "<TABLE BORDER='1'><TR ALIGN='center'><TD>日時</TD><TD>roll</TD><TD>pitch</TD><TD>yaw</TD><TD>ax</TD><TD>ay</TD><TD>az</TD><TD>lat</TD><TD>lon</TD><TD>meters</TD></TR>";
for($ii = 0 ;$ii < $ct;$ii++)
{
	$row = pg_fetch_array($res,$ii);
	print "<TR><TD  width='180'>";
	print $row[0];
	print "</TD>";
	print "<TD width='80'>";
	print number_format($row[3],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[4],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[5],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[6],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[7],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[8],"5","." ,"");
	print "</TD>";

	print "<TD width='80'>";
	print number_format($row[9],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[10],"5","." ,"");
	print "</TD>";
	
	print "<TD width='80'>";
	print number_format($row[11],"5","." ,"");
	print "</TD>";

	print "</TR>";
}


print "</TABLE>";
?>