import sys
import MySQLdb
tablename = ""
mhost = ""
muser = ""
mpasswd = ""
mdb= ""
def head():
head = """
<html><head>
<style>
.minput {
border: 1px solid #fdfcf7;
font-family: "Times New Roman", Times, serif;
font-style: bold;
font-size: 14px;
color: #454743;
}
.mlabel {
font-family: "Times New Roman", Times, serif;
font-style: bold;
font-size: 13px;
color: #e7363e;
}
</style></head><body><form action="" method="post">
"""
return head
def sub():
sub = """
</form></body></html>
"""
return sub
def insert():
pass
def update():
pass
def input(name, label = None):
if not label:
label = name
return ‘<label style="mlabel">%s:</label><input style="minput" name="%s" type=text />’ % (label, name)
def clean(mrow):
pass
def deneme():
try:
conn = MySQLdb.connect (host = mhost, user = muser, passwd = mpasswd, db = mdb)
cursor = conn.cursor ()
msql = ‘select column_name from information_schema.columns where table_name="%s"’ % tablename
cursor.execute (msql)
except MySQLdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
sys.exit (1)
row = cursor.fetchall ()
print head()
for r in range(len(row)):
print input("".join(row[r]))
print sub()
cursor.close ()
conn.close ()
if __name__ == "__main__" :
deneme()
Tags: form, generator, html, html generator, mysql, mysqldb, Python, python generator