= "4.1.0"){
extract($_GET);
extract($_POST);
extract($_COOKIE);
extract($_SERVER);
}
$areakey = array('北海道','東北','関東','中部','近畿','中国','四国','九州・沖縄');
$area[0] = array('北海道');//北海道 1
$area[1] = array('青森県','岩手県','宮城県','秋田県','山形県','福島県');//東北 6
$area[2] = array('茨城県','栃木県','群馬県','埼玉県','千葉県','東京都','神奈川県');//関東 7
$area[3] = array('新潟県','富山県','石川県','福井県','山梨県','長野県','岐阜県','静岡県','愛知県');//中部 9
$area[4] = array('三重県','滋賀県','京都府','大阪府','兵庫県','奈良県','和歌山県');//近畿 7
$area[5] = array('鳥取県','島根県','岡山県','広島県','山口県');//中国 5
$area[6] = array('徳島県','香川県','愛媛県','高知県');//四国 4
$area[7] = array('福岡県','佐賀県','長崎県','熊本県','大分県','宮崎県','鹿児島県','沖縄県');//九州 沖縄 8
$arealist = array(); //2021/09/07 Add
$alljapan = array(); //2021/09/07 Add
if($areaid != '' && count($area) >= $areaid){
$arealist = $area[$areaid];
$areaidparam1 = "'FlashVars','areaid=".$areaid."',";
$areaidparam2 = "";
}else{
foreach ($area as $tmp){
$arealist = array_merge($alljapan, $tmp);
}
}
$con = pg_connect($connect_string);
$setencode = "SET CLIENT_ENCODING TO 'UNICODE'";
pg_exec($con,$setencode);
$sql = "select distinct on(area_no) address_1 from cliniclist where (list_up != '')";
$rst2 = pg_query($con , $sql);
//while($col = mysql_fetch_array($rst2)) {
while($col = pg_fetch_array($rst2)) {
$exsitlist[] = $col["address_1"];
}
pg_free_result($rst2);
$con = pg_close($con);
$resultlist = array_intersect($arealist, $exsitlist);
if($areaid != ''){
foreach ($resultlist as $tmp) {
$list .= "".$tmp."".'（'.countByAddress1($tmp)."件）
";
}
}
foreach ($areakey as $key => $value) {
$linklist[] = ''.$value.'';
}
$linkstr = implode(' | ',$linklist);
if($ken != ''){
$cliniclist = getListByAddress1($ken);
$clinicnum = countByAddress1($ken);
//2021/09/07 Mod --- Before ---
// $kenutf = mb_convert_encoding($ken, "UTF-8");
//2021/09/07 Mod --- After ---
$kenutf = mb_convert_encoding($ken, "UTF-8","AUTO");
//2021/09/07 Mod --- End ---
$kentitle = "“".$kenutf."”のおすすめ歯医者さん（全".$clinicnum."件）
";
}
?>
";
while($col = pg_fetch_array($result)) {
$temp .= "";
$temp .= "〒";
$temp .= $col['zip']." ";
$temp .= $col['address_1'].$col['address_2']."
";
$temp .= 'お問い合わせ : '.$col['tel']."
";
if($col['url'] != ''){
$temp .= 'http://'.$col['url']."
";
}
$temp .= "
";
}
$temp .= "";
pg_free_result($result);
pg_close($db);
return $temp;
} 
