prepare("SELECT * FROM `shop` WHERE (`flg` = 0) AND (`shop_id` = :shop_id)"); $stmt -> execute(array(":shop_id" => $shop_id)); $shop = $stmt -> fetch() or header("Location: //keihan-girl.com/"); $stmt -> closeCursor(); $shop_id = $shop['shop_id']; $col = $shop['col'] == 0 ? "osaka" : "kyoto"; $shop_comment = h($shop['shop_comment']); $privilege = h($shop['privilege']); //visitsをインサート $device = "PC"; $date = new DateTime(); $created = $date->format('Y-m-d H:i:00'); $user = $_SERVER['HTTP_USER_AGENT']; $bot1 = "MauiBot (crawler.feedback+wc@gmail.com)"; $bot2 = "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"; $bot3 = "Mozilla/5.0 (compatible; DotBot/1.1; http://www.opensiteexplorer.org/dotbot, help@moz.com)"; $bot4 = "ltx71 - (http://ltx71.com/)"; $bot5 = "ICC-Crawler/2.0 (Mozilla-compatible; ; http://ucri.nict.go.jp/en/icccrawler.html)"; $bot6 = "Mozilla/5.0 (compatible; Dataprovider.com;)"; $bot7 = "BUbiNG (+http://law.di.unimi.it/BUbiNG.html)"; $bot8 = "CCBot/2.0 (http://commoncrawl.org/faq/)"; $bot9 = "Mozilla/5.0 (compatible; MegaIndex.ru/2.0; +http://megaindex.com/crawler)"; $bot10 = "Mozilla/5.0 (compatible; Linux x86_64; Mail.RU_Bot/2.0; +http://go.mail.ru/help/robots)"; $bot11 = "Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)"; $bot12 = "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"; $bot13 = "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)"; $bot14 = "The Knowledge AI"; $bot15 = "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"; $bot16 = "Mozilla/5.0 (compatible; Mappy/1.0; +http://mappydata.net/bot/)"; if($user == $bot1 || $user == $bot2 || $user == $bot3 || $user == $bot4 || $user == $bot5 || $user == $bot6 || $user == $bot7 || $user == $bot8 || $user == $bot9 || $user == $bot10 || $user == $bot11 || $user == $bot12 || $user == $bot13 || $user == $bot14 || $user == $bot15 || $user == $bot16){ //何もしない。 }else{ $stmt = $dbh -> prepare( "INSERT INTO visits (shop_id, device, user, created) VALUES (:shop_id, :device, :user, :created)" ); $stmt -> bindParam(":shop_id", $shop_id, PDO::PARAM_STR); $stmt -> bindParam(":device", $device, PDO::PARAM_STR); $stmt -> bindParam(":user", $user, PDO::PARAM_STR); $stmt -> bindParam(":created", $created, PDO::PARAM_STR); $stmt -> execute(); $stmt -> closeCursor(); } //エリア $stmt = $dbh -> prepare("SELECT * FROM `area` WHERE (`str` = '{$shop['area']}')"); $stmt -> execute(); $area = $stmt -> fetch(); $stmt -> closeCursor(); //業種 $stmt = $dbh -> prepare("SELECT * FROM `genre` WHERE (`str` = '{$shop['genre']}')"); $stmt -> execute(); $genre = $stmt -> fetch(); $stmt -> closeCursor(); //待遇タブ $treatment01 = $shop['treatment01'] == 0 ? "

日払いOK

" : "

日払いOK

"; $treatment02 = $shop['treatment02'] == 0 ? "

未経験者大歓迎

" : "

未経験者大歓迎

"; $treatment03 = $shop['treatment03'] == 0 ? "

新規オープン

" : "

新規オープン

"; $treatment04 = $shop['treatment04'] == 0 ? "

グループ店あり

" : "

グループ店あり

"; $treatment05 = $shop['treatment05'] == 0 ? "

朝・昼に働ける

