hanedaqr

File "registrant_regist.php"

Full path: /www/haneda/qr/registrant_regist.php
File size: 3.79 KiB (3877 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php
//===============================================
//	CommonUtilities
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================

$PENTA_OCEAN = "五洋・清水特定建設工事企業体";
$TAIL_PENTA_OCEAN = "penta-ocean";
$SCRIPT_TITLE = "登録者の登録";

$TOP_FORM = "./index.php";
$HOST = "192.168.100.153";
$DB = "pntdb";
$USER = "postgres";
$PASS = "am#71ZJ*";
$REGISTRANT_TABLE = "qr.registrant_data";
$FILE_OUTPUT_PATH = "registrant.txt";

//===============================================
//	HTML-HEAD-
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>". $SCRIPT_TITLE. "</title>";
print "</head>";

//===============================================
//	HTML-BODY部開始-
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
print "<body>";
print "<center>";
print "<font size=\"3\">";
print "<b>";
print "". $SCRIPT_TITLE. "<br>";
print "【". $PENTA_OCEAN. "】";
print "</b>";
print "</font>";
print "</center>";
print "<hr />";


	//================================================
	//	データベース接続
	//	備考		：	
	//	更新		：	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 ."<BR>");
		
		$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 "<font color=\"#FF0000\">" ."登録者名\"".$name ."\"は既に登録されています。" ."</font><br>";
	}
}

print "<form action=\"". $_SERVER['PHP_SELF']. "\" method=\"post\" style=\"display:inline\">";
print "<table><tr><td>名称</td><td><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"20\"></td></tr></table>";
print "<input type=\"submit\" name=\"regist\" value=\"登録\">";
print "</form>";

print "<br>";
print "<a href=\"" .$TOP_FORM ."\">戻る" ."</a>";



//===============================================
//	Postgresql終了処理
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
pg_close($conn);

//===============================================
//	HTML終了処理
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
print "<hr />";
print "<font size=\"3\" color=\"#000000\" face=\"Arial\">";
print "<center>";
print "<b>";
print "<i>";
print $TAIL_PENTA_OCEAN;
print "</i>";
print "</b>";
print "</center>";
print "</font>";
print "</body>";
print "</html>";
?>

PHP File Manager