データベースにアクセスできません。' . "\n"; $HTML = mb_ereg_replace("
.*?", $ErrMsg, $HTML); $HTML = mb_ereg_replace("", '', $HTML); PutHeader(); echo $HTML; die; } switch ($q['_mode']){ // 産地から探す case 'area': mb_ereg_search_init($HTML); //工芸品リストテンプレ取得 $Target=mb_ereg_search_regs("(.*?)"); if(!$Target){ $CraftListBaseTags=''; }else{ $CraftListBaseTags=$Target[1]; } unset($Target); //テンプレ部分削除 $HTML = mb_ereg_replace(".*?", '', $HTML); $c_area_name=$cityCate[$q['area']]; $HTML = mb_ereg_replace("", $c_area_name, $HTML); //クリッカブルマップ $MapList=new db(ViewCraftCityTarget); if(!$MapList){ $HTML = mb_ereg_replace(".*?", '', $HTML); }else{ $res=$MapList->Select(); //すべて取得 if(!$res){ if($MapList->err===0){ //0件 $HTML = mb_ereg_replace(".*?", '', $HTML); } }else{ //工芸品あり foreach ($res as $r){ $Rows[]=$r['area']; } foreach ($cityCate as $k=>$v){ if(array_search($v,$Rows)===false){ $mString='.*?'; $HTML = mb_ereg_replace($mString, '', $HTML); }else{ $mString='href="list.php\?_mode=area" alt="' . $v . '"'; $mString2='href="list.php?_mode=area&area=' . $k . '" alt="' . $v . '"'; $HTML = mb_ereg_replace($mString, $mString2, $HTML); } } } } $wCond='(c_area1=$1)or(c_area2=$1)or(c_area3=$1)or(c_area4=$1)or(c_area5=$1)'; $arVal[1]=$c_area_name; break; // 種類から探す default: mb_ereg_search_init($HTML); //種類ナビテンプレ取得 $Target=mb_ereg_search_regs("(.*?)"); if(!$Target){ $cWkTypeNaviBaseTags=''; }else{ $cWkTypeNaviBaseTags=$Target[1]; } unset($Target); //テンプレ部分削除 $HTML = mb_ereg_replace(".*?", '', $HTML); //工芸品リストテンプレ取得 $Target=mb_ereg_search_regs("(.*?)"); if(!$Target){ $CraftListBaseTags=''; }else{ $CraftListBaseTags=$Target[1]; } unset($Target); //テンプレ部分削除 $HTML = mb_ereg_replace(".*?", '', $HTML); $HTML = mb_ereg_replace("", $craftTypeCate[$q['wk']], $HTML); //ナビ生成 $c_wk_type_navi=''; for($i=0;$iSelect($wCond,$arVal,$OrderBy); if(!$Rows){ if($CraftDat->err==0){ $ErrMsg='該当するものはありません。'; }else{ $ErrMsg='データを取得できませんでした'; } $CraftListTag=$CraftListBaseTags; $CraftListTag = mb_ereg_replace("", '', $CraftListTag); $CraftListTag = mb_ereg_replace("", 'top02.jpg', $CraftListTag); $CraftListTag = mb_ereg_replace("", $imgH, $CraftListTag); $CraftListTag = mb_ereg_replace("", $imgW, $CraftListTag); $CraftListTag = mb_ereg_replace("", $ErrMsg, $CraftListTag); $HTML = mb_ereg_replace("", $CraftListTag, $HTML); PutHeader(); echo $HTML; die; } $CraftList=''; shuffle($Rows); foreach ($Rows as $r){ $CraftListTag=$CraftListBaseTags; $CraftListTag = mb_ereg_replace("", '?id=' . $r['c_id'] . '&_mode=' . $q['_mode'], $CraftListTag); if(is_null($r['c_img4list'])){ $CraftListTag = mb_ereg_replace("", 'top02.jpg', $CraftListTag); }else{ $CraftListTag = mb_ereg_replace("", $r['c_id'] . '/' . $r['c_img4list'], $CraftListTag); } $CraftListTag = mb_ereg_replace("", $imgH, $CraftListTag); $CraftListTag = mb_ereg_replace("", $imgW, $CraftListTag); $CraftListTag = mb_ereg_replace("", $r['c_name'], $CraftListTag); $CraftListTag = mb_ereg_replace("", strip_tags($r['c_summ']), $CraftListTag); //産地 $area=''; if(!is_null($r['c_area1'])){ if(!is_null($r['c_area_old1'])){ $area='' . $r['c_area1'] . '' . $r['c_area_old1'] . '' . "\n"; }else{ $area='' . $r['c_area1'] . '' . "\n"; } } if(!is_null($r['c_area2'])){ if(!is_null($r['c_area_old2'])){ $area .='' . $r['c_area2'] . '' . $r['c_area_old2'] . '' . "\n"; }else{ $area .='' . $r['c_area2'] . '' . "\n"; } } if(!is_null($r['c_area3'])){ if(!is_null($r['c_area_old3'])){ $area .='' . $r['c_area3'] . '' . $r['c_area_old3'] . '' . "\n"; }else{ $area .='' . $r['c_area3'] . '' . "\n"; } } if(!is_null($r['c_area4'])){ if(!is_null($r['c_area_old4'])){ $area .='' . $r['c_area4'] . '' . $r['c_area_old4'] . '' . "\n"; }else{ $area .='' . $r['c_area4'] . '' . "\n"; } } if(!is_null($r['c_area5'])){ if(!is_null($r['c_area_old5'])){ $area .='' . $r['c_area5'] . '' . $r['c_area_old5'] . '' . "\n"; }else{ $area .='' . $r['c_area5'] . '' . "\n"; } } $CraftListTag = mb_ereg_replace("", $area,$CraftListTag); $CraftList .= $CraftListTag; unset($CraftListTag); } $HTML = mb_ereg_replace("", $CraftList, $HTML); PutHeader(); echo $HTML; ?>