prepare("SELECT * FROM `summary` WHERE (`flg` = 0) AND (`col` = :col) AND (`url` = :url) LIMIT 1"); $stmt -> execute(array(":col" => $col, ":url" => $url)); $summary = $stmt -> fetch() or header("Location: //keihan-girl.com/"); $stmt -> closeCursor(); $str = $summary['str']; $name = $summary['name']; $url = $summary['url']; $id = $summary['id']; //meta name="keywords" $keywords1 = h($summary['keywords1']); $keywords2 = h($summary['keywords2']); $keywords3 = h($summary['keywords3']); $keywords4 = h($summary['keywords4']); $keywords5 = h($summary['keywords5']); $keywords6 = h($summary['keywords6']); $keywords7 = h($summary['keywords7']); $array = array($keywords1, $keywords2, $keywords3, $keywords4, $keywords5, $keywords6, $keywords7); $array = array_filter($array, 'strlen'); $keywords = implode(",", $array); if($keywords1 == "" && $keywords2 == "" && $keywords3 == "" && $keywords4 == "" && $keywords5 == "" && $keywords6 == "" && $keywords7 == ""){ $meta_keywords = ""; }else{ $meta_keywords = ""; } //件数を取得（最終手段） $count_array = array(); $sql = "SELECT * FROM `area` INNER JOIN `shop` ON (area.str = shop.area OR area.str = shop.subarea1 OR area.str = shop.subarea2 OR area.str = shop.subarea3) WHERE (area.flg = 0) AND (shop.flg = 0) AND (shop.col = {$col}) AND (area.summary1 = '{$str}' OR area.summary2 = '{$str}' OR area.summary3 = '{$str}' OR area.summary4 = '{$str}' OR area.summary5 = '{$str}' OR area.summary6 = '{$str}') GROUP BY shop.shop_id"; foreach($dbh -> query($sql) as $row){ array_push($count_array, $row); } //店舗の取得（1ページ10件表示）（順番はプラン->上位表示） if(preg_match('/^[1-9][0-9]*$/', $_GET['page'])){ $page = (int)$_GET['page']; }else{ $page = 1; } $offset = SHOP_PER_PAGE * ($page - 1); $shop = array(); $sql = "SELECT * FROM `area` INNER JOIN `shop` ON (area.str = shop.area OR area.str = shop.subarea1 OR area.str = shop.subarea2 OR area.str = shop.subarea3) WHERE (area.flg = 0) AND (shop.flg = 0) AND (shop.col = {$col}) AND (area.summary1 = '{$str}' OR area.summary2 = '{$str}' OR area.summary3 = '{$str}' OR area.summary4 = '{$str}' OR area.summary5 = '{$str}' OR area.summary6 = '{$str}') GROUP BY shop.shop_id ORDER BY shop.plan DESC , shop.modified DESC , shop.created ASC LIMIT ".$offset.",".SHOP_PER_PAGE; foreach($dbh -> query($sql) as $row){ array_push($shop, $row); } $total = count($count_array); $totalPages = ceil($total / SHOP_PER_PAGE); $FROM = $offset + 1; $to = ($offset + SHOP_PER_PAGE) < $total ? ($offset + SHOP_PER_PAGE) : $total; //$pageが$totalPagesより多い数ならリダイレクト if($totalPages == 0){ }else{ if($page > $totalPages){ header("Location: //keihan-girl.com/{$folderName}/{$url}.html"); exit(); } } //まとめエリア+業種 $summary_genre = array(); $sql = "SELECT * FROM `summary_genre` WHERE (`flg` = 0) AND (`col` = {$col}) AND (`summary` = '{$str}')"; foreach($dbh -> query($sql) as $row){ array_push($summary_genre, $row); } ?> <?= h($name); ?> ｜ 【京阪ガール】 <?= $col == 0 ? "大阪" : "京都"; ?>ナイトワーク専門！高時給バイト情報 版では、の高時給ナイトワークによる体験入店バイト急募情報をご案内しております。" />

