";
print "";
print "";
print "";
print "";
print "退避管理システム";
print "";
print "";
print "";
print "";
print "退避管理システム
-表示番号編集-";
print "【五洋建設株式会社】";
print "";
print "";
print "
";
try
{
$conn = pg_connect("
host = 192.168.100.153
dbname = cnbs
user = postgres
password= am#71ZJ*
");
if (!$conn)
throw new Exception("データベースへの接続に失敗");
$selectWrk = "SELECT pid, dispno, tagid, useflg FROM nakagusuku.worker_position ORDER BY dispno;";
//print $selectWrk. "
";
$res = pg_query($conn, $selectWrk);
if (!$res)
throw new Exception("SQLエラー");
print "";
print "| 表示番号編集 | id | 表示番号 | タグID | 使用状況 |
|---|
";
$rowcnt = pg_num_rows($res);
for($i = 0; $i < $rowcnt; $i++)
{
$row = pg_fetch_assoc($res, $i);
//var_dump($row);
//print "
";
print "";
print "| 編集 | ";
print "". $row["pid"]. " | ";
print "". $row["dispno"]. " | ";
print "". $row["tagid"]. " | ";
$vuseflg = strcmp($row["useflg"], "t") == 0 ? "使用中" : "未使用";
print "". $vuseflg. " | ";
print "
";
}
print "
";
}
catch(Exception $exc)
{
print "";
print $exc. "
";
print "";
}
pg_close($conn);
print "";
print "戻る";
print "
";
print "
";
print "";
print "";
print "penta-ocean";
print "";
print "";
?>