-
Notifications
You must be signed in to change notification settings - Fork 0
/
login-register.py
69 lines (61 loc) · 2.39 KB
/
login-register.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
from flask import Flask,render_template,request,url_for,logging,redirect,flash
import mysql.connector
from flask_mysqldb import MySQL, MySQLdb
app = Flask(__name__)
app.config["MYSQL_HOST"] = 'localhost'
app.config["MYSQL_USER"] = 'user'
app.config["MYSQL_PASSWORD"] = 'user'
app.config["MYSQL_DB"] = "register"
app.config["MYSQL_CURSORCLASS"] = 'DictCursor'
mysql = MySQL(app)
@app.route("/")
def home():
return render_template("loginform.html")
@app.route("/login", methods=["GET","POST"])
def login():
if request.method == "POST":
username = request.form["username"]
pswd = request.form["paswd"]
cur = mysql.connection.cursor(MySQLdb.cursors.DictCursor)
cur.execute("SELECT * FROM users where Username = %s",(username,))
res = cur.fetchone()
cur.close()
if res:
if pswd == res['password']:
#flash("You are logged in","success")
return render_template("loginform.html")
else:
flash("Incorrect Password","danger")
return render_template("loginform.html")
else:
flash("Username does not exist","danger")
return render_template("loginform.html")
else:
return render_template("loginform.html")
@app.route("/register", methods=["GET","POST"])
def register():
if request.method == 'GET':
return render_template("feedback.html")
else:
name = request.form["name"]
username = request.form["uname"]
password = request.form["pwd"]
confirm = request.form["conf_pass"]
cur = mysql.connection.cursor()
cur.execute("SELECT username FROM users where Username = %s",(username,))
res = cur.fetchone()
if res is None:
if password == confirm:
cur.execute("INSERT INTO users(Name,Username,Password) VALUES(%s,%s,%s)",(name,username,password))
mysql.connection.commit()
flash("You are registered and can Login", "success")
return redirect(url_for('login'))
else:
flash("Password does not match", "danger")
return render_template("feedback.html")
else:
flash("Username is taken, please use another", "danger")
return render_template("feedback.html")
if __name__ == '__main__':
app.secret_key="asdfg"
app.run(debug=True)