File "insert.php"

Full path: /www/ansys/qgis/011_yokohama/map/insert.php
File size: 1.47 KiB (1501 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";
$LOG_FILE = "./log/view.log";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2012/11/29 KMK-Teraoka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");
if (!$conn)
{
	throw new Exception("データベースへの接続に失敗しました");
}


$time_ = date("Y-m-d H:i:s" ,time());
$pno = 35;
/*
for($i = 65;$i<1286;$i= $i+20)
{
	for($j = 238;$j<419;$j= $j+20)
	{
		$ins = "INSERT INTO qgis.yokohama_point(pno, x, y, upddatetime, regdatetime)";
		$ins .="VALUES (";
		$ins .= $pno .",";
		$ins .= $i .",";
		$ins .= $j .",";
		$ins .= "'" .$time_ ."',";
		$ins .= "'" .$time_ ."');";

		//			print $upArea ."<BR>";
		if (!($resData = pg_query($conn, $ins)))
		{
		//				print  pg_last_error(). "<br />";
		//				throw new Exception("データの登録に失敗しました<br />". $insArea. "<br />". pg_last_error(). "<br />");
		}
		
		$pno = $pno+1;
	}
}
*/

for($i = 662;$i<1286;$i++)
{
	$upd ="UPDATE qgis.yokohama_point";
	$upd .=" SET pno=" .$i;
	$upd .=" WHERE id =" .$i .";";
	if (!($resData = pg_query($conn, $upd)))
	{
	//				print  pg_last_error(). "<br />";
	//				throw new Exception("データの登録に失敗しました<br />". $insArea. "<br />". pg_last_error(). "<br />");
	}
}

print "</body>";
print "</html>";

?>