9 AND shop_publish=1 AND shop_pref='".$pref_no."' AND special_set=1"; $special_check_result = mysqli_query($con,$special_check_sql); while($special_check_data = mysqli_fetch_array($special_check_result)){ $special_check_id = $special_check_data["shop_id"]; break; } if($special_check_id>0){ ////////// specialテーブル読み込み //////////// $sql = "SELECT * FROM special WHERE special_id>0 ORDER BY special_update DESC LIMIT 1"; $result = mysqli_query($con,$sql); while($special_data = mysqli_fetch_array($result)){ $special_id = $special_data["special_id"]; $special_img = $special_data["special_img"]; $special_pcbanner_1 = $special_data["special_pcbanner_1"]; $special_pcbanner_2 = $special_data["special_pcbanner_2"]; $special_spbanner_1 = $special_data["special_spbanner_1"]; } echo <<< EOF
今月の特集
EOF; } ?>

注目のピックアップ求人

{$pickup_shop_name}
EOF; } ?>

エリアで探す

    9 AND shop_publish=1 AND (shop_area='".$area_id."' OR shop_subarea_1 ='".$area_id."' OR shop_subarea_2 ='".$area_id."' OR shop_subarea_3 ='".$area_id."' OR shop_subarea_4 ='".$area_id."')"; $shop_check_result = mysqli_query($con,$shop_check_sql); while($shop_check_data = mysqli_fetch_array($shop_check_result)){ $shop_check_id = $shop_check_data["shop_id"]; break; } if($shop_check_id){ echo <<< EOF
  • {$area_name_jp}
    • EOF; $shop_check_id=""; } } ?>

衣装別で探す

    {$costume_name_jp}
    EOF; $shop_check_id=""; } else{ echo <<< EOF
  • {$costume_name_jp}
    • EOF; $shop_check_id=""; } } ?>
0){ echo <<< EOF
即日体入できるお店一覧
EOF; } ?>

女性Q＆A質問板

EOF; ?>

注目のピックアップ求人
体入祝い金プレゼント｜Sプリワークから￥8,000もらえる！しかも最短即日！
9 AND shop.shop_publish=1 AND shop.shop_pref='".$pref_no."'"; $experience_check_result = mysqli_query($con,$experience_check_sql); while($experience_check_data = mysqli_fetch_array($experience_check_result)){ $experience_check_id = $experience_check_data["experience_id"]; break; } if($experience_check_id>0){ echo <<< EOF

みんなの体験談

  • EOF; $ex_cnt="1"; ////////// experienceテーブル読み込み //////////// $experience_sql = "SELECT * FROM experience,shop WHERE experience.experience_shop_id=shop.shop_id AND shop.shop_course>9 AND shop.shop_publish=1 AND shop.shop_pref='".$pref_no."' ORDER BY experience.experience_update DESC LIMIT 4"; $experience_result = mysqli_query($con,$experience_sql); while($experience_data = mysqli_fetch_array($experience_result)){ $experience_id = $experience_data["experience_id"]; $experience_shop_id = $experience_data["experience_shop_id"]; $experience_year = $experience_data["experience_year"]; $experience_month = $experience_data["experience_month"]; $experience_day = $experience_data["experience_day"]; $experience_text = $experience_data["experience_text"]; $experience_update = $experience_data["experience_update"]; $experience_shopname = $experience_data["shop_name"]; $experience_shoparea = $experience_data["shop_area"]; $experience_shopcode = $experience_data["shop_code"]; //////////掲載中エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$experience_shoparea."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_pref_en = pref_en($area_pref); $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } echo <<< EOF

    {$experience_shopname}

    エリア：{$area_name_jp}
    体験日：{$experience_year}/{$experience_month}/{$experience_day}

    {$experience_text}
    EOF; $ex_cnt++; if($ex_cnt==3){ echo <<< EOF
  • EOF; } elseif($ex_cnt==5){ echo <<< EOF
    • EOF; } } echo <<< EOF
EOF; } ?> 9 AND shop.shop_publish=1 AND interview.interview_display=1 AND interview.interview_list>0 AND shop.shop_pref='".$pref_no."'"; $interview_check_result = mysqli_query($con,$interview_check_sql); while($interview_check_data = mysqli_fetch_array($interview_check_result)){ $interview_check_id = $interview_check_data["interview_id"]; break; } if($interview_check_id>0){ echo <<< EOF

教えて先輩!!直撃インタビュー

    EOF; $itv_cnt="1"; ////////// interviewテーブル読み込み //////////// $interview_sql = "SELECT * FROM shop,interview WHERE interview.interview_shop_id=shop.shop_id AND shop.shop_rank>9 AND shop.shop_publish=1 AND interview.interview_display=1 AND interview.interview_list>0 AND shop.shop_pref='".$pref_no."' ORDER BY shop.upper_update DESC, interview.interview_display ASC LIMIT 10"; $interview_result = mysqli_query($con,$interview_sql); while($interview_data = mysqli_fetch_array($interview_result)){ $interview_id = $interview_data["interview_id"]; $interview_shop_id = $interview_data["interview_shop_id"]; $interview_girl_img = $interview_data["interview_girl_img"]; $interview_girl_name = $interview_data["interview_girl_name"]; $interview_girl_age = $interview_data["interview_girl_age"]; $interview_girl_gessyu = $interview_data["interview_girl_gessyu"]; $interview_girl_reki = $interview_data["interview_girl_reki"]; $interview_girl_time = $interview_data["interview_girl_time"]; $interview_girl_mokuhyo = $interview_data["interview_girl_mokuhyo"]; $interview_girl_kikkake = $interview_data["interview_girl_kikkake"]; $interview_display = $interview_data["interview_display"]; if($interview_display == "1"){ $interview_display_text = "表示"; $interview_display_1_selected = " selected"; } else{ $interview_display_text = "非表示"; $interview_display_2_selected = " selected"; } $interview_update = $interview_data["interview_update"]; $interview_shopname = $interview_data["shop_name"]; $interview_shoparea = $interview_data["shop_area"]; $interview_shopcode = $interview_data["shop_code"]; //////////掲載中エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$interview_shoparea."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_pref_en = pref_en($area_pref); $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } echo <<< EOF
  • {$interview_girl_name}さん
    {$interview_shopname}
    {$interview_girl_name} さん
    • EOF; } echo <<< EOF
