Advertisement
lessientelrunya

Get Info DB

Apr 19th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.49 KB | None | 0 0
  1. @app.route('/profile', methods=["GET", "POST"])
  2. @login_required
  3. def profile():
  4.     if request.method == "GET":
  5.         cursor = g.db.execute(
  6.             "SELECT username, first_name, last_name, birth_date FROM user WHERE id=:id",
  7.             {'id':session['user_id']})
  8.         user = cursor.fetchone()
  9.         profile2 = {'username': user[0], 'first_name': user[1], 'last_name': user[2], 'birth_date': user[3]}
  10.         return render_template('static_templates/profile.html', profile=profile2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement