@app.route('/register', methods=["GET", "POST"])
def register():
		if request.method == 'GET':
			return render_template("register.html")
		else:
			user_name = request.form['user_name']
			user_email = request.form['user_email']
			user_register_as = request.form['user_register_as']
			user_password = request.form['user_password'].encode('utf-8')
			hash_password = bcrypt.hashpw(user_password, bcrypt.gensalt())

			cur = mysql.connection.cursor()
			cur.execute("INSERT INTO register (user_name, user_email, user_register_as, user_password) VALUES (%s,%s,%s,%s)",(user_name,user_email,user_register_as,hash_password,))
			mysql.connection.commit()
			session['user_name'] = request.form['user_name']
			session['user_email'] = request.form['user_email']
			session['user_register_as'] = request.form['user_register_as']
			return redirect(url_for('home'))


@app.route('/login',methods=["GET","POST"])
def login():
	if request.method == 'POST':
		user_email = request.form['user_email']
		user_password = request.form['user_password'].encode('utf-8')


		curl = mysql.connection.cursor(MySQLdb.cursors.DictCursor)
		curl.execute("SELECT * FROM register WHERE user_email=%s",(user_email,))
		user = curl.fetchone()
		curl.close()

		if len(user) > 0:
			if bcrypt.hashpw(user_password, user["user_password"].encode('utf-8')) == user["user_password"].encode('utf-8'):
				session['user_name'] = user['user_name']
				session['user_email'] = user['user_email']
				session['user_register_as'] = user['user_register_as']
				return render_template("home.html")
			else:
				return "Error password & email not match"
		else:
			return "Error user not found"
	else:
		return render_template("login.html")