def student_courses(): try: if session['type']!="student": return redirect(url_for("logout")) except: return redirect(url_for("logout")) db_conn = mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp") # db_conn = mysql.connector.connect(host = "localhost", port = 3306, user = "******", database = "pesuapp") S1 = Student(db_conn, session['email']) courses_enrolled = S1.ViewCourses(db_conn) return render_template("student_courses.html", courses_enrolled = courses_enrolled)
def sendfeedback(): print("here") try: if session['type']!="student": return redirect(url_for("logout")) except: return redirect(url_for("logout")) db_conn = mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp") S1=Student(db_conn, session['email']) courses_enrolled = S1.ViewCourses(db_conn) result=request.form notifs={} for course in courses_enrolled: ID=course.CourseID if result[str(ID)]: notifs[ID]=result[str(ID)] for i in notifs: F1=FeedBack(i,S1.srn) print(F1.WriteReview(notifs[i],db_conn)) del F1 return redirect(url_for("student_courses"))