query($sql) as $row){
array_push($pickup_array, $row);
}
//エリアから探す
$area_array = array();
$sql = "SELECT * FROM `area` WHERE (`flg` = 0) AND (`col` = 0) ORDER BY `no` ASC";
foreach($dbh -> query($sql) as $row){
array_push($area_array, $row);
}
//業種から探す
$genre_array = array();
$sql = "SELECT * FROM `genre` WHERE (`flg` = 0) ORDER BY `no` ASC";
foreach($dbh -> query($sql) as $row){
array_push($genre_array, $row);
}
//先輩インタビュー
$interview_array = array();
$sql = "SELECT * FROM `shop` INNER JOIN `shop_interview` ON shop.shop_id = shop_interview.shop_id WHERE (shop.flg = 0) AND (shop.plan = 1) AND (shop_interview.flg = 0) AND (shop.col = 0) ORDER BY shop.modified DESC , shop_interview.no ASC LIMIT 6";
foreach($dbh -> query($sql) as $row){
array_push($interview_array, $row);
}
//新着情報
$news_array = array();
$sql = "SELECT * FROM `shop` INNER JOIN `shop_news` ON shop.shop_id = shop_news.shop_id WHERE (shop.flg = 0) AND (shop_news.col = 0) AND (shop.plan = 1) AND
shop_news.modified IN(SELECT MAX(shop_news.modified) FROM `shop_news` WHERE (shop_news.col = 0) AND (shop_news.flg = 0) GROUP BY shop_news.shop_id)
ORDER BY shop_news.modified DESC LIMIT 10";
foreach($dbh -> query($sql) as $row){
array_push($news_array, $row);
}
//即日体験入店できるお店の件数取得
$stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`plan` = 1) AND (`col` = 0) AND (`feature01` = 'vd8gBGFp4e' OR `feature02` = 'vd8gBGFp4e' OR `feature03` = 'vd8gBGFp4e' OR `feature04` = 'vd8gBGFp4e' OR `feature05` = 'vd8gBGFp4e')");
$stmt -> execute();
$feature_count0 = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
//日払いOKのお仕事情報の件数取得
$stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`plan` = 1) AND (`col` = 0) AND (`feature01` = 'LYn3ZzKcX7' OR `feature02` = 'LYn3ZzKcX7' OR `feature03` = 'LYn3ZzKcX7' OR `feature04` = 'LYn3ZzKcX7' OR `feature05` = 'LYn3ZzKcX7')");
$stmt -> execute();
$feature_count1 = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
//時給保証（または日給保証）のお仕事情報の件数取得
$stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`plan` = 1) AND (`col` = 0) AND (`feature01` = '7ZNOQTzloS' OR `feature02` = '7ZNOQTzloS' OR `feature03` = '7ZNOQTzloS' OR `feature04` = '7ZNOQTzloS' OR `feature05` = '7ZNOQTzloS')");
$stmt -> execute();
$feature_count2 = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
//朝・昼から働けるお仕事情報の件数取得
$stmt = $dbh->prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`plan` = 1) AND (`col` = 0) AND (`feature01` = 'Uz8KCh1XNb' OR `feature02` = 'Uz8KCh1XNb' OR `feature03` = 'Uz8KCh1XNb' OR `feature04` = 'Uz8KCh1XNb' OR `feature05` = 'Uz8KCh1XNb')");
$stmt -> execute();
$feature_count3 = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
?>
【大阪】 ナイトワーク専門！高時給バイト情報「京阪ガール」
ピックアップ店舗
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();
?>
-
" : "
![\"{$row['name']}\"](\"//keihan-girl.com/{$folderName}/{$row['shop_id']}/img/{$row['image01']}.jpg\")
"; ?>
ピックアップ店舗
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();
?>
-
" : "
"; ?>
エリアから探す
prepare("SELECT COUNT(*) FROM `shop` WHERE (`flg` = 0) AND (`area` = '{$row['str']}' OR `subarea1` = '{$row['str']}' OR `subarea2` = '{$row['str']}' OR `subarea3` = '{$row['str']}')");
$stmt -> execute();
$count = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
?>
（）
- （）
業種から探す
prepare("SELECT COUNT(*) FROM `shop` INNER JOIN `genre` ON shop.genre = genre.str WHERE (shop.flg = 0) AND (genre.flg = 0) AND (shop.col = 0) AND (shop.genre = '{$row['str']}')");
$stmt -> execute();
$count = (int)$stmt->fetchColumn();
$stmt -> closeCursor();
?>
（）
- （）
![\"日払いOKのお仕事情報\"](\"//keihan-girl.com/img/feature1_off.png\")
" : "![\"日払いOKのお仕事情報\"](\"//keihan-girl.com/img/feature1.png\")
"; ?>![\"時給保証（または日給保証）のお仕事情報\"](\"//keihan-girl.com/img/feature2_off.png\")
" : "![\"時給保証（または日給保証）のお仕事情報\"](\"//keihan-girl.com/img/feature2.png\")
"; ?>![\"朝・昼から働けるお仕事情報\"](\"//keihan-girl.com/img/feature3_off.png\")
" : "![\"朝・昼から働けるお仕事情報\"](\"//keihan-girl.com/img/feature3.png\")
"; ?>
先輩インタビュー
prepare("SELECT * FROM `shop` WHERE (`shop_id` = '{$row['shop_id']}')");
$stmt -> execute();
$shop = $stmt->fetch();
$stmt -> closeCursor();
$stmt = $dbh->prepare("SELECT * FROM `area` WHERE (`str` = '{$shop['area']}')");
$stmt -> execute();
$area = $stmt->fetch();
$stmt -> closeCursor();
?>
-
新着情報
prepare("SELECT * FROM `shop` WHERE (`shop_id` = '{$row['shop_id']}')");
$stmt -> execute();
$shop = $stmt->fetch();
$stmt -> closeCursor();
$date = new DateTime($row['modified']);
$dt1 = $date->format('Y年m月d日');
$week = $date->format('w');
$dt2 = $date->format('H:i');
?>
-
" : "
![\"{$shop['name']}\"](\"//keihan-girl.com/{$folderName}/{$shop['shop_id']}/img/{$row['usericon']}.jpg\")
"; ?>