" : "

朝・昼に働ける

"; $treatment06 = $shop['treatment06'] == 0 ? "

給与保証あり

" : "

給与保証あり

"; $treatment07 = $shop['treatment07'] == 0 ? "

ノルマ無し

" : "

ノルマ無し

"; $treatment08 = $shop['treatment08'] == 0 ? "

出張面接OK

" : "

出張面接OK

"; $treatment09 = $shop['treatment09'] == 0 ? "

交通費支給

" : "

交通費支給

"; $treatment10 = $shop['treatment10'] == 0 ? "

面接交通費支給

" : "

面接交通費支給

"; $treatment11 = $shop['treatment11'] == 0 ? "

土日も営業

" : "

土日も営業

"; $treatment12 = $shop['treatment12'] == 0 ? "

自由出勤

" : "

自由出勤

"; $treatment13 = $shop['treatment13'] == 0 ? "

終電上がりOK

" : "

終電上がりOK

"; $treatment14 = $shop['treatment14'] == 0 ? "

駅チカ

" : "

駅チカ

"; $treatment15 = $shop['treatment15'] == 0 ? "

寮完備

" : "

寮完備

"; $treatment16 = $shop['treatment16'] == 0 ? "

ドレス貸出

" : "

ドレス貸出

"; $treatment17 = $shop['treatment17'] == 0 ? "

送りあり

" : "

送りあり

"; $treatment18 = $shop['treatment18'] == 0 ? "

迎えあり

" : "

迎えあり

"; $treatment19 = $shop['treatment19'] == 0 ? "

WワークOK

" : "

WワークOK

"; $treatment20 = $shop['treatment20'] == 0 ? "

私服OK

" : "

私服OK

"; //新着情報 $news = array(); $sql = "SELECT * FROM `shop_news` WHERE (`flg` = 0) AND (`shop_id` = '{$shop_id}') ORDER BY `modified` DESC LIMIT 3"; foreach($dbh -> query($sql) as $row){ array_push($news, $row); } //先輩インタビュー $interview = array(); $sql = "SELECT * FROM `shop_interview` WHERE (`flg` = 0) AND (`shop_id` = '{$shop_id}') ORDER BY `no` ASC LIMIT 3"; foreach($dbh -> query($sql) as $row){ array_push($interview, $row); } ?> <?= h($shop['name']); ?> ｜ 【京阪ガール】 <?= $shop['col'] == 0 ? "大阪" : "京都"; ?>ナイトワーク専門！高時給バイト情報

【京阪ガール】ナイトワーク専門！高時給バイト情報

\"{$shop['name']}\"
"; ?>

お店コメント

".nl2br($shop_comment)."
"; ?>
今だけ特典！！

お店を画像でCheck!

" : "\"お店を画像でCheck!\""; ?>
  • " : "\"お店を画像でCheck!(1)\""; ?>
  • " : "\"お店を画像でCheck!(2)\""; ?>
  • " : "\"お店を画像でCheck!(3)\""; ?>

お店のPR動画

"; ?>

待遇

新着情報

    format('Y年m月d日'); $week = $date->format('w'); $dt2 = $date->format('H:i'); $news_comment = h($row['news_comment']); ?>

先輩インタビュー

店舗情報・募集情報詳細

店舗名
業種
電話番号(受付時間：".h($shop['reception_time']).")

"; ?>
現在の募集人数
体験入店時給
給与
応募資格
住所
担当者
ラインID".h($shop['lineid'])."

IDをコピーしてお使いください"; ?>
カカオID".h($shop['kakaoid'])."

IDをコピーしてお使いください"; ?>
勤務日
勤務時間
HPオフィシャルサイトはこちら"; ?>

求人応募・お問い合わせ

お名前・年齢
[必須]		 (満)
電話番号
[任意]
メールアドレス
[必須]
アプリID
[任意]		LINEkakao
メッセージ
[任意]