def studentedit():
try:
if session['type']!="admin":
return redirect(url_for("logout"))
except:
return redirect(url_for("logout"))
result=request.form
id,name,address,phonenumber,branch,courseid=result['StudentID'],result['StudentName'],result['Address'],result['Phone'],result['Branch'],result['CID']
courseid=courseid.split(",")
courseid=[x.strip() for x in courseid]
db_conn = mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp")
A1=Admin(db_conn,session['email'])
k=A1.EditStudent(db_conn,id,name,address,phonenumber,branch,courseid)
cur=db_conn.cursor()
query="SELECT srn,studname FROM student"
cur.execute(query)
res=cur.fetchall()
if k[0]:
return render_template("admin_students.html",students=res,success="Student Successfully Edited")
return render_template("admin_students.html",students=res,error=k[1])
