Python

Python RSS

MySQL and Python

Thread Solved

•

Join Date: Nov 2008

Posts: 58

Reputation: adam291086 is an unknown quantity at this point

Solved Threads: 0

adam291086 adam291086 is offline

Offline

Junior Poster in Training

MySQL and Python

Nov 20th, 2008

I am trying to create an authentication script. I am trying to use the PASSWORD function within Mysql but it wont work. Any ideas

 Help with Code Tags 
 Python Syntax (Toggle Plain Text) 
#!/usr/bin/python
# e begoli, python connector for mysql
# import MySQL module
import MySQLdb
import cgi 
print "Content-type: text/html\n"
 
# connection
db = MySQLdb.connect(host = "localhost", user = "dsfdsfds1", passwd = "dsfdsfdsfsdM5HQ", db = "dsfdsfdsfdsfdsf")
 
form = cgi.FieldStorage()
if form.has_key("username")and form["username"].value !="" and form.has_key("password") and form["password"].value !="":
    username = form["username"].value
    password = form["password"].value
 
    # create a database cursor
    cursor = db.cursor()
 
    # execute SQL select statement
    cursor.execute("SELECT * FROM User WHERE UserName = username AND Password = PASSWORD(password)")
 
    # get the number of rows in the resultset
    numrows = int(cursor.rowcount)
 
    if numrows ==1:
        print "your in"
    else:
        print "you are not authorised to view this page"
#!/usr/bin/python
# e begoli, python connector for mysql
# import MySQL module
import MySQLdb
import cgi 
print "Content-type: text/html\n"

# connection
db = MySQLdb.connect(host = "localhost", user = "dsfdsfds1", passwd = "dsfdsfdsfsdM5HQ", db = "dsfdsfdsfdsfdsf")

form = cgi.FieldStorage()
if form.has_key("username")and form["username"].value !="" and form.has_key("password") and form["password"].value !="":
    username = form["username"].value
    password = form["password"].value
    
    # create a database cursor
    cursor = db.cursor()

    # execute SQL select statement
    cursor.execute("SELECT * FROM User WHERE UserName = username AND Password = PASSWORD(password)")

    # get the number of rows in the resultset
    numrows = int(cursor.rowcount)
   
    if numrows ==1:
        print "your in"
    else:
        print "you are not authorised to view this page"

if i put PASSWORD('password') it just get the encryption for password and not the variable

•