EOF; } ?> 9 AND shop.shop_publish=1 AND shop.shop_pref='".$pref_no."'"; $message_check_result = mysqli_query($con,$message_check_sql); while($message_check_data = mysqli_fetch_array($message_check_result)){ $message_check_id = $message_check_data["message_id"]; break; } if($message_check_id>0){ echo <<< EOF

新着リアルタイム店長のつぶやき

    EOF; ////////// messageテーブル読み込み //////////// $message_sql = "SELECT * FROM message,shop WHERE message.message_shop_id=shop.shop_id AND shop.shop_pref='".$pref_no."' AND shop.shop_course>9 AND shop.shop_publish=1 ORDER BY message.message_update DESC LIMIT 4"; $message_result = mysqli_query($con,$message_sql); while($message_data = mysqli_fetch_array($message_result)){ $message_id = $message_data["message_id"]; $message_shop_id = $message_data["message_shop_id"]; $message_title = $message_data["message_title"]; $message_text = $message_data["message_text"]; $message_text = strip_tags($message_text); $message_shopname = $message_data["shop_name"]; $message_shoparea = $message_data["shop_area"]; $message_shopcode = $message_data["shop_code"]; $message_shop_tanto_img = $message_data["shop_tanto_img"]; if($message_shop_tanto_img){$tanto_img="{$fhttp}{$pref_en}.{$fdomain}/{$message_shopcode}/img/{$message_shop_tanto_img}";} else{$tanto_img="{$furl}/img/message_nophoto.jpg";} //////////掲載中エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$message_shoparea."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_pref_en = pref_en($area_pref); $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } echo <<< EOF
  • {$message_shopname}

    {$message_title}

    {$message_text}

    • EOF; } echo <<< EOF
EOF; } ?> 9 AND shop.shop_publish=1 AND shop.shop_pref='".$pref_no."'"; $movie_check_result = mysqli_query($con,$movie_check_sql); while($movie_check_data = mysqli_fetch_array($movie_check_result)){ $movie_check_id = $movie_check_data["movie_id"]; break; } if($movie_check_id>0){ echo <<< EOF

働く前に知れる!!求人動画

    EOF; ////////// movieテーブル読み込み //////////// $movie_sql = "SELECT * FROM movie,shop WHERE movie.movie_shop_id=shop.shop_id AND shop.shop_pref='".$pref_no."' AND shop.shop_course>9 AND shop.shop_publish=1 ORDER BY shop.upper_update DESC LIMIT 2"; $movie_result = mysqli_query($con,$movie_sql); while($movie_data = mysqli_fetch_array($movie_result)){ $movie_id = $movie_data["movie_id"]; $movie_shop_id = $movie_data["movie_shop_id"]; $movie_code = $movie_data["movie_code"]; $movie_shop_id = $movie_data["shop_id"]; $movie_shopname = $movie_data["shop_name"]; $movie_shopcode = $movie_data["shop_code"]; ////// recruit読み込み $recruit_sql = "SELECT * FROM recruit WHERE rec_shop_id ='".$movie_shop_id."'"; $recruit_result = mysqli_query($con,$recruit_sql); while($recruit_data = mysqli_fetch_array($recruit_result)){ $rec_message = $recruit_data["rec_message"]; $rec_message = strip_tags($rec_message); } //////////掲載中エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$message_shoparea."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_pref_en = pref_en($area_pref); $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } echo <<< EOF

  • 急募{$movie_shopname}

    {$rec_message}

    • EOF; } echo <<< EOF
EOF; } ?> 9 AND shop_publish=1 AND shop_pref='".$pref_no."' AND special_set=1"; $special_check_result = mysqli_query($con,$special_check_sql); while($special_check_data = mysqli_fetch_array($special_check_result)){ $special_check_id = $special_check_data["shop_id"]; break; } if($special_check_id>0){ ////////// specialテーブル読み込み //////////// $sql = "SELECT * FROM special WHERE special_id>0 ORDER BY special_update DESC LIMIT 1"; $result = mysqli_query($con,$sql); while($special_data = mysqli_fetch_array($result)){ $special_id = $special_data["special_id"]; $special_pcbanner_1 = $special_data["special_pcbanner_1"]; $special_pcbanner_2 = $special_data["special_pcbanner_2"]; $special_spbanner_1 = $special_data["special_spbanner_1"]; } echo <<< EOF
今月の特集
EOF; } ?>