changeset 730:94f43751d539

prof.rb [][]
author ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp>
date Tue, 07 Jul 2015 23:46:32 +0900
parents 6d97d07ad653
children 88554606a46d
files oasis2015/accountcheck.rb oasis2015/prof.rb
diffstat 2 files changed, 29 insertions(+), 19 deletions(-) [+]
line wrap: on
line diff
--- a/oasis2015/accountcheck.rb	Tue Jul 07 23:39:22 2015 +0900
+++ b/oasis2015/accountcheck.rb	Tue Jul 07 23:46:32 2015 +0900
@@ -19,9 +19,6 @@
 db.execute(cle3)
 db.execute(cle4)
 
-id = c.cookies["id"][0]
-person = id.to_i
-
 name = c["name"]
 cal = c["cal"]
 age = c["age"]
@@ -49,7 +46,7 @@
 Set-Cookie:id=%s ;expires=%s
 Set-Cookie:pass=%s ;expires=%s\n\n", id, expires, id2, expires)
 
-printf(<<_EOS_, person, name, id.to_i)
+printf(<<_EOS_, name, id.to_i)
 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
 <html>
 <head>
@@ -57,7 +54,7 @@
 <link rel="stylesheet" type="text/css" href="profeel.css">
 </head>
 <body>
-<h1>さかたっち%d</h1>
+<h1>さかたっち</h1>
 <h2>登録が完了しました!</h2>
 <p>ようこそ_ %s _さん!</p>
 <p>あなたのIDは%04dです。抽選はこのIDを元に行われます。</p>
--- a/oasis2015/prof.rb	Tue Jul 07 23:39:22 2015 +0900
+++ b/oasis2015/prof.rb	Tue Jul 07 23:46:32 2015 +0900
@@ -8,6 +8,7 @@
 
 id = c.cookies["id"][0]
 person = id.to_i
+
 data = "select * from test where id = ?" #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。
 cook = db.execute(data, person)               #dataに仕組んでいた命令を、personを代入しつつ実行。
 jikan1 = "select * from time where cd = ?"
@@ -19,21 +20,33 @@
 
 bomd = "update test set pt = ? where id = ?"
 
-name = cook[0][1]
-cal = cook[0][2]
-age = cook[0][3]
-sex = cook[0][4]
-aria = cook[0][5]
-exp = cook[0][6]
-pt = cook[0][7]
-lv = cook[0][8]
+#name = cook[0][1]
+#cal = cook[0][2]
+#age = cook[0][3]
+#sex = cook[0][4]
+#aria = cook[0][5]
+#exp = cook[0][6]
+#pt = cook[0][7]
+#lv = cook[0][8]
 
-
-q1 = toi[0][1]
-q2 = toi[0][2]
-q3 = toi[0][3]
-q4 = toi[0][4]
-q5 = toi[0][5]
+#q1 = toi[0][1]
+#q2 = toi[0][2]
+#q3 = toi[0][3]
+#q4 = toi[0][4]
+#q5 = toi[0][5]
+name = "aa"
+cal = "bb"
+age = "cc"
+sex = "dd"
+aria = "ee"
+exp = "3"
+pt = "6"
+lv = "9"
+q1 = "n"
+q2 = "n"
+q3 = "n"
+q4 = "n"
+q5 = "n"
 
 per ="%"
 

yatex.org