getMessage()); } //引数取得 $shop_id = $_GET['shop_id']; // 店舗情報を取得 $sql = "select * from shop_info where shop_id = " . sprintf("%010d",$shop_id); $result = $db->query($sql); if (DB::isError( $result )) { echo "AAA" . mysql_error(); die($result->getMessage()); } if($row = $result->fetchRow()){ $shop_id = $row[0]; $shop_name = $row[2]; // 店名 $shop_addr = $row[3]; // 住所 $shop_access = $row[5]; // アクセス $shop_tel = $row[6]; // 電話番号 $shop_holiday = $row[14]; // 定休日 $shop_url = $row[15]; // HP $shop_memo = $row[22]; } if($shop_addr == ""){ $shop_addr = " "; } if($shop_access == ""){ $shop_access = " "; } if($shop_tel == ""){ $shop_tel = " "; } if($shop_holiday == ""){ $shop_holiday = " "; } if($shop_url == ""){ $shop_url = " "; } ?> 常磐線沿線のラーメン屋さん大集合 <?php print $shop_name; ?>

     じょうばんネットPresents    

 

 

"; ?>

メニュー・地図

query($sql2); if (DB::isError( $result2 )) { die($result2->getMessage()); } if($row2 = $result2->fetchRow()){ $item_name = $row2[1]; $item_photo = $row2[3]; $item_price = $row2[2]; $item_special_note = $row2[4]; } ?>

"; ?>

