#!/usr/bin/env python # ######### CGI header ####################################### import cgi print "Content-Type: text/html\n" form = cgi.FieldStorage() ########## import modules ################################## import sys import re import pgdb ## security: delete suspicious characters in form input ####### some_security = re.compile(r"[^\w\s,\.\-]") for item in form.keys(): form[item].value = some_security.sub ("", form[item].value) ######### get form values ################################## table = form.getvalue("table") ########## HTML header ######################################## print """
" + crs.description[0][0] + " | " +\ crs.description[1][0] + " | " for hits in range(crs.rowcount): row = crs.fetchone() print "
---|---|
" + row[0] + " | " + row[1]+" |