Try to create a register page for my app. I am using Flask framework and MySQL db from pythonanywhere.com.
@app.route('/register/', methods=["GET","POST"])
def register_page():
try:form = RegistrationForm(request.form)if request.method == "POST" and form.validate():email = form.email.datapassword = sha256_crypt.encrypt((str(form.password.data)))c, conn = connection()x = c.execute("SELECT * FROM users WHERE email = (%s)",(email))if int(x) > 0:flash("That email adress is already in use.")return render_template('register.html', form=form)else:c.execute("INSERT INTO users (email, password) VALUES (%s, %s)",(thwart(email),thwart(password)))conn.commit()flash("Thanks for registering!")c.close()conn.close()gc.collect()session['logged_in'] = Truesession['email'] = emailreturn redirect(url_for('dashboard'))return render_template("sign-up.html", form=form)except Exception as e:return(str(e))}
On running I get the Error:not all arguments converted during string formatting. How to fix it? May be the problem in this statement?
c.execute("INSERT INTO users (email, password) VALUES (%s, %s)",(thwart(email),thwart(password)))