def facultyadd(): try: if session['type']!="admin": return redirect(url_for("logout")) except: return redirect(url_for("logout")) res=request.form id,name,address,phone,date=res['FacultyID'],res["FacultyName"],res['Address'],res['FacultyPhone'],res['date'] email,pwd,rpwd=res['email'],res['password'],res['repassword'] error,success="","" if pwd!=rpwd: error="Passwords Didn't Match" else: db_conn=mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp") cur=db_conn.cursor() A1=Admin(db_conn,session['email']) k=A1.AddFaculty(db_conn,email,id,name,address,phone,date) if k[0]: success=k[1] acct_type="faculty" passw=sha256_crypt.hash(pwd) query="INSERT INTO users(`password`,account_type,email) VALUES(%s,%s,%s)" cur.execute(query,(passw,acct_type,email,)) db_conn.commit() else: error=k[1] db_conn=mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp") cur=db_conn.cursor() query="SELECT FacultyID,`Name` FROM faculty" cur.execute(query) res=cur.fetchall() if success: return render_template("admin_faculty.html",faculty=res,success="Faculty Successfully Added") return render_template("admin_faculty.html",faculty=res,error=error)