Sessions in flask

 @app.route("/login",methods = ["POST","GET"])  
    def login():  
        if request.method == "POST":  
            try:   
                Email = request.form["email"]
                pwd = request.form["pwd"]    
                with sqlite3.connect("Account.db") as con:  
                    cur = con.cursor()
                    print("Connection test")   
                    cur.execute("SELECT * FROM Account WHERE Email= ? and Password= ?",(Email, pwd))
                    row = cur.fetchone()
                    print("query test")  
                    while row is not None:
                        session['email']=request.form['email']  
                        print(row[1])
                        return render_template("success.html",msg = msg)
                    else:
                        msg = "sorry wrong id"
                        return render_template("failure.html",msg = msg)
            except:  
                con.rollback()  
                msg = "problem"  
if 'email' in session:
        email = session['email']   
        return render_template("view.html") 
    else:
        return '<p>Please login first</p>'

Source: stackoverflow.com

Similar codes

0 vote251 views1 answer
AssertionError: Relational field must provide a `queryset` argument, override `get_queryset`, or set read_only=`True`
Python
1 vote144 views1 answer
Install selenium python mac anaconda
Python
0 vote154 views2 answers
Pandas select rows by condition in list
Python
0 vote186 views1 answer
Python check disk space
Python
0 vote151 views1 answer
Tranking de perosnas python
Python
0 vote216 views1 answer
Python string contains substring ignore case
Python
0 vote156 views1 answer
Python tuple range
Python
0 vote150 views1 answer
How can I keep the pyqt GUI responsive when performing a cpu intensive task?
Python
0 vote156 views1 answer
<function chr(i, /)> error in python
Python
0 vote142 views1 answer
Add text to axis
Python