-
Notifications
You must be signed in to change notification settings - Fork 28
/
tkinter5.py
121 lines (107 loc) · 3.71 KB
/
tkinter5.py
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
#!/usr/bin/env python
# coding: utf-8
# In[ ]:
from openpyxl import *
from tkinter import *
from PIL import ImageTk, Image
import sqlite3
def focus1(event):
LastName_field.focus_set()
def focus2(event):
FName_field.focus_set()
def focus3(event):
share_field.focus_set()
def focus5(event):
mobile_no_field.focus_set()
def focus6(event):
email_id_field.focus_set()
def focus10(event):
title_field.focus_set()
def clear():
title_field.delete(0, END)
LastName_field.delete(0, END)
FName_field.delete(0, END)
share_field.delete(0, END)
mobile_no_field.delete(0, END)
email_id_field.delete(0, END)
def insert():
if (title_field.get() == "" and LastName_field.get() == "" and FName_field.get() == "" and share_field.get() == "" and mobile_no_field.get() == "" and email_id_field.get() == ""):
print("empty input")
else:
# set focus on the title_field box
title_field.focus_set()
a=title_field.get()
b=LastName_field.get()
c=FName_field.get()
d=share_field.get()
f=mobile_no_field.get()
g=email_id_field.get()
conn = sqlite3.connect('form3.db')
with conn:
cursor=conn.cursor()
cursor.execute('CREATE TABLE IF NOT EXISTS Person(ID INTEGER PRIMARY KEY,Last TEXT,First TEXT,Share TEXT,Mobile INT,Email)')
cursor.execute('INSERT INTO Person(ID,Last,First,Share,Mobile,Email) VALUES(?,?,?,?,?,?)',(a,b,c,d,f,g,))
conn.commit()
clear()
if __name__== "__main__":
root = Tk()
root.configure(background='white')
root.title("Person Info form")
root.geometry("800x700")
heading = Label(root, text="Form", bg="white")
title = Label(root, text="ID", bg="white")
LastName = Label(root, text="Last Name", bg="white")
FName = Label(root, text="First Name", bg="white")
share = Label(root, text="Date of Birth (dd/mm/yyyy)", bg="white")
mobile_no = Label(root, text="Mobile No.", bg="white")
email_id = Label(root, text="Email id", bg="white")
heading.grid(row=0, column=1)
title.grid(row=1, column=0)
LastName.grid(row=2, column=0)
FName.grid(row=3, column=0)
share.grid(row=4, column=0)
mobile_no.grid(row=6, column=0)
email_id.grid(row=7, column=0)
title_field = Entry(root)
LastName_field = Entry(root)
FName_field = Entry(root)
share_field = Entry(root)
mobile_no_field = Entry(root)
email_id_field = Entry(root)
title_field.bind("<Return>", focus10)
LastName_field.bind("<Return>", focus1)
FName_field.bind("<Return>", focus1)
share_field.bind("<Return>", focus3)
mobile_no_field.bind("<Return>", focus5)
email_id_field.bind("<Return>", focus6)
title_field.grid(row=1, column=1, ipadx="50")
LastName_field.grid(row=2, column=1, ipadx="50")
FName_field.grid(row=3, column=1, ipadx="50")
share_field.grid(row=4, column=1, ipadx="50")
mobile_no_field.grid(row=6, column=1, ipadx="50")
email_id_field.grid(row=7, column=1, ipadx="50")
submit = Button(root, text="Submit", fg="Black",bg="Red", command=insert)
submit.grid(row=29, column=2)
root.mainloop() #closed
my_conn = sqlite3.connect('form3.db')
import tkinter as tk
from tkinter import *
my_w = tk.Tk()
my_w.geometry("1000x1000")
month = int(input())
i=0
r_set1=my_conn.execute('''SELECT * from person LIMIT 0,4''');
for student1 in r_set1:
t1=student1[3][3]+student1[3][4]
k1 = (int)(t1)
if(k1==month):
for j in range(len(student1)):
e = Entry(my_w, width=10, fg='blue')
e.grid(row=i, column=j)
e.insert(END, student1[j])
print(student1[j],end= " ")
i=i+1
else:
continue
print(end="\n")
my_w.mainloop()