";
print "";
print "";
print "";
print "";
print "". $SCRIPT_TITLE. "";
print "";
//===============================================
// HTML-BODY部開始-
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "";
print "";
print "";
print "";
print "". $SCRIPT_TITLE. "
";
print "【". $PENTA_OCEAN. "】";
print "";
print "";
print "";
print "
";
//================================================
// データベース接続
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//================================================
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
");
if (!$conn)
{
throw new Exception("データベースへの接続に失敗しました");
}
//===============================================
// POST、GETパラメータの受け取り
// 備考 ：
// 更新 ： 2012/11/01 KMK-Teraoka
//===============================================
extract($_POST);
if(!strcmp("登録",$regist))
{
$select = "SELECT * FROM " .$REGISTRANT_TABLE ." WHERE name='" .$name ."'";
$res = pg_query($conn,$select);
if(!pg_num_rows($res))
{
$insert = "INSERT INTO " .$REGISTRANT_TABLE ." (name,upddatetime, regdatetime)";
$insert .= " VALUES ('" .$name ."'," ."current_timestamp, current_timestamp)";
$res_i = pg_query($conn,$insert) or die(pg_last_error() .$insert ."
");
$select = "SELECT * FROM " .$REGISTRANT_TABLE ;
$res = pg_query($conn,$select);
$fp = fopen($FILE_OUTPUT_PATH,"w");
for($i = 0;$i < pg_num_rows($res);$i++)
{
$row = pg_fetch_array($res,$i);
fwrite($fp,$row['name'] ."\n");
}
fclose($fp);
print "新規に\"" .$name ."\"が登録されました。";
}
else
{
print "" ."登録者名\"".$name ."\"は既に登録されています。" ."
";
}
}
print "";
print "
";
print "戻る" ."";
//===============================================
// Postgresql終了処理
// 備考 ：
// 更新 ： 2012/11/01 KMK-Teraoka
//===============================================
pg_close($conn);
//===============================================
// HTML終了処理
// 備考 ：
// 更新 ： 2012/11/01 KMK-Teraoka
//===============================================
print "
";
print "";
print "";
print "";
print "";
print $TAIL_PENTA_OCEAN;
print "";
print "";
print "";
print "";
print "";
print "