tbl_area->find("del_flg='0' and view_flg='0'","view_num asc , id asc"); $area_tag =<<<_EOF_ _EOF_; //トピックスジャンル取得 $cate = $c->tbl_category->find("del_flg='0' and view_flg='0'","view_num asc , id asc"); $cate_tag =<<<_EOF_ _EOF_; //ツアージャンル取得 $t_cate = $c->tbl_t_category->find("del_flg='0' and view_flg='0'","view_num asc , id asc"); $tcate_tag =<<<_EOF_ _EOF_; //ツアー一覧を取得 $tour_list = $c->tbl_tour->find( "del_flg='0' and view_flg='0' and top_flg='0'" , "view_num desc" , 8 ); foreach( $tour_list as $val ){ //エリアとカテゴリの取得 $area = $c->tbl_area->findone( "id='{$val["area"]}' and del_flg='0'" ); $cat = $c->tbl_t_category->findone( "id='{$val["category"]}' and del_flg='0'" ); $date = preg_replace("/-/" , "." , $val["date"]); //ガイド if( $val["guide_id"] ){ $guide = $c->tbl_guide->findone("id='{$val["guide_id"]}'"); $guide_name = $guide["title"]; $guide_image = $guide["images"]; }else{ $guide_name = $val["name"]; $guide_image = $val["guide_image"]; } $tour .=<<<_EOF_
Private

{$val["title"]}

{$val["list_text"]}

_EOF_; } //トピックス一覧を取得 $topics_list = $c->tbl_topics->find( "del_flg='0' and view_flg='0' and top_flg='0'" , "date desc" , 8 ); foreach( $topics_list as $val ){ //エリアとカテゴリの取得 $area = $c->tbl_area->findone( "id='{$val["area"]}' and del_flg='0'" ); $cat = $c->tbl_category->findone( "id='{$val["category"]}' and del_flg='0'" ); $date = preg_replace("/-/" , "." , $val["date"]); //ガイド if( $val["writer_id"] ){ $writer = $c->tbl_writer->findone("id='{$val["writer_id"]}'"); $writer_name = $writer["title"]; $writer_image = $writer["images"]; }else{ $writer_name = $val["author"]; $writer_image = $val["authorimg"]; } $topics .=<<<_EOF_

{$val["title"]}

{$val["lead"]}

_EOF_; } $c->set("tour" , $tour); $c->set("topics" , $topics); $c->set("area" , $area_tag); $c->set("topics_category" , $cate_tag); $c->set("tour_category" , $tcate_tag); } ?> TOP|OSAKA旅めがね

Find Out

毎月情報配信! 大阪の魅力を知る!

Make Friends!

個性豊かな旅めがねFriendsと繋がる!

オダギリサトシ

森なおみ

たけちゃん

大納言はぴこ

パタリロさん

谷やん

おすぎ

ともえさん

鬼龍院ヨネキチ

旅めがねフレンズが発見!
Today's OsakaInstagram

Enjoy OSAKA!

ツアーに参加して大阪を楽しむ!