データベースにアクセスできません。' . "\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); $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); $wCond='c_wk_type=$1'; $arVal[1]=$q['wk']; break; } //ナビ mb_ereg_search_init($HTML); //種類ナビテンプレ取得 $Target=mb_ereg_search_regs("(.*?)"); if(!$Target){ $cWkTypeNaviBaseTags=''; }else{ $cWkTypeNaviBaseTags=$Target[1]; //エリアナビも共通 } unset($Target); //テンプレ部分削除 $HTML = mb_ereg_replace(".*?", '', $HTML); //ナビ生成 //種類 $c_wk_type_navi=''; for($i=0;$i", $url, $cWkTypeNaviTag); $cWkTypeNaviTag = mb_ereg_replace("", $c_wk_type_navi_name, $cWkTypeNaviTag); $c_wk_type_navi .= $cWkTypeNaviTag; unset($cWkTypeNaviTag); } $HTML = mb_ereg_replace("", $c_wk_type_navi, $HTML); //エリア $c_wk_area_navi=''; $MapList=new db(ViewCraftCityTarget); if(!$MapList){ $HTML = mb_ereg_replace(".*?", '', $HTML); }else{ $res=$MapList->Select(); //すべて取得 if(!$res){ $HTML = mb_ereg_replace(".*?", '', $HTML); }else{ foreach($res as $L){ $City=$L['area']; $i=array_search($City,$cityCate); if($i!==false){ $c_wk_area_navi_name=$cityCate[$i]; $url= CraftList . '?_mode=area&area=' . $i; $cWkAreaNaviTag = $cWkTypeNaviBaseTags; $cWkAreaNaviTag = mb_ereg_replace("", $url, $cWkAreaNaviTag); $cWkAreaNaviTag = mb_ereg_replace("", $c_wk_area_navi_name, $cWkAreaNaviTag); $c_wk_area_navi .= $cWkAreaNaviTag; unset($cWkAreaNaviTag); } } } } $HTML = mb_ereg_replace("", $c_wk_area_navi, $HTML); $imgH=$ImgSize['list']['height']; $imgW=$ImgSize['list']['width']; $OrderBy='c_type'; //'c_id'; $Rows=$CraftDat->Select($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; ?>