prepare("SELECT * FROM `genre` WHERE (`flg` = 0) AND (`url` = :url) LIMIT 1"); $stmt -> execute(array(":url" => $url)); $genre = $stmt -> fetch() or header("Location: //keihan-girl.com/"); $stmt -> closeCursor(); $str = $genre['str']; $name = $genre['name']; $url = $genre['url']; $id = $genre['id']; //件数を取得 $stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`col` = {$col}) AND (`genre` = '{$str}')"); $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 (`col` = {$col}) AND (`genre` = '{$str}') ORDER BY `plan` 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 (`col` = {$col}) AND (`genre` = '{$str}')") -> 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(); } } ?> <?= 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(); /*本日の募集人数 //$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'])."名"; ?>

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

  • -

件中～件を表示