DTAiLab/admin/websiteinfo.py

from admin.dboper import *

#查询网站基本信息
def loadWebSiteInfo():
    sql = "select * from websiteinfo LIMIT 0,1;"
    results = mySQL_Query(sql)
    return results[0]

#更新网站基本信息
def updateWebInfo(labinfo, footinfo, contactinfo):
    sql ="update websiteinfo set labinfo='%s', footinfo='%s', contactinfo='%s' where webid=1" % (labinfo, footinfo, contactinfo)
    i, msg = mySQL_Execute(sql)
    return i, msg