200){ echo "ERROR!"; exit; }
if(mb_strlen($area)>100){ echo "ERROR!"; exit; }
if(mb_strlen($c)>20){ echo "ERROR!"; exit; }
if($st==0){ $st=""; }
if($pricefrom==0){ $pricefrom=""; }
if($priceto==0){ $priceto=""; }
?>
エリアマップ：エクスプロア中国トラベル
=$pricefrom"; }else{ $qstr_pricefrom=""; }
// if($priceto){ $qstr_priceto="AND p.price2<=$priceto"; }else{ $qstr_priceto=""; }
$offsetnum = $offset*15;
if($pricefrom=="" && $priceto==""){ $limitset = "LIMIT 16"; }else{ $limitset=""; }
if($pricefrom=="" && $priceto==""){ $offsetset = "OFFSET ".$offsetnum; }else{ $offsetset=""; }
include(SERVER_ROOT . "/dbcon.php");
$query=@sprintf("SELECT id,num,name,namejp,star1,gaiyo,lat,lng FROM hoteldata WHERE lat>0 AND lng>0 AND city='%s' $qstr_st $qstr_area $qstr_hotelname AND num IS NOT NULL ORDER BY star1 DESC,num DESC $offsetset $limitset"
,pg_escape_string($c));
$rtn=@pg_exec($query);
$n=@pg_num_rows($rtn);
$mapdata="";
$lat_center="";
$lng_center="";
$i_breaker=0;
for($i=0;$i<$n;$i++){
$datashow="";
$row=pg_fetch_array($rtn,$i);
$cldatafile = "data4/".$row['num'].".csv";
if(file_exists($cldatafile)){
$fp = fopen ($cldatafile,"r");
$row3 = @fgetcsv($fp,1024,",");
$roomtype = "";
for($i3=1;$i3=$row3[$j+2]){ $datashow="shex1"; break; }
}elseif($pricefrom!=""){
if($pricefrom<=$row3[$j+2]){ $datashow="shex1"; break; }
}else{
if($priceto>=$row3[$j+2]){ $datashow="shex1"; break; }
}
}
$j=$j+3;
}
}else{
$datashow="shex1";
}
}else{
if($pricefrom){ $ippan_qstr1 = "AND price2>=".$pricefrom; }else{ $ippan_qstr1=""; }
if($priceto){ $ippan_qstr2 = "AND price2<=".$priceto; }else{ $ippan_qstr2=""; }
$rtn2=pg_exec("SELECT roomcn,roomjp,tuka,price1,price2,breakfast FROM hotelprice WHERE num='{$row['num']}' AND date2>='NOW' AND price2>'-1' $ippan_qstr1 $ippan_qstr2 ORDER BY price2 ASC LIMIT 10");
$n2=@pg_numrows($rtn2);
if($rtn2 && $n2>0){
$datashow="ippan";
}
}
if(($pricefrom=="" && $priceto=="") || $datashow!=""){
$i_breaker++;
if(($pricefrom=="" && $priceto=="") || $offsetnum<$i_breaker){
$mapdata[$i_breaker]['lat']=$row['lat'];
$mapdata[$i_breaker]['lng']=$row['lng'];
$mapdata[$i_breaker]['id']=$row['id'];
$mapdata[$i_breaker]['num']=$row['num'];
$mapdata[$i_breaker]['star1']=$row['star1'];
$mapdata[$i_breaker]['namejp']=$row['namejp'];
$mapdata[$i_breaker]['gaiyo']=$row['gaiyo'];
if(!$lat_center){
$lat_center=$row['lat'];
$lng_center=$row['lng'];
}
}
}
if($i_breaker>=$offsetnum+20){ break; }
}
if($i_breaker>=1){
?>