Das Login-Formular:
Code: Alles auswählen
import sqlite3
import hashlib
if __name__ == "__main__":
conn = sqlite3.connect('database.db')
curs = conn.cursor()
username = input('Username: ')
password = input('Password: ')
sql = (f"SELECT * FROM logindata WHERE username='{username}'")
pw = curs.execute(sql)
conn.commit()
userpassword_hash = hashlib.sha512(password.encode()).hexdigest()
if password == pw:
print('Sucess: Sucessfully loged in')
else:
print('Error: Failed to log in')
conn.close()
Code: Alles auswählen
import sqlite3
import hashlib
if __name__ == "__main__":
conn = sqlite3.connect('database.db')
curs = conn.cursor()
sql = """CREATE TABLE IF NOT EXISTS logindata (username text NOT NULL, password text NOT
NULL)"""
curs.execute(sql)
conn.commit()
username = input('Username: ')
password = input('Password: ')
password = password.encode()
password = hashlib.sha512(password).hexdigest()
print(password)
sql = "INSERT INTO logindata (username, password) VALUES ('{0}', '{1}')".format(username, password)
curs.execute(sql)
conn.commit()
conn.close()
Code: Alles auswählen
Traceback (most recent call last):
File "C:/Users/maxpr/Login System/venv/login.py", line 12, in <module>
pw = curs.execute(sql)
sqlite3.OperationalError: no such table: logindata