prepare("SELECT * FROM `area_genre` WHERE (`flg` = 0) AND (`col` = :col) AND (`url` = :url) LIMIT 1"); $stmt -> execute(array(":col" => $col, ":url" => $url)); $area_genre = $stmt -> fetch() or header("Location: //keihan-girl.com/"); $stmt -> closeCursor(); $area = $area_genre['area']; $genre = $area_genre['genre']; $name = $area_genre['name']; $url = $area_genre['url']; $id = $area_genre['id']; //meta name="keywords"とmeta name="description" $keywords1 = h($area_genre['keywords1']); $keywords2 = h($area_genre['keywords2']); $keywords3 = h($area_genre['keywords3']); $keywords4 = h($area_genre['keywords4']); $keywords5 = h($area_genre['keywords5']); $keywords6 = h($area_genre['keywords6']); $keywords7 = h($area_genre['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 = ""; } //件数を取得 $stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`area` = '{$area}' OR `subarea1` = '{$area}' OR `subarea2` = '{$area}' OR `subarea3` = '{$area}') AND (`genre` = '{$genre}')"); $stmt -> execute(); $count = (int)$stmt->fetchColumn(); $stmt -> closeCursor(); //店舗の取得（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 `shop` WHERE (`flg` = 0) AND (`area` = '{$area}' OR `subarea1` = '{$area}' OR `subarea2` = '{$area}' OR `subarea3` = '{$area}') AND (`genre` = '{$genre}') ORDER BY `plan` DESC , (`area` = '{$area}') DESC ,`modified` DESC LIMIT ".$offset.",".SHOP_PER_PAGE; foreach($dbh -> query($sql) as $row){ array_push($shop, $row); } $total = $dbh -> query("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`area` = '{$area}' OR `subarea1` = '{$area}' OR `subarea2` = '{$area}' OR `subarea3` = '{$area}') AND (`genre` = '{$genre}')") -> fetchColumn(); $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(); } } //エリア名 $stmt = $dbh->prepare("SELECT * FROM `area` WHERE (`str` = '{$area}')"); $stmt -> execute(); $area_name = $stmt->fetch(); $stmt -> closeCursor(); //業種名 $stmt = $dbh->prepare("SELECT * FROM `genre` WHERE (`str` = '{$genre}')"); $stmt -> execute(); $genre_name = $stmt->fetch(); $stmt -> closeCursor(); ?> <?= 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 `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'])."名"; ?>

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

  • -

件中～件を表示