我陷入了一个困境,我怎么能写这样的sql查询,使一个seach。我已经尝试并发布了它,但是当用户在表单的多个字段中输入数据并进行搜索时,它并不像预期的那样。
我为单个表单域编写表单并进行搜索和显示的查询
#!/usr/bin/python
import cgi
import MySQLdb
class Table():
def __init__(self, host, user, passwd, name):
self.db = MySQLdb.connect(host = host, user = user, passwd = passwd, db = name)
self.cursor = self.db.cursor()
def getdata(self, fname, lname, age, gender):
self.fname = fname
self.lname = lname
self.age = age
self.gender = gender
def mysqlconnect(self):
sql = "select * from PERSON where F_Name = '%s' or L_Name = '%s' or Age = '%s' or Gender = '%s' " %(self.fname, self.lname, self.age, self.gender)
self.cursor.execute(sql)
result = self.cursor.fetchall()
for row in result:
print "<br>", row[0], row[1], row[2], row[3]
self.cursor.close()
self.db.close()
def main():
print "Content-type: text/html\n"
tableobj = Table("localhost", "root", "root", "Info")
form = cgi.FieldStorage()
f_name = form.getvalue('firstname', '')
l_name = form.getvalue('lastname', '')
age = form.getvalue('age', 0)
gender = form.getvalue('gender', '')
tableobj.getdata(f_name, l_name, age, gender)
tableobj.mysqlconnect()
if __name__ == "__main__":
main()
如果假设用户在FirstName字段和Gender字段中输入数据
Firstname: Jeremy
Gender: male
然后它应该显示记录。 假设用户在年龄字段和性别字段中输入数据
Age : 25
Gender: Female
它应该显示25岁女性的结果。 同样所有可能的情况
目前没有回答
相关问题 更多 >
编程相关推荐