query($sql5); if (DB::isError( $result5 )) { die($result5->getMessage()); } $tate = -40; $yoko = 0; $bbs_cnt = 0; while($row5 = $result5->fetchRow()){ $uma = $row5[0]; $koteasa = $row5[1]; $yoko_tmp = 0; $tate_tmp = 0; //ウマは1ごとに10 switch($uma) { case "1ウマ": $tate_tmp = 1; break; case "2ウマ": $tate_tmp = 2; break; case "3ウマ": $tate_tmp = 3; break; case "4ウマ": $tate_tmp = 4; break; case "5ウマ": $tate_tmp = 5; break; case "6ウマ": $tate_tmp = 6; break; case "7ウマ": $tate_tmp = 7; break; case "8ウマ": $tate_tmp = 8; break; case "9ウマ": $tate_tmp = 9; break; case "10ウマ": $tate_tmp = 10; break; case "−": break; case "0": case "1": case "2": case "3": case "4": case "5": case "6": case "7": case "8": case "9": case "10": $tate_base = $uma * 10; break; } //こてあさは1ごとに20 switch($koteasa) { case "10こってり": $yoko_tmp = -10 * 2; break; case "9こってり": $yoko_tmp = -9 * 2; break; case "8こってり": $yoko_tmp = -8 * 2; break; case "7こってり": $yoko_tmp = -7 * 2; break; case "6こってり": $yoko_tmp = -6 * 2; break; case "5こってり": $yoko_tmp = -5 * 2; break; case "4こってり": $yoko_tmp = -4 * 2; break; case "3こってり": $yoko_tmp = -3 * 2; break; case "2こってり": $yoko_tmp = -2 * 2; break; case "1こってり": $yoko_tmp = -1 * 2; break; case "1あっさり": $yoko_tmp = 1 * 2; break; case "2あっさり": $yoko_tmp = 2 * 2; break; case "3あっさり": $yoko_tmp = 3 * 2; break; case "4あっさり": $yoko_tmp = 4 * 2; break; case "5あっさり": $yoko_tmp = 5 * 2; break; case "6あっさり": $yoko_tmp = 6 * 2; break; case "7あっさり": $yoko_tmp = 7 * 2; break; case "8あっさり": $yoko_tmp = 8 * 2; break; case "9あっさり": $yoko_tmp = 9 * 2; break; case "10あっさり": $yoko_tmp = 10 * 2; break; case "−": break; case "0": case "1": case "2": case "3": case "4": case "5": case "6": case "7": case "8": case "9": case "10": case "-1": case "-2": case "-3": case "-4": case "-5": case "-6": case "-7": case "-8": case "-9": case "-10": $yoko_base = $koteasa * 20; break; } if(( $tate_tmp != 0) || ($yoko_tmp != 0)){ $bbs_cnt = $bbs_cnt + 1; $tate_wk = $tate_wk - $tate_tmp; $yoko_wk = $yoko_wk + $yoko_tmp; } } $tate = $tate - $tate_base + $tate_base / (10 * 10) * $bbs_cnt + $tate_wk / $bbs_cnt; $yoko = $yoko + $yoko_base - $yoko_base / (20 * 10) * $bbs_cnt + $yoko_wk / $bbs_cnt; if($tate < -125){ $tate = -125; } if($yoko < -200){ $yoko = -200; } elseif($yoko > 200){ $yoko = 200; } // 表示用文字列作成 // ウマ $uma_moji = round( -1 * ($tate + 40) / 10 , 0) . "ウマ"; // こってりあっさり if($yoko > 0){ $koteasa_moji = round(($yoko) / 20 , 0) . "あっさり"; } elseif($yoko == 0){ $koteasa_moji = "こってりとあっさりの間"; } else{ $koteasa_moji = round( -1 * ($yoko) / 20 , 0) . "こってり"; } ?> "; print "
"; ?>
" . $uma_moji . " " . $koteasa_moji . ""; ?>

"; ?> コメントを読む

"; ?> コメントを書く

"; ?> 採点する

最寄駅
住所
電話番号
定休日
公式HP
query($sql2); if (DB::isError( $result2 )) { die($result2->getMessage()); } while($row2 = $result2->fetchRow()){ $item_id = $row2[0]; $item_name = $row2[1]; $item_photo = $row2[3]; $item_price = $row2[2]; $item_special_note = $row2[4]; ?>

"; ?>

 

query($sql4); if (DB::isError( $result4 )) { die($result4->getMessage()); } $cnt = 0; while($row4 = $result4->fetchRow()){ if($cnt == 1){ echo "query($sql4); if (DB::isError( $result4 )) { die($result4->getMessage()); } $cnt = 0; while($row4 = $result4->fetchRow()){ if($cnt == 1){ echo "
"; } elseif($cnt == 2){ echo ""; } elseif($cnt == 3){ echo ""; } elseif($cnt == 6){ echo ""; } else{ echo ""; } ?>

"; } elseif($cnt == 2){ echo ""; } elseif($cnt == 3){ echo ""; } elseif($cnt == 6){ echo ""; } else{ echo ""; } ?>

query($sql2); if (DB::isError( $result2 )) { die($result2->getMessage()); } $line_cnt = 1; while($row2 = $result2->fetchRow()){ $item_name2 = $row2[1]; $item_photo2 = $row2[3]; $item_price2 = $row2[2]; $item_special_note2 = $row2[4]; if($line_cnt % 2 == 1){ ?>

"; ?>

 

最近のコメント

query($sql2); if (DB::isError( $result2 )) { die($result2->getMessage()); } if($row2 = $result2->fetchRow()){ $max_com = $row2[0]; } if($max_com > 0){ $sql = "select bi.shop_id, bi.bbs_id, bi.title, bi.name, bi.value1, bi.value2, bi.comment, si.shop_name, am.area_name, bi.photo from bbs_info bi, shop_info si, area_mst am where bi.shop_id = " . sprintf("%010d",$shop_id) . " and bi.shop_id = si.shop_id and si.area_id = am.area_id and bi.bbs_id and comment != '採点のみ' order by bbs_id desc limit 5"; $result = $db->query($sql); if (DB::isError( $result )) { die($result->getMessage()); } while($row = $result->fetchRow()){ $shop_id = $row[0]; $bbs_id = $row[1]; $title = $row[2]; $name = $row[3]; $value1 = $row[4]; $value2 = $row[5]; $comment = $row[6]; $shop_name = $row[7]; $area_name = $row[8]; $photo = $row[9]; if($title == ""){ $titele = " "; } if($name == ""){ $name = "匿名の麺食いさん"; } if($value1 == ""){ $value1 = " "; } if($value2 == ""){ $value2 = " "; } if($comment == ""){ $comment = " "; } ?>

width="120" align="left" border="0">

まだコメントはありません

"; ?> コメントを読む

"; ?> コメントを書く

"; ?> 採点する

お品書き

【店舗情報】
・ラーメンTOP
・はじめに
・ラーメンの掲載基準
・味見表の見方
・駅別ラーメン店検索

【Enjoyラーメン】
・自宅でラーメン大集合
−−一覧
−−有名店のラーメン
−−インスタントラーメン
−−餃子
−−初めてご覧の方へ
・麺太のコラム
・じょうばんネットTOP


会社概要
じょうばんネット -Copyright (C) 2008-2009 AL-TEC Corporation. All Rights Reserved-