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

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here