File "data_update.php"
Full path: /www/geye/data_update.php
File size: 980 B
MIME-type: text/html
Charset: utf-8
<HTML>
<HEAD>
<META Http-Equiv="Content-Type" Content="text/html;charset=UTF-8">
<TITLE>検査立会申請更新</TITLE>
<LINK REL="stylesheet" HREF="mstmnt.css" TYPE="text/css">
</HEAD>
<BODY>
<?php
EXTRACT($_GET);
$id = $_GET['id'];
$req = $_GET['request'];
//----------------------------------------------------------------------
// 接続設定（サーバ／データベース／ユーザ／パスワード）
$sv = "localhost";
$dbname = "geye";
$user = "postgres";
$pass = "postgres";
$conn = pg_connect("host=$sv dbname=$dbname user=$user password=$pass") or die("接続エラー");
//----------------------------------------------------------------------
$up_sql = "UPDATE inspection_record SET request_status=" .$req ." WHERE id=" .$id;
$up_res = pg_query($conn,$up_sql) or die("pg_last_error()");
if($req == 1)
{
print "申請内容を[承認]しました";
}
else if($req == 2)
{
print "申請内容を[差戻]しました";
}
else
{}
?>
</BODY>
</HTML>