def upd_fname():
form = updForm()
if request.method == 'POST':
fname = request.form["fname"]
newfname = request.form["newfname"]
sql = "UPDATE student_list SET firstname = %s WHERE firstname = %s"
val = (newfname, fname)
mycursor.execute(sql, val)
mydb.commit()
flash('Operation Successfully Executed!')
return redirect(url_for('view_user'))
return render_template('upd_fname.html', form=form)
def upd_gender():
form = updForm()
if request.method == 'POST':
gender = request.form["gender"]
newgender = request.form["newgender"]
sql = "UPDATE student_list SET gender = %s WHERE gender = %s"
val = (newgender, gender)
mycursor.execute(sql, val)
mydb.commit()
flash('Operation Successfully Executed!')
return redirect(url_for('view_user'))
return render_template('upd_gender.html', form=form)
def upd_course():
form = updForm()
if request.method == 'POST':
course = request.form["course"].upper()
newcourse = request.form["newcourse"].upper()
sql = "UPDATE student_list SET course = %s WHERE course = %s"
val = (newcourse, course)
mycursor.execute(sql, val)
mydb.commit()
flash('Operation Successfully Executed!')
return redirect(url_for('view_user'))
return render_template('upd_course.html', form=form)