Registration Form With sqlite3 database using tkinter python

Registration Form With sqlite3 database using tkinter python

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73

from tkinter import * import sqlite3   root = Tk() root.geometry('600x500') root.title("Registration Form")     Fullname=StringVar() Email=StringVar() var = IntVar() c=StringVar() var1= IntVar()       def database():    name1=Fullname.get()    email=Email.get()    gender=var.get()    country=c.get()    prog=var1.get()    conn = sqlite3.connect('Form.db')    with conn:       cursor=conn.cursor()    cursor.execute('CREATE TABLE IF NOT EXISTS Student (Fullname TEXT,Email TEXT,Gender TEXT,country TEXT,Programming TEXT)')    cursor.execute('INSERT INTO Student (FullName,Email,Gender,country,Programming) VALUES(?,?,?,?,?)',(name1,email,gender,country,prog,))    conn.commit()                          label_0 = Label(root, text="Registration form",width=20,font=("bold", 20)) label_0.place(x=90,y=53)     label_1 = Label(root, text="FullName",width=20,font=("bold", 10)) label_1.place(x=80,y=130)   entry_1 = Entry(root,textvar=Fullname) entry_1.place(x=240,y=130)   label_2 = Label(root, text="Email",width=20,font=("bold", 10)) label_2.place(x=68,y=180)   entry_2 = Entry(root,textvar=Email) entry_2.place(x=240,y=180)   label_3 = Label(root, text="Gender",width=20,font=("bold", 10)) label_3.place(x=70,y=230)   Radiobutton(root, text="Male",padx = 5, variable=var, value=1).place(x=235,y=230) Radiobutton(root, text="Female",padx = 20, variable=var, value=2).place(x=290,y=230)   label_4 = Label(root, text="country",width=20,font=("bold", 10)) label_4.place(x=70,y=280)   list1 = ['Philippines','Japan','Korea','China','Singapore','Hong kong'];   droplist=OptionMenu(root,c, *list1) droplist.config(width=15) c.set('select your country') droplist.place(x=240,y=280)   label_4 = Label(root, text="Programming",width=20,font=("bold", 10)) label_4.place(x=85,y=330) var2= IntVar() Checkbutton(root, text="java", variable=var1).place(x=235,y=330)   Checkbutton(root, text="python", variable=var2).place(x=290,y=330)   Button(root, text='Submit',width=20,bg='brown',fg='white',command=database).place(x=180,y=380)   root.mainloop()