PHP File Manager

File "index.php"
Full path: /www/co2/index.php
File size: 2.28 KiB (2331 bytes)
MIME-type: text/html
Charset: utf-8
<HTML>
<HEAD>
<META Http-Equiv="Content-Type" Content="text/html;charset=UTF-8">
<TITLE>CO2調査現場一覧</TITLE>
</HEAD>

<BODY>
<B>
<FONT SIZE=3>
CO2調査現場一覧<BR>
</FONT>
</B>

<hr>
<?php

$DATA_TABLE = "gps.constructions";
$HOST = "localhost";
$DB = "ichimill";
$USER = "postgres";
$PASS = "postgres";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");


$sql = "SELECT * FROM " .$DATA_TABLE ." WHERE delflag='false' ORDER BY id";
$res = pg_query($conn, $sql) or die("SQL ERROR!!<br />". $sql.pg_last_error());
$ct = pg_num_rows($res);


//
print "<TABLE border='0'>";
print "<TR>";
print "<TD>";
print "<FORM NAME='formName' enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' METHOD='post'>";
print "<INPUT TYPE='submit' NAME='up' VALUE='更新' style='width:50px;height:25px;font-size:10pt'>";
print "</FORM>";
print "</TD>";
print "<TD>";
print "<FORM NAME='formName' enctype='multipart/form-data' action='const_regist.php' METHOD='post' TARGET='_blank'>";
print "<INPUT TYPE='submit' NAME='edit' VALUE='現場の登録・編集' style='width:120px;height:25px;font-size:10pt'>";
print "</FORM>";
print "</TD>";
print "</TR>";
print "</TABLE>";




print "<TABLE BORDER='0'>";

for($i = 0;$i < $ct;$i++)
{
	$row = pg_fetch_array($res,$i);
	$id = $row['id'];
	$name = $row['const_name'];
	
	$url =  "data_view.php?id=" .$id;

	print "<TR valign='top'>";

	print "<TD>";
	print "&nbsp;・";
	print "<TD>";
	print "<B><A HREF='" .$url ."' target='_BLANK'>" .$name ."</A></B>";
	print "</TD><TD>";
	print "&nbsp;&nbsp;&nbsp;&nbsp;";
	print "</TD>";
	print "</TR>";
}

print "</TABLE>";

print "<BR>";



function Pulldown_create($width ,$data_,$selected)
{
	$value_ct = count($data_);
	print "<select name='date'  style='width:" .$width ."px;'>";
	for($j= 0 ;$j < $value_ct;$j++)
	{
		$unix = strtotime($data_[$j]);
		$sel = ($j== 0) ? "selected" : "";
		print "<option value='" .$unix ."' " .$sel ." >" .$data_[$j] ."</option>";
	}
	print "</select>";

}

?>

<HR>
<!--
<FONT SIZE=5>
<CENTER><I><B>
penta-ocean<BR>
<BR></B></I>
</CENTER>
</FONT>
-->
</BODY>
</HTML>