<?php

// 依存ファイルの読み込み
include "dblogin.php";
include "function.php";

if(!empty($_GET['city'])){
	$param = "city";
	$header = "";
	$footer = "の日帰り温泉と立ち寄り湯";
}elseif(!empty($_GET['ingredient_1'])){
	$param = "ingredient_1";
	$header = "信州長野の";
	$footer = "";
}elseif(!empty($_GET['ingredient_2'])){
	$param = "ingredient_2";
	$header = "信州長野の";
	$footer = "";
}

$rs = mysqli_query($DB, "SELECT * FROM spa");

while($arr_item = mysqli_fetch_assoc($rs)){
	if($arr_item[$param]==$_GET[$param]){
	    $html  =  get_header_html("温泉リスト, 信州長野の日帰り温泉, $header$_GET[$param]$footer", "$header$_GET[$param]$footer", "/onsen/nagano", create_gmaps("area != 0 AND $param = \"$_GET[$param]\"", 10), get_itemlist_schema("SELECT * FROM spa WHERE area != 0 AND $param = \"$_GET[$param]\""));
		$html .= "<h2>$header$_GET[$param]$footer</h2>\n";
		$html .= "<div id=\"map\" style=\"width:100%; height:500px;\">Loading...</div>\n";
		$html .= create_listtable_html("","$_GET[$param]","SELECT * FROM spa WHERE area != 0 AND $param = \"$_GET[$param]\"");
		$html .= "</div>\n";
		$html .= get_nagano_submenu_html();
		$html .= "</body>\n";
		$html .= "</html>";	
	}
}

if(empty($html)){
		echo get_header_html("信州長野の日帰り温泉", "検索結果が見つかりません", "/onsen/nagano", NULL, NULL);
		echo "<h2>検索結果が見つかりません</h2>";
		echo "<p>お探しの温泉は見つかりませんでした</p>";
		echo "</div>";
		echo get_nagano_submenu_html();
		echo "</body>";
		echo "</html>";
EOD;
}else{
	echo $html;
}

?>