Example #1
0
#!C:/Users/HP/AppData/Local/Programs/Python/Python37/python.exe

import conn, Cookies

userdetail = Cookies.SimpleCookie()

form = conn.cgiconfig()
db = conn.dbconfig()
cursor = db.cursor()

s = form.getvalue('s')
if s != None:
    unm = form.getvalue('unm')
    passw = form.getvalue('pass')

    query = "select * from register where unm='%s' && pass='******'" % (unm, passw)

    cursor.execute(query)
    data = cursor.fetchone()

    if data != None:
        userdetail['username'] = data[2]
        userdetail['role'] = data[8]
        print(userdetail)

print("Content-type:text/html")
print("")

if data != None:
    print("<script>alert('login success!!!')</script>")
    if data[8] == 'admin':