furas.plPython: How to use SQLite3 to create simple login system.
import sqlite3
def create_table():
query = "DROP TABLE IF EXISTS login"
cursor.execute(query)
conn.commit()
query = "CREATE TABLE login(username VARCHAR UNIQUE, password VARCHAR)"
cursor.execute(query)
conn.commit()
def add_user(username, password):
query = "INSERT INTO login (username, password) VALUES (?, ?)"
cursor.execute(query, (username, password))
conn.commit()
def check_user(username, password):
query = 'SELECT * FROM login WHERE username = ? AND password = ?'
cursor.execute(query, (username, password))
result = cursor.fetchone()
conn.commit()
print('[DEBUG][check] result:', result)
return result
def login():
answer = input("Login (Y/N): ")
if answer.lower() == "y":
username = input("Username: ")
password = input("Password: ")
if check(username, password):
print("Username correct!")
print("Password correct!")
print("Logging in...")
else:
print("Something wrong")
# --- main ---
conn = sqlite3.connect("users.db")
cursor = conn.cursor()
create_table() # use only once
username = input("New username: ")
password = input("New password: ")
add_user(username, password)
login()
cursor.close()
conn.close()
Notes:
Stackoverflow: How do I make a login using SQLITE3 in Python?