creating gui interface for crud function

 

from tkinter import *
#lets create first interface for dokan
from tkinter import *
#now set the background image for app
from PIL import ImageTk,Image
import mysql.connector

mydb=mysql.connector.connect(
    host="localhost",
    user="root",
    password="123456789",
    database="practice"


)
mycursor=mydb.cursor()
def insert_data():
    v1=e_1.get()
    v2=e_2.get()
    v3=e_3.get()
    print(v1,v2,v3)
    try:
     sql="insert into dokan(id,item_name,price)values(%s,%s,%s)"
     values=(v1,v2,v3)
     mycursor.execute(sql,values)
     mydb.commit()
     print("Successfully Record Stored")
    except:
        print("error occured")






root=Tk()
root.geometry("800x450")
root.title("Shop Manager")
root.iconbitmap("E:\\python projects\\shops_awP_icon.ico")
f_1=Frame(root).pack(fill='y')
l_1=Label(f_1,text="Shop Manager",relief=GROOVE,bg="#a2812a",width=100).pack()
image_link=Image.open("E:\\python projects\\a.jpg")
image_open=ImageTk.PhotoImage(image_link)
mycanvas=Canvas(root,width=600,height=600)
mycanvas.pack(fill=BOTH,expand=True)
mycanvas.create_image(0,0,image=image_open,anchor="nw")
id_=Label(root,text="User Id :",bg="#a2812a",width=10,relief=GROOVE,pady="5")
item_name=Label(root,text="Item Name :",width=10,bg="#a2812a",relief=GROOVE,pady="5")
price=Label(root,text="Price :",width=10,bg="#a2812a",relief=GROOVE,pady="5")
i_o_u=mycanvas.create_window(250,50,window=id_)
i_n=mycanvas.create_window(250,100,window=item_name)
p_o_i=mycanvas.create_window(250,150,window=price)

var=StringVar
var2=StringVar
var3=StringVar
e_1=Entry(root,textvariable=var,width=30,bg="#a2812a",bd=6)
e_1_=mycanvas.create_window(400,50,window=e_1)
e_2=Entry(root,textvariable=var2,width=30,bg="#a2812a",bd=6)
e_2_=mycanvas.create_window(400,100,window=e_2)
e_3=Entry(root,textvariable=var3,width=30,bg="#a2812a",bd=6)
e_3_=mycanvas.create_window(400,150,window=e_3)

btn_1=Button(root,text="Add Item",bg="#a2812a",width=10,command=insert_data)
i_b=mycanvas.create_window(250,200,window=btn_1)
bt_2=Button(root,text="Search Item",bg="#a2812a",width=10)
s_b=mycanvas.create_window(400,200,window=bt_2)


def resizer(e):
    global image_link_,resized_image,image_open_
    image_link_ = Image.open("E:\\python projects\\a.jpg")
    resized_image=image_link_.resize((e.width,e.height),Image.ANTIALIAS)
    image_open_ = ImageTk.PhotoImage(resized_image)
    mycanvas.create_image(0, 0, image=image_open_, anchor="nw")

root.bind('<Configure>',resizer)

root.maxsize(600,600)
root.minsize(300,300)
root.mainloop()