电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-11-02 10:11 |只看该作者 |倒序浏览

本帖最后由 saerbili 于 2011-11-02 16:36 编辑

# -*- coding: GBK -*-
import sqlite3
import os
import cgi
print "Content-type:text/html\n\n"
print "<html><head><link href=/img/p2p.css type=text/css rel=stylesheet></head>"
print "<body>"
#open sqlite3 select urlog
conn = sqlite3.connect("/usr/auditlog/audit.db3")
cu = conn.cursor()
cu.execute('select * from urlog where id="name"')
#table start
print '''<table class=bgurl width="551" border0>
<tr id=tblhdr>
<td>按IP搜索：
<form id="form1" method="post" action=\"/cgi-bin/Audit/url_audit\">
<input name="textarea" type="text" value="" />
<input type="submit" name="Submit" value="提交" />
</form>
</td>
</tr>
</table>
'''
print '''<table class=bgurl width=551 border=0 cellspacing=1 cellpadding=1 bgcolor="#ffffff">
<tr id=tblhdr>
<td><div align="center">月份</div></td>
<td><div align="center">日期</div></td>
<td><div align="center">时间</div></td>
<td><div align="center">IP</div></td>
<td><div align="center">URL</div></td>
<td><div align="center">类型</div></td>
</tr>
'''
for recs in cu:
print """
<tr id=row1>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
</tr>
""" % (recs[0],recs[1],recs[2],recs[3],recs[4],recs[5])
print '''</table>'''
print "</body></html>"