from sqlite3 import *
from tkinter import *
from tkinter.ttk import *
from tkinter.messagebox import *
from tkinter import font



con = connect("DETAILS.db")
cur=con.cursor()


w = Tk()
w.title("Get Information")
w.geometry("400x300")



s = Style()
s.configure('Header.TFrame', background = 'blue')

header_frame = Frame(w,style = "Header.TFrame")
header_frame.pack(fill = X)

s.configure('TLabel', background = 'Blue', foreground = "White",font = ("Arial", 25))
header_label = Label(header_frame, text = "Get Details")
header_label.pack(pady = 10)


s.configure("Content.TFrame", background = 'white')
content_frame  = Frame(w,style = 'Content.TFrame')
content_frame.pack(fill = BOTH,expand = TRUE)

login_frame = Frame(content_frame ,style = 'Content.TFrame')
login_frame.place(relx = .5,rely  = .5,anchor = CENTER)

s.configure('Login.TLabel', background = 'white',foreground = "Black",font = ("arial",15))

label = Label(login_frame,text = "Enter Roll Number : ", style = "Login.TLabel")
label.grid(row = 1,column = 0)

entry = Entry(login_frame)
entry.grid(row = 1, column  = 1)

font1 = font.Font(name='TkCaptionFont', exists=True)
font1.config(family='courier new', size=20)

def get_detail():
    cur.execute("select * from student where ID ="+entry.get())
    detail = cur.fetchall()
    con.commit()

    for d in detail:
        showinfo("status"," Student Id: " + str(d[0])+"\n Name: "+str(d[1])+"\n DOB: "+str(d[2]) + "\n Father Name: " + str(d[3]) + "\n Mother Name: " + str(d[4]) + "\n Gender: " + str(d[5]) + "\n Class: " + str(d[6]))
        


button  = Button(login_frame,text = "Enter",command = get_detail)
button.grid(row = 2,column =1)