和歌山スポーツジム・スポーツクラブ特集

和歌山・岩出市のフィットネス・スポーツジム・スポーツクラブ

< ?php
if(!($db = mysql_connect('mysql69.db.sakura.ne.jp','shigaspo','1111'))) {
die ( 接続失敗 );
}
if(!(mysql_select_db(shigaspo))) {
print "データベース選択失敗";
}

$query = "SELECT * FROM waka_sports_info WHERE place = '2';";

if(!($rs = mysql_query($query))) {
print $query;
print クエリー失敗;
}
while($row = mysql_fetch_array($rs)) {
$name = mb_convert_encoding($row['name'],'UTF-8', 'auto');
$shop_id = mb_convert_encoding($row['shop_id'],'UTF-8', 'auto');
$hp_url = mb_convert_encoding($row['hp_url'],'UTF-8', 'auto');
$sp_url = mb_convert_encoding($row['sp_url'],'UTF-8', 'auto');
$comment = mb_convert_encoding($row['comment'],'UTF-8', 'auto');
$sp_flag = mb_convert_encoding($row['sp_flag'],'UTF-8', 'auto');
if($row['sp_flag'] !== "1") {
$no_flag_data[] = array(
mb_convert_encoding($row['name'], "UTF8", "auto"),
mb_convert_encoding($row['shop_id'],"UTF8", "auto"),
mb_convert_encoding($row['hp_url'],"UTF8", "auto"),
mb_convert_encoding($row['sp_url'],"UTF8", "auto"),
mb_convert_encoding($row['comment'],"UTF8", "auto"),
$sp_flag
);
} else {
$flag_data[] = $shop_id;
}
}

//契約店舗
if($flag_data) {
foreach ($flag_data as $str) {
$query = "SELECT waka_sports_detail.id,waka_sports_detail.shop_id,name,address,tel,hp_url,sp_url,waka_sports_info.comment,coupon_flag,movie_flag FROM waka_sports_detail INNER JOIN waka_sports_info ON waka_sports_detail.shop_id = waka_sports_info.shop_id where waka_sports_info.shop_id = " . $str . ";";

if(!($rs = mysql_query($query))) {
print $query;
print クエリー失敗;
}

$row = mysql_fetch_row($rs);
$id = mb_convert_encoding($row[0], "UTF8", "auto");
$shop_id = mb_convert_encoding($row[1], "UTF8", "auto");
$name = mb_convert_encoding($row[2], "UTF8", "auto");
$address = mb_convert_encoding($row[3], "UTF8", "auto");
$tel = mb_convert_encoding($row[4], "UTF8", "auto");
$hp_url = mb_convert_encoding($row[5], "UTF8", "auto");
$sp_url = mb_convert_encoding($row[6], "UTF8", "auto");
$comment = mb_convert_encoding($row[7], "UTF8", "auto");
$coupon_flag = mb_convert_encoding($row[8], "UTF8", "auto");
$movie_flag = mb_convert_encoding($row[9], "UTF8", "auto");

print "

“;
print “ “;
print “

“;

}
}
if($no_flag_data) {
foreach($no_flag_data as $str2) {

$name = $str2[0];
$shop_id = $str2[1];
$hp_url = $str2[2];
$sp_url = $str2[3];
$comment = $str2[4];

print “

“;
}
}
?>

“; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “” . $name . “ “; if($movie_flag !== “0″) { print ““; } else { print “ ”; } print “ “; if($coupon_flag !== “0″) { print ““; } else { print “ ”; } print “

“; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ “; print “ ” . $comment . “ TEL ： ” . $tel . “ 住所 ： “.$address . “ URL ： “.$sp_url.”web

“; print “ ” . $name; print “ “; print $comment . “