complete crud code

 

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
root=Tk()
import pandas

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")

     #dic={"id":[var],"item_name":[var2],"price":[var3]}
    # df=pd.DataFrame(data=dic)

    except:
        print("error occured")
def view_data():
    try:
        v1=e_1.get()
        sql="select * from dokan where id= %s"
        value=(v1,)
        mycursor.execute(sql,value)

        myresult=mycursor.fetchall()
        for x in myresult:
            print(x)
        print("record find successfully")
    except:
        print("error in view function")

def update_data():
    v1 = e_1.get()
    v2 = e_2.get()
    v3 = e_3.get()
    try:

        print(v1,v2,v3)
        sql_="update dokan set item_name=%s,price=%s where id=%s"
        value_=(v2,v3,v1)
        mycursor.execute(sql_,value_)
        mydb.commit()
        print("record updated successfully")
    except:
           print("update error")



def delete_data():
    try:
        v1=e_1.get()
        sql="delete from dokan where id= %s"
        value=(v1,)
        mycursor.execute(sql,value)




        mydb.commit()


        print("record deleted")

    except:
        print("error in view function")




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)
#insertion button
btn_1=Button(root,text="Add Item",bg="#a2812a",width=10,command=insert_data)
#fit button in a window and a window into canvas
i_b=mycanvas.create_window(250,200,window=btn_1)
#search button
bt_2=Button(root,text="Search Item",bg="#a2812a",width=10,command=view_data)
s_b=mycanvas.create_window(400,200,window=bt_2)
#update button
bt_3=Button(root,text="Update record",bg="#a2812a",width=10,command=update_data)
u_d=mycanvas.create_window(250,250,window=bt_3)
#delete button
bt_4=Button(root,text="Delete record",bg="#a2812a",width=10,command=delete_data)
d_d=mycanvas.create_window(400,250,window=bt_4)





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()