Sqlite3 database Python conditional statement

Question

import sqlite3
conn = sqlite3.connect('LeVinEmployee.db')
profile = input("Are you a user? y/n: ")
if profile == 'y':
    login = input("Enter login name: ")
    #passw = input("Enter password: ")
    c = conn.cursor()
    c.execute("SELECT * FROM Employee WHERE Email = '" + login + "'")
    result = c.fetchone()
    if result[0] == 1:
         print(c.fetchall())
    else:
         print("not")

else:
    print("You are not a user")

What I am trying to do here is pretty simple. I am trying to create user login function. If user type 'y', program will simply ask to put login email. If user type correct email from database, print that customer information. if wrong, print 'not'. I am not sure what is wrong with my code. Can someone help me please?

kvorobiev · Accepted Answer · 2017-10-21 20:49:02Z

2

As I understand, email is an unique field. And your query could return one record or nothing (None). Try

result = c.fetchone()
if result:  # result could be None or tuple (record)
     print(result)
else:
     print("not")

Also, such method of parameter pass is incorrect (insecure)

c.execute("SELECT * FROM Employee WHERE Email = '" + login + "'")

use

c.execute("SELECT * FROM Employee WHERE Email=?", login)

more info here.

answered Oct 21, 2017 at 20:49

kvorobiev

5,0704 gold badges32 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vincent Lynn Over a year ago

It works. Thanks alot. I assume if i want to check password, it will be the same right?

kvorobiev Over a year ago

@Vincent Lynn You are welcome) Yes, it will be the same. Something like c.execute("SELECT * FROM Employee WHERE Email=? AND pass=?", login, pass)

Vincent Lynn Over a year ago

Very helpful. Thank you

Collectives™ on Stack Overflow

Sqlite3 database Python conditional statement

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related