hanedaqr

File "registrant_view.php"

Full path: /www/haneda/qr/registrant_view.php
File size: 3.18 KiB (3257 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";
$VIEW_FORM = "./work_list_details.php";
$HOST = "192.168.100.153";
$DB = "pntdb";
$USER = "postgres";
$PASS = "am#71ZJ*";
$REGISTRANT_TABLE = "qr.registrant_data";

//===============================================
//	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("データベースへの接続に失敗しました");
}

$select = "SELECT * FROM " .$REGISTRANT_TABLE ." ORDER BY id;";
$res = pg_query($conn,$select);
$data_ct = pg_num_rows($res);

//===============================================
//	見出し
//	備考		：	Table内TableでBorderを細くする
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
print "<table width=\"200\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr>";
print "<td align='center'>";
print "No";
print "</td>";
print "<td align='center'>";
print "登録者名";
print "</td>";
print "</tr>";

for($i = 0;$i < $data_ct;$i++)
{
	$row = pg_fetch_array($res,$i);
	$ii = $i+1;
	print "<tr align='center'>";
	print "<td>" .$ii ."</td>";
	print "<td>" .$row['name'] ."</td>";
	print "</tr>";
}

print "</table>";
print "<br />";
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