データベースにアクセスできません。' . "\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;$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);
$wCond='c_wk_type=$1';
$arVal[1]=$q['wk'];
break;
}
$imgH=$ImgSize['list']['height'];
$imgW=$ImgSize['list']['width'];
$OrderBy='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;
?>