";
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("データベースへの接続に失敗");
$btnregist = isset($_POST["btnregist"]) ? htmlspecialchars($_POST["btnregist"]) : "";
if (strcmp($btnregist, "") != 0)
{
$txtdispno = isset($_POST["txtdispno"]) ? htmlspecialchars($_POST["txtdispno"]) : "";
if (strcmp($txtdispno, "") == 0)
throw new Exception("【登録エラー】表示番号が指定されていません");
if (!is_numeric($txtdispno))
throw new Exception("【登録エラー】表示番号が正しくありません");
$txtwname = isset($_POST["txtwname"]) ? htmlspecialchars($_POST["txtwname"]) : "";
if (strcmp($txtwname, "") == 0)
throw new Exception("【登録エラー】作業員氏名が指定されていません");
$insertWname = "INSERT INTO nakagusuku.worker_name (dispno, wname, update, regdate) VALUES ('". $txtdispno ."','". $txtwname. "',current_timestamp,current_timestamp);";
print "";
if (pg_query($conn, $insertWname))
print "氏名を登録しました
";
else
print "新規登録に失敗しました
";
print "";
}
$selectWname = "SELECT dispno, wname, useflg FROM nakagusuku.worker_name ORDER BY dispno;";
$res = pg_query($conn, $selectWname);
if (!$res)
throw new Exception("SQLエラー");
print "";
print "| 表示番号 | 氏名 | 使用状況 |
|---|
";
$rowcnt = pg_num_rows($res);
for($i = 0; $i < $rowcnt; $i++)
{
$row = pg_fetch_assoc($res, $i);
print "";
print "| ". $row["dispno"]. " | ";
print "". $row["wname"]. " | ";
$vuseflg = strcmp($row["useflg"], "t") == 0 ? "使用中" : "未使用";
print "". $vuseflg. " | ";
print "
";
}
print "";
print "
";
print "";
print "
";
}
catch(Exception $exc)
{
print "";
print $exc. "
";
print "";
}
pg_close($conn);
print "";
print "戻る";
print "
";
print "
";
print "";
print "";
print "penta-ocean";
print "";
print "";
?>