RKPpRiLw

1import sqlite3
2from tkinter import *
3
4global namein, addin, depin, phin, emin
5
6
7with sqlite3.connect('rbdb.db') as db:
8    cur = db.cursor()
9
10cur.execute('''
11CREATE TABLE IF NOT EXISTS "INFO" (
12	"Name"	TEXT,
13	"Address"	TEXT,
14	"Dept"	TEXT,
15	"Phno"	NUMERIC UNIQUE,
16	"Email"	TEXT,
17	"PRN"	INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE
18);
19''')
20
21
22def prnincr(PRN):
23    PRN=PRN+1
24    
25def final():
26    finalwin=Tk()
27    finalwin.geometry("400x100")
28    finalwin.title("Details")
29    f=Frame(finalwin)
30    f.grid()
31    prnincr(PRN)
32    cur.execute("INSERT INTO INFO(Name, Address, Dept, Phno, Email, PRN) VALUES(?, ?, ?, ?, ?, ?);", (NAME, ADD, DEP, PH, EM, PRN))
33    db.commit()
34    l=Label(f, text="Your name, address, dept, phone number, email id, and PRN are as follows")
35    l.grid(row=1)
36    cur.execute("SELECT * FROM INFO WHERE Phno=?", (PH,))
37    l1=Label(f, text=cur.fetchone())
38    l1.grid(row=2)
39    addbtn=Button(f, text="Add another entry", command=f1)
40    quitbtn=Button(f, text="Quit", command=quit)
41    addbtn.grid()
42    quitbtn.grid()
43    finalwin.mainloop()
44
45def f1():
46    global NAME, ADD, DEP, PH, EM
47
48    NAME = namein.get()
49    ADD = addin.get()
50    DEP = depin.get()
51    PH = phin.get()
52    EM = emin.get()
53    final()
54
55root = Tk()
56root.geometry("240x140")
57root.title("Student ID Generating System")
58f = Frame(root)
59f.grid()
60l = Label(f, text="Enter name")
61l.grid(row=1)
62l1 = Label(f, text="Enter address")
63l1.grid(row=2)
64l2 = Label(f, text="Enter department")
65l2.grid(row=3)
66l3 = Label(f, text="Enter phone number")
67l3.grid(row=4)
68l4 = Label(f, text="Enter email")
69l4.grid(row=5)
70namein = Entry(f, width=15)
71namein.grid(row=1, column=1)
72addin = Entry(f, width=15)
73addin.grid(row=2, column=1)
74depin = Entry(f, width=15)
75depin.grid(row=3, column=1)
76phin = Entry(f, width=15)
77phin.grid(row=4, column=1)
78emin = Entry(f, width=15)
79emin.grid(row=5, column=1)
80
81def assignprn():
82    global PRN
83    PRN=171042365
84
85assignprn()
86
87btn = Button(f, text="Accept", command=f1)
88btn.grid(row=6)
89
90root.mainloop()