Untitled

@app.route('/register', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
      userName = request.form["Fname"]
      email = request.form["email"]
      gender = request.form.get('gender')
      city = request.form.get('city')
      code = request.form.get('code')
      FullName = request.form["Lname"]
      password = request.form["password"]
      phoneNumber = request.form['phone']
      knowledge = ','.join(request.form.getlist('mycheckbox'))
      
      if not checkAlreadyRegistered(userName):
          conn = sqlite3.connect("UserData.db")
          cursor = conn.cursor()
          cursor.execute(f"INSERT INTO registerData VALUES (\"{email}\", \"{userName}\", \"{gender}\", {code}, \"               {city}\", \"      {FullName}\", \"{password}\", {phoneNumber}, \"{knowledge}\")")
          conn.commit()
          #printing functions start:
          cursor.execute(f"SELECT * FROM registerData WHERE Username = \"{userName}\"")
          data = cursor.fetchall()
          print(data)
          #printing functions end.
          conn.close()
          return render_template('register.html', error = "The registration was done successfully.")
      else:
        return render_template('register.html', error = "This username is taken")
    else:
      return render_template('register.html')







def checkAlreadyRegistered(username):
  conn = sqlite3.connect("UserData.db")
  cursor = conn.cursor()

  selectQuery = f"SELECT * FROM registerData where userName = \"{username}\""
  cursor.execute(selectQuery)
  data = cursor.fetchall()

  conn.close()

  return data