求人情報 件ヒットしました！

ご指定の条件に該当するお店は見つかりませんでした。

件中～件を表示
    prepare("SELECT COUNT(*) FROM `shop_interview` WHERE (`flg` = 0) AND (`shop_id` = '{$row['shop_id']}')"); $stmt -> execute(); $interview_count = (int)$stmt->fetchColumn(); $stmt -> closeCursor(); //エリア $stmt = $dbh->prepare("SELECT * FROM `area` WHERE (`str` = '{$row['area']}')"); $stmt -> execute(); $area = $stmt->fetch(); $stmt -> closeCursor(); //業種 $stmt = $dbh->prepare("SELECT * FROM `genre` WHERE (`str` = '{$row['genre']}')"); $stmt -> execute(); $genre = $stmt->fetch(); $stmt -> closeCursor(); /*本日の募集人数 //$time $date = new DateTime(); $time = $date->format('Y-m-d'); //$schedule_time0 $date = new DateTime($row['time0']); $schedule_time0 = $date->format('Y-m-d'); //$schedule_time1 $date = new DateTime($row['time1']); $schedule_time1 = $date->format('Y-m-d'); //$schedule_time2 $date = new DateTime($row['time2']); $schedule_time2 = $date->format('Y-m-d'); //$schedule_time3 $date = new DateTime($row['time3']); $schedule_time3 = $date->format('Y-m-d'); //$schedule_time4 $date = new DateTime($row['time4']); $schedule_time4 = $date->format('Y-m-d'); //$schedule_time5 $date = new DateTime($row['time5']); $schedule_time5 = $date->format('Y-m-d'); //$schedule_time6 $date = new DateTime($row['time6']); $schedule_time6 = $date->format('Y-m-d'); if($schedule_time0 == $time){ $person = $row['recruitment0']; }elseif($schedule_time1 == $time){ $person = $row['recruitment1']; }elseif($schedule_time2 == $time){ $person = $row['recruitment2']; }elseif($schedule_time3 == $time){ $person = $row['recruitment3']; }elseif($schedule_time4 == $time){ $person = $row['recruitment4']; }elseif($schedule_time5 == $time){ $person = $row['recruitment5']; }elseif($schedule_time6 == $time){ $person = $row['recruitment6']; }else{ $person = 0; } */ //待遇タブ $treatment01 = $row['treatment01'] == 0 ? "

    日払いOK

    " : "

    日払いOK

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

    未経験者大歓迎

    " : "

    未経験者大歓迎

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

    新規オープン

    " : "

    新規オープン

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

    グループ店あり

    " : "

    グループ店あり

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

    朝・昼に働ける

    " : "

    朝・昼に働ける

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

    給与保証あり

    " : "

    給与保証あり

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

    ノルマ無し

    " : "

    ノルマ無し

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

    出張面接OK

    " : "

    出張面接OK

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

    交通費支給

    " : "

    交通費支給

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

    面接交通費支給

    " : "

    面接交通費支給

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

    土日も営業

    " : "

    土日も営業

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

    自由出勤

    " : "

    自由出勤

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

    終電上がりOK

    " : "

    終電上がりOK

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

    駅チカ

    " : "

    駅チカ

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

    寮完備

    " : "

    寮完備

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

    ドレス貸出

    " : "

    ドレス貸出

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

    送りあり

    " : "

    送りあり

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

    迎えあり

    " : "

    迎えあり

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

    WワークOK

    " : "

    WワークOK

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

    私服OK

    " : "

    私服OK

    "; ?>

    • \"LINE応募ok\""; ?> \"日払いok♪\""; ?> \"未経験者大歓迎\""; ?> \"インタビュー掲載中\""; ?>
    " : "\"{$row['name']}\""; ?>

    現在の募集人数

    -" : "".h($row['recruitment'])."名"; ?>

    体験入店時給 エリア
    業種 勤務時間
    お店コメント
    お店の詳細を見る

  • -

件中～件を表示