话不多说,上cgi文件代码
import cgi
import sqlite3
reshtml1 = '''Content-Type: text/html\n
<HTML>
<HEAD>
<TITLE>ISTG baby VOTE system</TITLE>
</HEAD>
<BODY>
<P>Your name is <B>%s</B>.
<P>You have voted <B>%s</B>.
</BODY>
</HTML>
'''
reshtml2 = '''Content-Type: text/html\n
<HTML>
<HEAD>
<TITLE>ISTG baby VOTE system</TITLE>
</HEAD>
<BODY>
<P>You are not a member of ISTG group!
<P>If you are, please check your spelling. eg: hqzhu
</BODY>
'''
form = cgi.FieldStorage()
person = form['person'].value
sex = form['sex'].value
conn = sqlite3.connect('/home/hqzhu/istg/web/baby.db')
cur = conn.cursor()
sql = "select name from catalog;"
cur.execute(sql)
names = cur.fetchmany(14)
cur.close()
conn.close()
if (person,) in names:
print reshtml1 % (person, sex)
else:
print reshtml2
下面是httpd的error_log内容
[Wed Jul 08 17:34:24.830482 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: Traceback (most recent call last):, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830577 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: File "/var/www/cgi-bin/baby.py", line 34, in <module>, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830616 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: conn = sqlite3.connect('/home/hqzhu/istg/web/baby.db'), referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830683 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: sqlite3.OperationalError: unable to open database file, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.841601 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] End of script output before headers: baby.py, referer: http://10.180.190.12/baby.htm
前两天有个帖子说是用sys.stdout.write()去做什么的,不太懂,求教~
1
Septembers 2015-07-09 09:48:18 +08:00
这年头没多少人使用/会CGI了
|
2
ryd994 2015-07-09 12:11:19 +08:00 via Android
为啥不用wsgi?
cgi在性能,安全等各方面都没什么优势 |