<分区> 分区>
这行不通。你怎样才能让它发挥作用?
g.db.execute('update address set firstname=?,surname=?,email=?,mobile=? where contact_id = ?',\
[request.form['firstname'], request.form['surname'],\
request.form['email'], request.form['mobile'],[contact_id]])
完整方法:
@app.route('/edit/<int:contact_id>',methods=['GET','POST'])
def contact_edit(contact_id):
contact_id = str(contact_id)
if request.method == 'POST':
g.db.execute('update address set firstname=?,surname=?,email=?,mobile=? where contact_id = ?',\
[request.form['firstname'], request.form['surname'],\
request.form['email'], request.form['mobile'],[contact_id]])
g.db.commit()
flash('The contact was successfully edited')
return redirect(url_for('contact_detail'))
elif request.method != 'POST':
cur = g.db.execute('select contact_id, surname, firstname, email, mobile\
from address where contact_id = ?', [contact_id])
select = cur.fetchall()
return render_template('editcontact.html', select=select)
