#Kayıt sayfası
@app.route("/register", methods = ["GET", "POST"])
def register():
    form = RegisterForm(request.form)

    if request.method == "POST" and form.validate():
        name = form.name.data
        username = form.username.data
        password = form.password.data
        email = form.email.data

        cursor = mysql.connection.cursor()
        sorgu1 = "Select * From users(username,email) VALUES (%s,%s)"
        result = cursor.execute(sorgu1,(username,email))
        if result > 0:
            flash("Kullanıcı adı veya E-mail bulunuyor.","danger")
            return redirect(url_for("register"))
        else:
            cursor = mysql.connection.cursor()

            sorgu = "Insert into users(name,username,password,email) VALUES(%s,%s,%s,%s)"

            cursor.execute(sorgu,(name,username,password,email))
            mysql.connection.commit()
            cursor.close()
            flash("Başarıyla kayıt oldunuz " + username,"success")
            return redirect(url_for("login"))
            
    else:
        return render_template("register.html", form = form)