Displaying all records of Blob images in Tkinter

1. Displaying all records of MySQL table with photo ( Blob data type )
2. Uploading and inserting image data to Blob column of MySQL table
3. Listing the record with all details based on user selection.
4. Updating Blob data by uploading new image
5. Deleting record with Blob data

About MySQL table student_profile.

CREATE TABLE `student_profile` (
  `id` int NOT NULL,
  `student` varchar(10) NOT NULL,
  `profile_photo` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
COMMIT;

CREATE TABLE IF NOT EXISTS student_profile(id integer,
	student text,profile_photo blob);

Displaying record details with Photo

my_conn = create_engine("mysql+mysqldb://userid:password@localhost/database_name")my_row=my_conn.execute("SELECT * FROM student_profile limit 0,4")for student in my_row:	pass

    e = Label(my_w, text=student[0])     e.grid(row=i,column=1,ipadx=20)     e = Label(my_w, text=student[1])     e.grid(row=i,column=2,ipadx=60) 

import iofrom PIL import Image, ImageTk

    stream = io.BytesIO(student[2])    img=Image.open(stream)    img = ImageTk.PhotoImage(img)        e = Label(my_w, image=img)     e.grid(row=i, column=3,ipady=7)    images.append(img) # garbage collection 

import tkinter  as tk from tkinter import * from sqlalchemy import create_engineimport iofrom PIL import Image, ImageTkmy_w = tk.Tk() # parent window my_w.geometry("400x500") # size as width heightmy_w.title("www.plus2net.com")  # Adding a title# database connection my_conn = create_engine("mysql+mysqldb://userid:password@localhost/database_name")my_row=my_conn.execute("SELECT * FROM student_profile limit 0,4")
# Column headers  row 0l1=Label(my_w, text='ID') l1.grid(row=0,column=1) 
l2=Label(my_w, text='Name') l2.grid(row=0,column=2) 
l3=Label(my_w, text='Photo') l3.grid(row=0,column=3) 
i=1 # data starts from row 1 images = [] # to manage garbage collection. 
for student in my_row:     stream = io.BytesIO(student[2])    img=Image.open(stream)    img = ImageTk.PhotoImage(img)        e = Label(my_w, text=student[0])     e.grid(row=i,column=1,ipadx=20)     e = Label(my_w, text=student[1])     e.grid(row=i,column=2,ipadx=60)     e = Label(my_w, image=img)     e.grid(row=i, column=3,ipady=7)      images.append(img) # garbage collection     i=i+1    my_w.mainloop()

Deleting record

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: