properly save the rsvp form

1 files changed, 18 insertions, 1 deletions

diff --git a/wedding.py b/wedding.py
index c8b5b54..249c940 100644
--- a/wedding.py
+++ b/wedding.py
@@ -66,7 +66,24 @@ def rsvp():
                                form=r)
     if request.method == 'POST':
         db = get_db()
-        cur = db.execute("UPDATE guests set ", args)
+        args = (request.form["fullname"],
+                int(request.form["answer"]),
+                request.form["email"],
+                request.form["mailing"],
+                int(request.form["plusone"]),
+                request.form["plusonename"],
+                int(request.form["kids"]),
+                request.form["kidsnames"],
+                request.form["comments"],
+                session["user_name"])
+        cur = db.execute("""UPDATE guests set full_name=?,
+        rsvp=?, email=?, mailing=?, plusone=?, plusonename=?, kids=?,
+        kidsnames=?, comments=? WHERE user_name=?""", args)
+        db.commit()
+        cur.close()
+        flash("We have updated your information!")
+        return redirect(url_for('rsvp'))
+
 
 @app.route('/')
 @app.route('/home/')