README
运行
1.执行数据库创建脚本
2.localhost/cgi-bin/main.cgi
问题排查
若提示数据库文件只读,调整数据库文件权限及其所在文件夹权限为777即可
Resource
#!/usr/bin/python
# -*- coding: UTF-8
import sqlite3
conn = sqlite3.connect('messages.db')
curs = conn.cursor()
curs.execute("""
create table messages(
id integer primary key autoincrement,
subject text not null,
sender text not null,
reply_to int,
text text not null
);
""")
conn.commit()
conn.close()
main.cgi
#!/usr/bin/python
print 'Content-type: text/html\n'
import cgitb; cgitb.enable()
import sqlite3
conn = sqlite3.connect('messages.db')
curs = conn.cursor()
print """
<html>
<head>
<title>The FooBar Bulletin Board</title>
</head>
<body>
<h1>The FooBar Bulletin Board</h1>
"""
curs.execute('SELECT * FROM messages')
names = [d[0] for d in curs.description]
rows = [d