Skip to main content
 首页 » 编程设计

python之flask SQLite 查询

2024年11月01日9kerrycode

<分区>

这行不通。你怎样才能让它发挥作用?

        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)