Mercurial > hgrepos > hgweb.cgi > skipweb
changeset 742:146ec64c639a
prof.rb test
author | ARAKI Tsuyohito <c113007@e.koeki-u.ac.jp> |
---|---|
date | Wed, 08 Jul 2015 00:28:27 +0900 |
parents | 40570c8400ff |
children | e70f7c2342a8 |
files | oasis2015/prof.rb |
diffstat | 1 files changed, 2 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/oasis2015/prof.rb Wed Jul 08 00:24:38 2015 +0900 +++ b/oasis2015/prof.rb Wed Jul 08 00:28:27 2015 +0900 @@ -7,10 +7,9 @@ db = SQLite3::Database.new("./sql/main.sq3") id = c.cookies["id"][0] -person = 468 -#id.to_i +person = id.to_i -data = "select * from test where id = ?" +data = "select * from toi where id = ?" #idが?(後で代入)のデータをtest票から探す。という命令をdataにしくむ。全てがほしい場合は「*」。「*」を「name」に変えると該当データのnameだけとりだす。 cook = db.execute(data, person) #dataに仕組んでいた命令を、personを代入しつつ実行。 jikan1 = "select * from time where cd = ?"