最近の体温
(snは表示しない sn:$sn)");
$con_string="dbname=kenon user=postgres";
$con = pg_connect($con_string);
if(!$con) {
print "Database : connection : error
\n";
print_r( error_get_last ( ));
exit;
}
$res = pg_query($con, "SELECT * FROM stamp WHERE sn=$sn;");
if(!$res) {
print "SQL query : error
";
// print pg_last_error()."
\n";
print_r( error_get_last ( ));
// print "$php_errormsg
\n";
exit;
}
print "
\n" ;
print "| 月 | 火 | 水 | 木 | 金 |
|---|
\n" ;
print "\n" ;
$data=pg_fetch_array($res,0);
$d="mon"; $png="stamp".$data{$d}.".png"; print " | \n" ;
$d="tue"; $png="stamp".$data{$d}.".png"; print " | \n" ;
$d="wed"; $png="stamp".$data{$d}.".png"; print " | \n" ;
$d="thu"; $png="stamp".$data{$d}.".png"; print " | \n" ;
$d="fri"; $png="stamp".$data{$d}.".png"; print " | \n" ;
print "" ;
print "
\n" ;
print "
\n
\n" ;
$res=pg_query($con,"SELECT * FROM 体調管理 WHERE sn=$sn ORDER BY 測定日時 DESC LIMIT 10;");
if(!$res) {
print "SQL query : error
";
// print pg_last_error()."
\n";
print_r( error_get_last ( ));
// print "$php_errormsg
\n";
exit;
}
$rows = pg_num_rows($res);
print "\n";
print "| 検温日時 | 体温[℃] | 状 態 | 詳 細 |
|---|
\n";
for($i=0; $i<$rows;$i++){
$data=pg_fetch_array($res,$i);
$date=$data{'日時'};//測定日時,体温,体調,詳細
$temp=$data{'体温'};
$condx =$data{'体調'};
$dtls =$data{'詳細'};
print("| $date | $temp | $condx | $dtls |
\n");
}
print "
\n";
pg_close($con);
?>