=current_date AND $sql = "SELECT * FROM shop WHERE shop_publish=1 ORDER BY shop.upper_update DESC"; $rst = mysqli_query($con,$sql); if(!$sql){ print("SQLの実行に失敗しました。\n"); exit; } $size = mysqli_num_rows($rst); ////////// エリア読み込み ////////// $area_sql = "SELECT * FROM area WHERE area_id >0"; $area_result = mysqli_query($con,$area_sql); if(!$area_sql){ print("SQLの実行に失敗しました。\n"); exit; } while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } ////////// スマホページへリダイレクト ////////// $redirect = <<< TAGSET TAGSET; $title = "掲載店舗一覧 | 【京町ばいと】 京都の風俗求人・ナイトワーク情報"; include("./temp.php"); echo $head; echo $header; ?>
全店舗の募集情報  件ヒットしました!
", " ", $rec_message); $rec_message_vip = mb_strimwidth($rec_message, 0, 680, "...","UTF-8"); $rec_message_standard = mb_strimwidth($rec_message, 0, 340, "...","UTF-8"); $rec_message_free = mb_strimwidth($rec_message, 0, 220, "...","UTF-8"); $rec_message_sb = mb_strimwidth($rec_message, 0, 110, "...","UTF-8"); $rec_img_main = $rec_data["rec_img_main"]; $rec_syokusyu = $rec_data["rec_syokusyu"]; $rec_kyuyo = $rec_data["rec_kyuyo"]; $rec_kyuyo = str_replace("
", " ", $rec_kyuyo); $rec_kyuyo_vip = mb_strimwidth($rec_kyuyo, 0, 80, "...","UTF-8"); $rec_kyuyo_standard = mb_strimwidth($rec_kyuyo, 0, 70, "...","UTF-8"); $rec_kinmuchi = $rec_data["rec_kinmuchi"]; $rec_kinmuchi = str_replace("
", " ", $rec_kinmuchi); $rec_kinmuchi_vip = mb_strimwidth($rec_kinmuchi, 0, 80, "...","UTF-8"); $rec_kinmuchi_standard = mb_strimwidth($rec_kinmuchi, 0, 70, "...","UTF-8"); $rec_kinmuchi_free = mb_strimwidth($rec_kinmuchi, 0, 70, "...","UTF-8"); $rec_taigu_text = $rec_data["rec_taigu_text"]; for($i=1; $i<37; $i++){${'rec_taigu_'.$i} = $rec_data["rec_taigu_{$i}"];} $rec_update = $rec_data["rec_update"]; break; } //////////エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); if(!$area_sql){ print("SQLの実行に失敗しました。\n"); exit; } while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } //////////衣装読み込み////////// $costume_sql = "SELECT * FROM costume WHERE costume_id ='".$shop_costume."'"; $costume_result = mysqli_query($con,$costume_sql); if(!$costume_sql){ print("SQLの実行に失敗しました。\n"); exit; } while($costume_data = mysqli_fetch_array($costume_result)){ $costume_name_en = $costume_data["costume_name_en"]; $costume_name_jp = $costume_data["costume_name_jp"]; } ////////// ロイヤルVIP求人掲載コース ////////// if($shop_course=="30"){ $body.= <<< SET SET; } ////////// 有料掲載コース ////////// elseif($shop_course=="20"){ $body.= <<< SET SET; } ////////// 無料掲載 ////////// elseif($shop_course=="10"){ $body.= <<< SET
{$shop_name}
業種 {$shop_genre_name} 場所 {$rec_kinmuchi_free}
店舗メッセージ
{$rec_message_free}
お店の詳細を見る ≫
SET; } $banner_count++; if($banner_count == 5){ $body.= <<< SET
PR広告 {$search_rectangle_banner}
SET; } } if($banner_count > 6 or $banner_count < 5 ){ $body.= <<< SET
PR広告 {$search_rectangle_banner}
SET; } mysqli_free_result($recordSet); echo $body; echo <<< SET
  • 最初から見る
  • SET; if ($page > 1) { echo <<< SET
  • 前のページへ
  • SET; } else { echo <<< SET
  • 前のページへ
  • SET; } if ($page < $maxPage) { echo <<< SET
  • 次のページへ
  • SET; } else { echo <<< SET
  • 次のページへ
  • SET; } echo <<< SET
SET; ?>