<% ERuby.charset = "Shift_JIS" require "mysql" require "cgi-lib" require "kconv" require ENV['PATH_TRANSLATED'].sub("[^$/]*$","param.rb") input = CGI.new id = input['id'] || "0" begin sql_conn = Mysql.init() res = sql_conn.connect(DB_HOST, DB_USER, DB_PASS) res = sql_conn.select_db(DB_NAME) rst = sql_conn.query( "select date,flag_members,title,memo from information where id='#{id}';") line = rst.fetch_row() rescue print "データベース接続エラー" exit end %>

<%= Kconv.kconv(line[2],Kconv::SJIS, Kconv::EUC) %>

作成日:<%= line[0] %>

<%= line[1]=="0" ? Kconv.kconv(line[3],Kconv::SJIS, Kconv::EUC) : "-----" %>


お問い合わせは info@shizuokanet.ne.jp まで

Copyright 2006 Shizuoka Internet Inc.