弄不明白了，各位大大帮帮忙 [复制链接]

电梯直达

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

发表于 2011-12-01 00:25 |只看该作者 |倒序浏览

怎样能让print '''
<a href="/cgi-bin/Audit/url_audit?pglines+10">aaa</a>
'''
控制pgno = 1这个变量呢？

# -*- coding: GBK -*-
from sqlite3 import dbapi2
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>"
conn=dbapi2.connect("/usr/mytest.db")
cs = conn.cursor()
conn.commit()
pgno = 1
pglines = 20
sql = " select * from mytb9 where not id in "+\
"(select id from mytb9 order by id limit "+str( (pgno-1)* pglines)+\
" ) order by id limit " + str( pglines)
cs.execute( sql)
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>
</tr>
'''
for recs in cs:
print """
<tr id=row1>
<td><div align="center">%s</div></td>
<td><div align="center">%s</div></td>
</tr>
""" % (recs[0],recs[1])
conn.close()
print '''</table>'''
print '''
<a href="/cgi-bin/Audit/url_audit?pglines+10">aaa</a>
'''
print "</body></html>"

复制代码

2楼 [报告]

发表于 2011-12-21 10:56 |只看该作者

啥意思？没看明白！
搞个flag？