Advertisement
Guest User

Untitled

a guest
Feb 11th, 2019
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. import time
  2. import sqlite3
  3.  
  4. db = sqlite3.connect('userdetails.db')
  5. cursor = db.cursor()
  6.  
  7. #start
  8.  
  9. time.sleep(1)
  10.  
  11. print(' Please Select An Option Below')
  12.  
  13. menu = input(""" Login - Sign up
  14. """)
  15. print('------------------------------------------')
  16. time.sleep(1)
  17.  
  18. #sign up
  19.  
  20. if menu == "Sign up":
  21. sign_1 = input ("""Please enter a new username
  22. """)
  23.  
  24. sign_2 = input ("""Please enter a new password
  25. """)
  26. time.sleep(1)
  27. print('------------------------------------------')
  28. print('Account successfully created')
  29. print(' - ')
  30. time.sleep(2)
  31. print('Hey there ' + sign_1 + ' thanks for signing up!')
  32. time.sleep(1.4)
  33. print(' - ')
  34. print('Run the script again and log in with your new account')
  35.  
  36. cursor.execute('INSERT INTO detail(usernames, passwords)VALUES(?,?)', (sign_1, sign_2))
  37. db.commit()
  38. quit()
  39.  
  40. #login
  41.  
  42. elif menu == "Login":
  43. login_1 = input ("""Please enter your username
  44. """)
  45.  
  46. login_2 = input ("""Please enter your password
  47. """)
  48.  
  49. find_user = ("SELECT * FROM detail WHERE usernames = ? AND passwords = ?")
  50. cursor.execute(find_user,[(login_1),(login_2)])
  51. results = cursor.fetchall()
  52.  
  53. if results:
  54. for i in results:
  55. print('welcome')
  56. else:
  57. print('Incorrect Details')
  58. again = input('Would you like to try again (y/n')
  59. if again == "y":
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement