Mercurial > hgrepos > hgweb.cgi > skipweb
view program/GiveMeALiftInYourCar/check_table.rb @ 1159:99248e0e3f6f
merged
author | GOTO Sakuya<c113061@e.koeki-u.ac.jp> |
---|---|
date | Tue, 01 Dec 2015 22:49:24 +0900 |
parents | 6117d10abd89 |
children |
line wrap: on
line source
#!/usr/bin/env ruby # coding: utf-8 require 'sqlite3' require 'cgi' c = CGI.new(:tag_maker => "html4", :accept_charset => "EUC-JP") db = SQLite3::Database.new("sql/acounts.sq3") sql = "select sub_name, password from acounts;" value = db.execute(sql) print("Content-type: text/html; charset=UTF-8 \n\n") print' <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>トップページ -koeki network-</title> <style type="text/css"> <!-- --> </style> <link rel="stylesheet" type="text/css" href="group.css"> </head> <body> <div class="base"> <h1 ><img class="kn" src="koeki-network.png" alt="300x167(14204bytes)" width="300" height="120"> </h1> <div class="bb"> <table> <tr><th>sub_name</th><th>pass</th></tr> ' value.each { |data| printf(' <tr><td>%s</td><td>%s</td></tr> ', data[0], data[1]) } # フッダ− print' </table> </div> <hr> <a class="cont" href="./top.rb?vis_log=out">ろぐあうと。</a> <a class="cont" href="./login.html">ほかのアカウントでログイン。</a> <address>c112124@h.koeki-u.ac.jp</address> </div> </body> </html> '