def courseedit():
try:
if session['type']!="admin":
return redirect(url_for("logout"))
except:
return redirect(url_for("logout"))
db_conn = mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp")
result=request.form
id,title,avl,details,faculties=result['CourseID'],result['CourseTitle'],result['AVL'],result['CourseDetails'],result['FID']
faculties=faculties.split(",")
faculties=[x.strip() for x in faculties]
A1=Admin(db_conn,session['email'])
k=A1.EditCourse(db_conn,id,title,faculties,details,avl)
#for pushing to courses site
cur=db_conn.cursor()
query="SELECT courseid,coursetitle FROM course"
cur.execute(query)
res=cur.fetchall()
if k[0]:
return render_template("admin_courses.html",courses=res,success="Course Successfully Edited")
else:
return render_template("admin_courses.html",courses=res,error=k[1])
