Search on blog:

Python: 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?

Python: Jak użyć SQLite3 do stworzenia prostego systemu logowania.

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 …

« Page: 1 / 1 »