10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sun ='".$date."' OR girl.sun_check = 1) AND girl.sun_start<'".$nowtime."' AND girl.sun_end>'".$nowtime."' ORDER BY girl.sun_start, girl.sun_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 1:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl,shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.mon ='".$date."' OR girl.mon_check = 1) AND girl.mon_start<'".$nowtime."' AND girl.mon_end>'".$nowtime."' ORDER BY girl.mon_start, girl.mon_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 2:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.tue ='".$date."' OR girl.tue_check = 1) AND girl.tue_start<'".$nowtime."' AND girl.tue_end>'".$nowtime."' ORDER BY girl.tue_start, girl.tue_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 3:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.wed ='".$date."' OR girl.wed_check = 1) AND girl.wed_start<'".$nowtime."' AND girl.wed_end>'".$nowtime."' ORDER BY girl.wed_start, girl.wed_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 4:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.thu ='".$date."' OR girl.thu_check = 1) AND girl.thu_start<'".$nowtime."' AND girl.thu_end>'".$nowtime."' ORDER BY girl.thu_start, girl.thu_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 5:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.fri ='".$date."' OR girl.fri_check = 1) AND girl.fri_start<'".$nowtime."' AND girl.fri_end>'".$nowtime."' ORDER BY girl.fri_start, girl.fri_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 6:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sat ='".$date."' OR girl.sat_check = 1) AND girl.sat_start<'".$nowtime."' AND girl.sat_end>'".$nowtime."' ORDER BY girl.sat_start, girl.sat_end LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
}
}
}
while($girl_data = mysqli_fetch_array($girl_result)){
$girl_id = $girl_data["girl_id"];
$girl_name = $girl_data["girl_name"];
$girl_pr = $girl_data["girl_pr"];
$size_b = $girl_data["size_b"];
$cup = $girl_data["cup"];
$size_w = $girl_data["size_w"];
$size_h = $girl_data["size_h"];
$size_t = $girl_data["size_t"];
$age = $girl_data["age"];
$blood = $girl_data["blood"];
$main_p = $girl_data["main_p"];
$rank = $girl_data["rank"];
$girl_sort = $girl_data["girl_sort"];
$sun = $girl_data["sun"];
$sun_start = $girl_data["sun_start"];
$sun_start24 = over24($sun_start);
$sun_end = $girl_data["sun_end"];
$sun_end24 = over24($sun_end);
$sun_check = $girl_data["sun_check"];
$mon = $girl_data["mon"];
$mon_start = $girl_data["mon_start"];
$mon_start24 = over24($mon_start);
$mon_end = $girl_data["mon_end"];
$mon_end24 = over24($mon_end);
$mon_check = $girl_data["mon_check"];
$tue = $girl_data["tue"];
$tue_start = $girl_data["tue_start"];
$tue_start24 = over24($tue_start);
$tue_end = $girl_data["tue_end"];
$tue_end24 = over24($tue_end);
$tue_check = $girl_data["tue_check"];
$wed = $girl_data["wed"];
$wed_start = $girl_data["wed_start"];
$wed_start24 = over24($wed_start);
$wed_end = $girl_data["wed_end"];
$wed_end24 = over24($wed_end);
$wed_check = $girl_data["wed_check"];
$thu = $girl_data["thu"];
$thu_start = $girl_data["thu_start"];
$thu_start24 = over24($thu_start);
$thu_end = $girl_data["thu_end"];
$thu_end24 = over24($thu_end);
$thu_check = $girl_data["thu_check"];
$fri = $girl_data["fri"];
$fri_start = $girl_data["fri_start"];
$fri_start24 = over24($fri_start);
$fri_end = $girl_data["fri_end"];
$fri_end24 = over24($fri_end);
$fri_check = $girl_data["fri_check"];
$sat = $girl_data["sat"];
$sat_start = $girl_data["sat_start"];
$sat_start24 = over24($sat_start);
$sat_end = $girl_data["sat_end"];
$sat_end24 = over24($sat_end);
$sat_check = $girl_data["sat_check"];
$shop_id = $girl_data["shop_id"];
$shop_name = $girl_data["shop_name"];
$shop_code = $girl_data["shop_code"];
$shop_area = $girl_data["shop_area"];
$shop_pref = $girl_data["shop_pref"];
$shop_pref_jp = pref_jp($shop_pref);
$shop_pref_en = pref_en($shop_pref);
//////////エリア名読み込み//////////
$area_sql = "SELECT * FROM area WHERE area_id='".$shop_area."'";
$area_result = mysqli_query($con,$area_sql);
if(!$area_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
while($area_data = mysqli_fetch_array($area_result)){
$area_id = $area_data["area_id"];
$area_name_en = $area_data["area_name_en"];
$area_name_jp = $area_data["area_name_jp"];
}
for ($s=0; $s<7; $s++){
if ($sc_day[0] == $sc_day[$s]){
switch ($sc_week[$s]) {
case 0:
$sc_date = $sun;
$sc_start = $sun_start;
$sc_end = $sun_end;
$sc_start24 = $sun_start24;
$sc_end24 = $sun_end24;
$sc_check = $sun_check;
break;
case 1:
$sc_date = $mon;
$sc_start = $mon_start;
$sc_end = $mon_end;
$sc_start24 = $mon_start24;
$sc_end24 = $mon_end24;
$sc_check = $mon_check;
break;
case 2:
$sc_date = $tue;
$sc_start = $tue_start;
$sc_end = $tue_end;
$sc_start24 = $tue_start24;
$sc_end24 = $tue_end24;
$sc_check = $tue_check;
break;
case 3:
$sc_date = $wed;
$sc_start = $wed_start;
$sc_end = $wed_end;
$sc_start24 = $wed_start24;
$sc_end24 = $wed_end24;
$sc_check = $wed_check;
break;
case 4:
$sc_date = $thu;
$sc_start = $thu_start;
$sc_end = $thu_end;
$sc_start24 = $thu_start24;
$sc_end24 = $thu_end24;
$sc_check = $thu_check;
break;
case 5:
$sc_date = $fri;
$sc_start = $fri_start;
$sc_end = $fri_end;
$sc_start24 = $fri_start24;
$sc_end24 = $fri_end24;
$sc_check = $fri_check;
break;
case 6:
$sc_date = $sat;
$sc_start = $sat_start;
$sc_end = $sat_end;
$sc_start24 = $sat_start24;
$sc_end24 = $sat_end24;
$sc_check = $sat_check;
break;
}
}
}
echo <<< EOF
EOF; } ?>
\n
EOF;
if (! $main_p == 0) {
echo <<< SET
\n
SET;
}
else {
echo <<< SET
\n
SET;
}
echo <<< EOF
\n
EOF;
$npg="1";
}
if(!$npg) {
echo <<< EOF
{$girl_name} ({$age})
EOF;
if ($sc_start == "未定") {
echo "時間{$sc_start}
\n"; } elseif ($sc_start == "要TEL確認" or $sc_start == "休") { echo "{$sc_start}
\n"; } else { echo "{$sc_start24}~{$sc_end24}
\n"; } echo <<< EOF
\n
\n"; } elseif ($sc_start == "要TEL確認" or $sc_start == "休") { echo "{$sc_start}
\n"; } else { echo "{$sc_start24}~{$sc_end24}
\n"; } echo <<< EOF
{$area_name_jp}
\n
現在今すぐ遊べる子はおりません。
EOF; } ?>
19){
$area_span ="";
}
else {
$area_span ="";
}
//----------//エリア店舗登録数取得//--------//
$area_shop_sql = "SELECT Count(*) AS reccnt FROM shop WHERE shop_rank > 1 AND shop_publish = 1 AND shop_pref='".$area_pref_no."' AND (shop_area='".$area_id."' OR shop_subarea_1 ='".$area_id."' OR shop_subarea_2 ='".$area_id."')";
$area_shop_result = mysqli_query($con,$area_shop_sql);
if(!$area_shop_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
$area_cnt = mysqli_fetch_array($area_shop_result);
mysqli_free_result($area_shop_result);
if($area_cnt["reccnt"] > 0){
$search_area_name .= "\n";
}
else {
$search_area_name .= "
{$area_span}{$area_name_jp}
({$area_cnt["reccnt"]})
\n";
}
}
echo $search_area_name;
?>
({$area_cnt["reccnt"]})
10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sun ='".$date."' OR girl.sun_check = 1) AND girl.sun_start<'".$nowtime."' AND girl.sun_end>'".$nowtime."' ORDER BY girl.sun_end, girl.sun_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 1:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl,shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.mon ='".$date."' OR girl.mon_check = 1) AND girl.mon_start<'".$nowtime."' AND girl.mon_end>'".$nowtime."' ORDER BY girl.mon_end, girl.mon_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 2:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.tue ='".$date."' OR girl.tue_check = 1) AND girl.tue_start<'".$nowtime."' AND girl.tue_end>'".$nowtime."' ORDER BY girl.tue_end, girl.tue_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 3:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.wed ='".$date."' OR girl.wed_check = 1) AND girl.wed_start<'".$nowtime."' AND girl.wed_end>'".$nowtime."' ORDER BY girl.wed_end, girl.wed_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 4:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.thu ='".$date."' OR girl.thu_check = 1) AND girl.thu_start<'".$nowtime."' AND girl.thu_end>'".$nowtime."' ORDER BY girl.thu_end, girl.thu_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 5:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.fri ='".$date."' OR girl.fri_check = 1) AND girl.fri_start<'".$nowtime."' AND girl.fri_end>'".$nowtime."' ORDER BY girl.fri_end, girl.fri_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
case 6:
//-------//テーブル読み込み//-------//
$girl_sql = "SELECT * FROM girl, shop WHERE shop.shop_id=girl.girl_shop_id AND shop.shop_course>10 AND shop.shop_publish = 1 AND shop_pref='".$area_pref_no."' AND girl.waiting= 1 AND girl.girl_sort > 0 AND (girl.sat ='".$date."' OR girl.sat_check = 1) AND girl.sat_start<'".$nowtime."' AND girl.sat_end>'".$nowtime."' ORDER BY girl.sat_end, girl.sat_start LIMIT 5";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
break;
}
}
}
$npg="";
while($girl_data = mysqli_fetch_array($girl_result)){
$girl_id = $girl_data["girl_id"];
$girl_name = $girl_data["girl_name"];
$girl_pr = $girl_data["girl_pr"];
$size_b = $girl_data["size_b"];
$cup = $girl_data["cup"];
$size_w = $girl_data["size_w"];
$size_h = $girl_data["size_h"];
$size_t = $girl_data["size_t"];
$age = $girl_data["age"];
$blood = $girl_data["blood"];
$main_p = $girl_data["main_p"];
$newface = $girl_data["newface"];
$rank = $girl_data["rank"];
$in_year = $girl_data["in_year"];
$in_month = $girl_data["in_month"];
$in_day = $girl_data["in_day"];
$girl_sort = $girl_data["girl_sort"];
$sun = $girl_data["sun"];
$sun_start = $girl_data["sun_start"];
$sun_start24 = over24($sun_start);
$sun_end = $girl_data["sun_end"];
$sun_end24 = over24($sun_end);
$sun_check = $girl_data["sun_check"];
$mon = $girl_data["mon"];
$mon_start = $girl_data["mon_start"];
$mon_start24 = over24($mon_start);
$mon_end = $girl_data["mon_end"];
$mon_end24 = over24($mon_end);
$mon_check = $girl_data["mon_check"];
$tue = $girl_data["tue"];
$tue_start = $girl_data["tue_start"];
$tue_start24 = over24($tue_start);
$tue_end = $girl_data["tue_end"];
$tue_end24 = over24($tue_end);
$tue_check = $girl_data["tue_check"];
$wed = $girl_data["wed"];
$wed_start = $girl_data["wed_start"];
$wed_start24 = over24($wed_start);
$wed_end = $girl_data["wed_end"];
$wed_end24 = over24($wed_end);
$wed_check = $girl_data["wed_check"];
$thu = $girl_data["thu"];
$thu_start = $girl_data["thu_start"];
$thu_start24 = over24($thu_start);
$thu_end = $girl_data["thu_end"];
$thu_end24 = over24($thu_end);
$thu_check = $girl_data["thu_check"];
$fri = $girl_data["fri"];
$fri_start = $girl_data["fri_start"];
$fri_start24 = over24($fri_start);
$fri_end = $girl_data["fri_end"];
$fri_end24 = over24($fri_end);
$fri_check = $girl_data["fri_check"];
$sat = $girl_data["sat"];
$sat_start = $girl_data["sat_start"];
$sat_start24 = over24($sat_start);
$sat_end = $girl_data["sat_end"];
$sat_end24 = over24($sat_end);
$sat_check = $girl_data["sat_check"];
$shop_id = $girl_data["shop_id"];
$shop_name = $girl_data["shop_name"];
$shop_code = $girl_data["shop_code"];
$shop_area = $girl_data["shop_area"];
$shop_pref = $girl_data["shop_pref"];
$shop_pref_jp = pref_jp($shop_pref);
$shop_pref_en = pref_en($shop_pref);
//////////エリア名読み込み//////////
$area_sql = "SELECT * FROM area WHERE area_id='".$shop_area."'";
$area_result = mysqli_query($con,$area_sql);
if(!$area_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
while($area_data = mysqli_fetch_array($area_result)){
$area_id = $area_data["area_id"];
$area_name_en = $area_data["area_name_en"];
$area_name_jp = $area_data["area_name_jp"];
}
for ($s=0; $s<7; $s++){
if ($sc_day[0] == $sc_day[$s]){
switch ($sc_week[$s]) {
case 0:
$sc_date = $sun;
$sc_start = $sun_start;
$sc_end = $sun_end;
$sc_start24 = $sun_start24;
$sc_end24 = $sun_end24;
$sc_check = $sun_check;
break;
case 1:
$sc_date = $mon;
$sc_start = $mon_start;
$sc_end = $mon_end;
$sc_start24 = $mon_start24;
$sc_end24 = $mon_end24;
$sc_check = $mon_check;
break;
case 2:
$sc_date = $tue;
$sc_start = $tue_start;
$sc_end = $tue_end;
$sc_start24 = $tue_start24;
$sc_end24 = $tue_end24;
$sc_check = $tue_check;
break;
case 3:
$sc_date = $wed;
$sc_start = $wed_start;
$sc_end = $wed_end;
$sc_start24 = $wed_start24;
$sc_end24 = $wed_end24;
$sc_check = $wed_check;
break;
case 4:
$sc_date = $thu;
$sc_start = $thu_start;
$sc_end = $thu_end;
$sc_start24 = $thu_start24;
$sc_end24 = $thu_end24;
$sc_check = $thu_check;
break;
case 5:
$sc_date = $fri;
$sc_start = $fri_start;
$sc_end = $fri_end;
$sc_start24 = $fri_start24;
$sc_end24 = $fri_end24;
$sc_check = $fri_check;
break;
case 6:
$sc_date = $sat;
$sc_start = $sat_start;
$sc_end = $sat_end;
$sc_start24 = $sat_start24;
$sc_end24 = $sat_end24;
$sc_check = $sat_check;
break;
}
}
}
echo <<< EOF
EOF; } ?>
\n
EOF;
if (! $main_p == 0) {
echo <<< SET
\n
SET;
}
else {
echo <<< SET
\n
SET;
}
echo <<< EOF
\n
EOF;
$npg="1";
}
if(!$npg) {
echo <<< EOF
{$girl_name} ({$age})
EOF;
if ($sc_start == "未定") {
echo "時間{$sc_start}
\n"; } elseif ($sc_start == "要TEL確認" or $sc_start == "休") { echo "{$sc_start}
\n"; } else { echo " {$sc_end24} まで\n"; } echo <<< EOF
\n
\n"; } elseif ($sc_start == "要TEL確認" or $sc_start == "休") { echo "{$sc_start}
\n"; } else { echo " {$sc_end24} まで\n"; } echo <<< EOF
{$area_name_jp}
\n
現在出勤中の子はおりません。
EOF; } ?>
1 AND shop_publish = 1 AND nyukin>=current_date AND shop_pref='".$area_pref_no."' ORDER BY shop_update DESC LIMIT 5";
$news_result = mysqli_query($con,$news_sql) or die(mysqli_error());
if(!$news_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
//AND shop.nyukin>=current_date AND shop.shop_publish>0 ------------------------------------//
while($news_data = mysqli_fetch_array($news_result)){
$shop_name = $news_data["shop_name"];
$shop_name = mb_strimwidth($shop_name, 0, 30, "...","UTF-8");
$shop_code = $news_data["shop_code"];
$shop_area = $news_data["shop_area"];
$shop_pr = $news_data["shop_pr"];
$shop_pr = str_replace("
", " ", $shop_pr); $shop_update = $news_data["shop_update"]; //////////エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); if(!$area_sql){ print("SQLの実行に失敗しました。\n"); exit; } //-----------------------------------// while($area_data = mysqli_fetch_array($area_result)){ $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_name_jp = $area_data["area_name_jp"]; } //投稿日時 $ts = strtotime($shop_update); $up_month = date('m', $ts); $up_day = date('d', $ts); $up_hour = date('H', $ts); $up_min = date('i', $ts); echo <<< EOF
EOF;
}
?>
", " ", $shop_pr); $shop_update = $news_data["shop_update"]; //////////エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); if(!$area_sql){ print("SQLの実行に失敗しました。\n"); exit; } //-----------------------------------// while($area_data = mysqli_fetch_array($area_result)){ $area_pref = $area_data["area_pref"]; $area_pref_jp = pref_jp($area_pref); $area_name_jp = $area_data["area_name_jp"]; } //投稿日時 $ts = strtotime($shop_update); $up_month = date('m', $ts); $up_day = date('d', $ts); $up_hour = date('H', $ts); $up_min = date('i', $ts); echo <<< EOF
{$up_month}/{$up_day} {$up_hour}:{$up_min}
{$shop_name}
{$area_name_jp}
=current_date AND
$movie_sql = "SELECT * FROM movie, shop WHERE shop.shop_course>10 AND shop.shop_publish = 1 AND movie.movie_shop_id=shop.shop_id AND shop.shop_pref='".$area_pref_no."' ORDER BY shop.upper_update DESC LIMIT 1";
$movie_result = mysqli_query($con,$movie_sql);
if(!$movie_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
//-----------------------------------//
$movie_main = "";
while($movie_data = mysqli_fetch_array($movie_result)){
$movie_id = $movie_data["movie_id"];
$movie_shop_id = $movie_data["movie_shop_id"];
$movie_girl_id = $movie_data["movie_girl_id"];
$movie_title = mb_strimwidth($movie_data["movie_title"], 0, 60, "...","UTF-8");
$movie_text = mb_strimwidth($movie_data["movie_text"], 0, 200, "...","UTF-8");
$movie_code = $movie_data["movie_code"];
$movie_img = $movie_data["movie_img"];
$movie_access = $movie_data["movie_access"];
$movie_update = $movie_data["movie_update"];
$shop_id = $movie_data["shop_id"];
$shop_name = $movie_data["shop_name"];
$shop_code = $movie_data["shop_code"];
$shop_area = $movie_data["shop_area"];
$shop_pref = $movie_data["shop_pref"];
$shop_pref_jp = pref_jp($shop_pref);
$shop_pref_en = pref_en($shop_pref);
//////////女の子名読み込み//////////
$girl_sql = "SELECT * FROM girl WHERE girl_id='".$movie_girl_id."'";
$girl_result = mysqli_query($con,$girl_sql);
if(!$girl_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
while($girl_data = mysqli_fetch_array($girl_result)){
$girl_id = $girl_data["girl_id"];
$girl_name = $girl_data["girl_name"];
$girl_pr = $girl_data["girl_pr"];
$age = $girl_data["age"];
}
//////////エリア名読み込み//////////
$area_sql = "SELECT * FROM area WHERE area_id='".$shop_area."'";
$area_result = mysqli_query($con,$area_sql);
if(!$area_sql){
print("SQLの実行に失敗しました。\n");
exit;
}
while($area_data = mysqli_fetch_array($area_result)){
$area_id = $area_data["area_id"];
$area_name_en = $area_data["area_name_en"];
$area_name_jp = $area_data["area_name_jp"];
}
if ($movie_main == 0){
echo <<< EOF
EOF;
$movie_main = "1";
}
}
?>