field_sql('t', $_POST['point_x']) . ", u_map_y = " . $db->field_sql('t', $_POST['point_y']) . ", u_map_zoom = " . $db->field_sql('t', $_POST['point_zoom']) . " WHERE u_cd = " . $db->field_sql('n', $_SESSION['cd']) . ";"; //echo $data; $data = stripslashes($data); // $data = mb_convert_encoding(stripslashes($data), "eucJP-win", "UTF-8"); $column = $db->execute2($data); if (!is_numeric($db->cls_db_count)) { header("Location: {$g_file_ad['system']}?cd=2"); exit; } $db->close(); unset($db); //オブジェクト破棄 } // 検索条件作成 $where = array(); array_push($where, "map_open = 2"); //都道府県 if ($_REQUEST['srh_city']) { array_push($where, "map_city = '{$_REQUEST['srh_city']}'"); } //カテゴリ if ($_REQUEST['srh_map_type']) { array_push($where, "map_type = '{$_REQUEST['srh_map_type']}'"); } //フリーワード if ($_REQUEST['srh_text']) { //ワイルドカード対策 escape"!" $sh_text = ereg_replace(" "," ",$_REQUEST['srh_text']); $sh_text = ereg_replace("!","!!",$sh_text); $sh_text = ereg_replace("%","!%",$sh_text); $sh_text = ereg_replace("_","!_",$sh_text); $arr_sh_text = explode(" ", $sh_text); foreach($arr_sh_text as $value) { array_push($where, "COALESCE(map_title, '') || COALESCE(map_msg, '') || COALESCE(map_add, '') || COALESCE(u_hn, '') LIKE '%{$value}%' ESCAPE '!'"); } } if (count($where) > 0) { $in_where = 'WHERE ' . implode(" AND ", $where); } // ソートstr ///////////////////////////////////////////////////////////// $order = "ORDER BY m.inst_date DESC"; // ソートend ///////////////////////////////////////////////////////////// // グループstr ///////////////////////////////////////////////////////////// $group = "GROUP BY map_cd, map_open, map_x, map_y, map_title, map_msg, u_hn, dv1.div_nm, dv2.div_nm, m.inst_date, map_toilet, dv2.div_lvl"; // グループend ///////////////////////////////////////////////////////////// $limit = (!$_REQUEST['page'] ? " LIMIT 10" : ""); // $limit = (!$_REQUEST['page'] ? " LIMIT 5" : " LIMIT {$gc_page_limit} OFFSET " . (is_numeric($_REQUEST[page]) ? $_REQUEST[page]-1 : 0) * $gc_page_limit); //問合せ文定義 /* to_char(m.inst_date, 'YYYY年MM月DD日 hh24:mi:ss') AS inst_date */ $data = "SELECT (SELECT count(map_cd) FROM {$g_tbl['map']} {$in_where}) AS count, (SELECT fl.fl_nm FROM {$g_tbl['file']} AS fl WHERE fl.fl_table = 'map' AND m.map_cd = fl.fl_table_cd ORDER BY fl.fl_cd LIMIT 1) AS img, m.map_cd as cd, map_open as open, map_x as x, map_y as y, map_title as title, map_msg as msg, u.u_hn as hn, dv1.div_nm as city_nm, dv2.div_nm as type_nm, dv2.div_lvl as type, map_toilet as toilet, date_format(m.inst_date, '%Y\.%m\.%d %H:%i:%s') AS inst_date FROM {$g_tbl['map']} AS m LEFT JOIN {$g_tbl['user']} AS u ON m.map_u_cd = u.u_cd LEFT JOIN {$g_tbl['div']} AS dv1 ON m.map_city = dv1.div_cd AND dv1.div_type = 'city' LEFT JOIN {$g_tbl['div']} AS dv2 ON m.map_type = dv2.div_cd AND dv2.div_type = 'map_type' {$in_where} {$group} {$order} {$limit}"; //print $data; $data = stripslashes($data); // $data = mb_convert_encoding(stripslashes($data), "eucJP-win", "UTF-8"); //db object $db = new gf_DB(); $column = $db->execute($data); $db->close(); if (!$_REQUEST['page']) { //問合せ文定義 /* to_char(m.inst_date, 'YYYY年MM月DD日 hh24:mi:ss') AS inst_date, */ $data = "SELECT (SELECT count(map_cd) FROM {$g_tbl['map']} {$in_where}) AS count, (SELECT fl.fl_nm FROM {$g_tbl['file']} AS fl WHERE fl.fl_table = 'map' AND m.map_cd = fl.fl_table_cd ORDER BY fl.fl_cd LIMIT 1) AS img, m.map_cd as cd, map_open as open, map_x as x, map_y as y, map_title as title, map_msg as msg, u.u_hn as hn, dv1.div_nm as city_nm, dv2.div_nm as type_nm, dv2.div_lvl as type, date_format(m.inst_date, '%Y\.%m\.%d %H:%i:%s') AS inst_date, map_toilet as toilet, Sum(po.po_count) AS po_count FROM {$g_tbl['map']} AS m LEFT JOIN {$g_tbl['po']} AS po ON po.po_table = 'map' AND po.po_table_cd = m.map_cd LEFT JOIN {$g_tbl['user']} AS u ON m.map_u_cd = u.u_cd LEFT JOIN {$g_tbl['div']} AS dv1 ON m.map_city = dv1.div_cd AND dv1.div_type = 'city' LEFT JOIN {$g_tbl['div']} AS dv2 ON m.map_type = dv2.div_cd AND dv2.div_type = 'map_type' {$in_where} {$group} ORDER BY COALESCE(Sum(po.po_count),0) DESC, m.inst_date DESC {$limit}"; //print $data; $data = stripslashes($data); // $data = mb_convert_encoding(stripslashes($data), "eucJP-win", "UTF-8"); //db object $db_po = new gf_DB(); $column_po = $db_po->execute($data); $db_po->close(); } // マップ初期位置 $map_init_x = "138.33984375"; $map_init_y = "38.41055825094609"; $map_init_zoom = "5"; if ($_SESSION['cd']) { $data = "SELECT u_map_x, u_map_y, u_map_zoom FROM {$g_tbl['user']} WHERE u_cd = {$_SESSION['cd']}"; $data = stripslashes($data); // $data = mb_convert_encoding(stripslashes($data), "eucJP-win", "UTF-8"); //db object $db_user = new gf_DB(); $column_user = $db_user->execute($data); $db_user->close(); if (is_numeric($column_user['u_map_x'])) { $map_init_x = $column_user['u_map_x']; } if (is_numeric($column_user['u_map_y'])) { $map_init_y = $column_user['u_map_y']; } if (is_numeric($column_user['u_map_zoom'])) { $map_init_zoom = $column_user['u_map_zoom']; } } // ヘッダー header("Content-Type: text/html; charset=utf-8"); header("Expires: Thu, 01 Dec 1994 16:00:00 GMT"); header("Last-Modified: ". gmdate("D, d M Y H:i:s"). " GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); // メイン処理 -------------------------------------------------------- ?> みんなでつくるマップ | コラビ●Smile

このページの先頭です

本文へ移動

ここからパンくずリストです

ホーム > みんなでつくるマップ

ここから本文です

みんなでつくるマップ

障がい者や高齢者にお勧めできるお店やスポットをマップで作成できます。会員登録をすると投稿もできます。(→使い方ガイドはこちら)

あなたの体験を投稿してね

">情報を投稿する

" method="post">

新しく登録されたスポット

outp_list("{$option}"); ?>

: 役に立った度

検索結果

where = stripslashes(" {$in_where}"); // $map_list->where = mb_convert_encoding(stripslashes(" {$in_where}"), "eucJP-win", "UTF-8"); ?> outp_list("{$option}"); ?>

: 役に立った度

アイコン表示について
  • 飲食店飲食店
  • コンビニコンビニ
  • ショッピングショッピング
  • 文化・レジャー施設文化・レジャー施設
  • 宿泊施設宿泊施設
  • 公園・その他公園・その他
  • 官公庁官公庁
  • 交通機関交通機関
  • 医療・福祉施設医療・福祉施設
  • 金融機関金融機関
  • オフィスビルオフィスビル

「役に立った」と評価された情報(アンケート結果による)

outp_list("{$option}"); ?>

みんなでつくるマップ 使い方ガイド