Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- conn = sqlite3.connect('example.db')
- c = conn.cursor()
- create_users = 'CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, login VARCHAR(200), password VARCHAR(200))'
- c.execute(create_users)
- conn.commit()
- a = raw_input("Please type your login and password \n")
- login, password = a.split()
- # insert_user = 'INSERT INTO users (login,password) VALUES("{}","{}")'.format(login,password)
- # c.execute(insert_user)
- # conn.commit()
- get_user = 'SELECT * from users WHERE login = "{}" AND password = "{}"'.format(login,password)
- c.execute(get_user)
- user = c.fetchone()
- if user is None:
- print("NO DATA FOR YOU, LOOSER")
- else:
- print("Hello, " + user[1])
- conn.close()
Add Comment
Please, Sign In to add comment