Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 751:8fa9f9b018de
prof cook2
| author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
|---|---|
| date | Wed, 08 Jul 2015 18:15:45 +0900 |
| parents | 2ce5de0e9a3a |
| children | d385e91ad9dd |
| files | oasis2015/prof.rb |
| diffstat | 1 files changed, 4 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/prof.rb Wed Jul 08 18:08:22 2015 +0900 +++ b/oasis2015/prof.rb Wed Jul 08 18:15:45 2015 +0900 @@ -10,8 +10,10 @@ person = id.to_i data = "select * from toi where id = ?" +data2 = "select * from test where id = ?" #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。 cook = db.execute(data, person) #dataに仕組んでいた命令を、personを代入しつつ実行。 +cook2 = db.execute(data2, person) jikan1 = "select * from time where cd = ?" timeupd = "update time set now = ?, id = ? where cd = ?" @@ -245,7 +247,7 @@ #以下のprintfについて #pre*4はstyleの部分、<h2>{margin(本来OS_,per,gage,per,per,per,name...) -printf(<<_EOS_, per, gage, per, per, per, color, cook, kkget, image, alt, name, person, cal, lv, pt, m1, mimg1, m2, mimg2) +printf(<<_EOS_, per, gage, per, per, per, color, cook, cook2, kkget, image, alt, name, person, cal, lv, pt, m1, mimg1, m2, mimg2) <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" @@ -274,7 +276,7 @@ </head> <body> -<header><p>%s</p></header> +<header><p>%s<br>%s</p></header> <h1>さかたっち</h1> <h2>%s</h2>
