# HG changeset patch # User FUJIKAWA Kosuke # Date 1415519790 -32400 # Node ID 55e59370aedcca77af607253687ee9df06040497 # Parent e01709e74c3a6f9a337b19b45c418a1c7f51b406 add.html add.rb leaf.rb add diff -r e01709e74c3a -r 55e59370aedc fujix/add.html --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/fujix/add.html Sun Nov 09 16:56:30 2014 +0900 @@ -0,0 +1,18 @@ + + +add page + + + + +

登録ぺーじ

名前を入れて登録しよう

+ +

c111126@g.koeki-u.ac.jp

+ + + diff -r e01709e74c3a -r 55e59370aedc fujix/add.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/fujix/add.rb Sun Nov 09 16:56:30 2014 +0900 @@ -0,0 +1,48 @@ +#!/usr/bin/env ruby +#coding:utf-8 + +require'cgi' +require'sqlite3' + +cgi = CGI.new(:accept_charset => "UTF-8") +name = cgi["name"] + +db = SQLite3::Database.new("sql/test.sq3") + +begin + db.execute("insert into main(name,lon,lat) values('#{name}',0,0)"); +rescue + db.execute("create table main(id integer PRIMARY KEY AUTOINCREMENT,name,lon,lat)"); + db.execute("insert into main(name,lon,lat) values('#{name}',0,0)"); + data = db.execute("select * from main"); +end + +count = db.execute("select max(id) from main"); + +expires = (Time.now.gmtime+3600*24).strftime("%a, %d %b %Y %H:%M:%S GMT") + +print"Content-type: text/html charset=UTF-8\n" + +printf("Set-Cookie:id=%d; expires=%s\n",count[0][0],expires) +printf("Set-Cookie:name=%s; expires=%s\n\n",name,expires) + +printf" + + +add page's + + + + +

勝手にページが飛びます。

移動しない場合はこちらから移動してください

+ + +" diff -r e01709e74c3a -r 55e59370aedc fujix/leaf.rb --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/fujix/leaf.rb Sun Nov 09 16:56:30 2014 +0900 @@ -0,0 +1,107 @@ +#!/usr/bin/env ruby +#coding:utf-8 + +print"Content-type: text/html charset=UTF-8\n\n" + +require'sqlite3' +require 'cgi' +c = CGI.new(:accept_charaset => "UTF-8") +db = SQLite3::Database.new("sql/test.sq3") +db.results_as_hash = true + +lon = ARGV[0].to_f +lat = ARGV[1].to_f + +data = Hash.new +#data["fujix"] = [38.91026,139.84532] +#data["ほげ"] = [38.91526,139.84032] + +cookieuke = Hash.new # cookie値保存用のHash +if (c=ENV['HTTP_COOKIE']) # 環境変数 HTTP_COOKIE にcookieリストがある + c.split(/[;,]\s+/).each do |exp| # (セミコロンかカンマ)+空白で分解 + if /(.*)=(.*)/ =~ exp # =の前後で分解「変数=値;」 + key = CGI::unescape($1) # 変数も値もエスケープされているので + value = CGI::unescape($2) # 元に戻す + cookieuke[key] = CGI::unescape(value) + end + end +end +name = cookieuke["name"] +id = cookieuke["id"].to_i + +lon = 38.91326 +lat = 139.84032 + +begin + db.execute("select * from main"); +rescue + db.execute("create table main(id INTEGER PRIMARY KEY AUTOINCREMENT,name,lon,lat)"); + db.execute("insert into main(name,lon,lat) values('NAME','LON','LAT')"); +end + +sql = "update main set name=?,lon=?,lat=? where id=?" + +begin + db.execute(sql,name,lon,lat,id) +rescue + db.execute("insert into main(name,lon,lat) values('#{name}','#{lon}','#{lat}')"); +end + +db.execute("select * from main") do |load| + data[load['id']] = [load['name'],load['lon'],load['lat']] +end + +printf(<<_EOS_) + + + + + + +Getting Started with Leaflet + + + +

+ + +\n" diff -r e01709e74c3a -r 55e59370aedc fujix/redirect.html --- a/fujix/redirect.html Thu Nov 06 15:51:21 2014 +0900 +++ b/fujix/redirect.html Sun Nov 09 16:56:30 2014 +0900 @@ -3,8 +3,9 @@ たいとる -

位置情報を取得し直して地図に再表示します

位置情報を取得し直して再表示します

diff -r e01709e74c3a -r 55e59370aedc fujix/sql/dummy.txt --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/fujix/sql/dummy.txt Sun Nov 09 16:56:30 2014 +0900 @@ -0,0 +1,1 @@ +hoge