Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @login_blueprint.route('/login', methods=['GET', 'POST'])
- def login():
- if request.method == 'POST' and 'email' in request.form:
- try:
- email = request.form['email']
- password = request.form['password']
- database = mysql.connector.connect(
- host=DBHost,
- user=DBUser,
- passwd=DBPass,
- database=DB
- )
- cursor = database.cursor()
- query = "SELECT * FROM users WHERE (email, password) = %s, %s"
- values = (email, password)
- cursor.execute(query, values)
- cursor.fetchall()
- return render_template('dashboard.html', email=email)
- except Exception as error:
- print(error)
- return jsonify(result='that account does not exist')
- return render_template('login.html')
- @register_blueprint.route('/register', methods=['GET', 'POST'])
- def register():
- if request.method == 'POST' and 'email' in request.form:
- email = request.form['email']
- password = request.form['password']
- database = mysql.connector.connect(
- host=DBHost,
- user=DBUser,
- passwd=DBPass,
- database=DB
- )
- cursor = database.cursor()
- query = "INSERT INTO users (email, password) VALUES (%s, %s)"
- values = (email, password)
- cursor.execute(query, values)
- database.commit()
- return jsonify(result='account created, proceed to login')
- return render_template('register.html')
Add Comment
Please, Sign In to add comment