Login and Signup using SQLite

In this tutorial, we will add database in Login and Signup using SQLite. In the last two tutorials, we have designed our Login and Signup windows. First of all please check the following code of application then I will explain each part of code to you.

from tkinter import *

global root;
root = Tk()

root.geometry('500x350')
root.title("Login Form")


nameVar=StringVar()
emailVar=StringVar()
passVar=StringVar()
genderVar = IntVar()
javaVar= IntVar()
pythonVar= IntVar()
    

#method to add user register data in database    
def addNew():
    name=nameVar.get()
    email=emailVar.get()
    password=passVar.get()
    gender=genderVar.get()
    prog=javaVar.get()
    conn = sqlite3.connect('StudentDatabase.db')
    with conn:
        cursor=conn.cursor()
    cursor.execute('CREATE TABLE IF NOT EXISTS StudentTable (Name TEXT,Email TEXT,Password Text,Gender TEXT,Programming TEXT)')
    count=cursor.execute('INSERT INTO StudentTable (Name,Email,Password,Gender,Programming) VALUES(?,?,?,?,?)',(name,email,password,gender,prog))
    
    if(cursor.rowcount>0):
        print ("Signup Done")
    else:
        print ("Signup Error")
    conn.commit()
    

#method to perform login    
def loginNow():
    email=emailVar.get()
    password=passVar.get()
    
    conn = sqlite3.connect('StudentDatabase.db')
    with conn:
        cursor=conn.cursor()
    cursor.execute('CREATE TABLE IF NOT EXISTS StudentTable (Name TEXT,Email TEXT,Password Text,Gender TEXT,Programming TEXT)')
    cursor.execute('Select * from StudentTable Where Email=? AND Password=?',(email,password))
    
    if cursor.fetchone() is not None:
        print ("Welcome")
    else:
        print ("Login failed")
    
    conn.commit()
   

 #method to design register window
def registerWindow(): 
    
    registerScreen=Toplevel(root)
    
    registerScreen.title("Registration Here")
    
    registerScreen.geometry('500x500')
    
    label = Label(registerScreen, text="Registration Here",width=20,fg="blue",font=("bold", 20))
    label.place(x=90,y=53)


    nameLabel = Label(registerScreen, text="FullName",width=20,font=("bold", 10))
    nameLabel.place(x=80,y=130)

    nameEntery = Entry(registerScreen,textvar=nameVar)
    nameEntery.place(x=240,y=130)

    emailLabel = Label(registerScreen, text="Email",width=20,font=("bold", 10))
    emailLabel.place(x=68,y=180)

    emailEntry = Entry(registerScreen,textvar=emailVar)
    emailEntry.place(x=240,y=180)

    passLabel = Label(registerScreen, text="Password",width=20,font=("bold", 10))
    passLabel.place(x=78,y=230)

    passEntry = Entry(registerScreen,textvar=passVar,show='*')
    passEntry.place(x=240,y=230)

    genderLabel = Label(registerScreen, text="Gender",width=20,font=("bold", 10))
    genderLabel.place(x=70,y=280)

    Radiobutton(registerScreen, text="Male",padx = 5, variable=genderVar, value=1).place(x=235,y=280)
    Radiobutton(registerScreen, text="Female",padx = 20, variable=genderVar, value=2).place(x=290,y=280)

    labelLanguage = Label(registerScreen, text="Programming",width=20,font=("bold", 10))
    labelLanguage.place(x=88,y=325)

    Checkbutton(registerScreen, text="java", variable=javaVar).place(x=238,y=325)

    Checkbutton(registerScreen, text="python", variable=pythonVar).place(x=310,y=325)

    Button(registerScreen, text='Submit',width=20,bg='blue',fg='white',pady=5,command=addNew).place(x=180,y=380)

    
    
label = Label(root, text="Login Here",width=20,fg="blue",font=("bold", 20))
label.place(x=90,y=53)


emailLabel = Label(root, text="Email",width=20,font=("bold", 10))
emailLabel.place(x=68,y=130)

emailEntry = Entry(root,textvar=emailVar)
emailEntry.place(x=240,y=130)

passwordLabel = Label(root, text="Password",width=20,font=("bold", 10))
passwordLabel.place(x=68,y=180)

passwordEntry = Entry(root,textvar=passVar,show='*')
passwordEntry.place(x=240,y=180)

Button(root, text='Login Now',width=20,bg='blue',fg='white',pady=5,command=loginNow).place(x=180,y=230)

Button(root,text="Have no Accout! Create one",bg="red",fg="white",font=("bold",10),command=registerWindow).place(x=170,y=280)

root.mainloop()

Parvesh Sandila

Parvesh Sandila is a passionate web and Mobile app developer from Jalandhar, Punjab, who has over six years of experience. Holding a Master’s degree in Computer Applications (2017), he has also mentored over 100 students in coding. In 2019, Parvesh founded Owlbuddy.com, a platform that provides free, high-quality programming tutorials in languages like Java, Python, Kotlin, PHP, and Android. His mission is to make tech education accessible to all aspiring developers.​