How can i display image from mysql to python gui ? #1088
Description
I am trying , like this :
from tkinter import *
from io import BytesIO
window= Tk()
db=MySQLdb.connect("localhost","root","??","??")
cursor=db.cursor()
sql= "SELECT LOGO FROM SYSTEMDETAILS" cursor.execute(sql)
logo=cursor.fetchone()
img = Image.open(BytesIO(logo))
phimg = ImageTk.PhotoImage(img)
panel = Label(window, image = phimg)
panel.pack()
When i run this, it show error in line 9 , it want logo as an object but in here its tuple
Activity
somanyadav commentedon Dec 23, 2022
Hello @2020Yasir-Sahibzada,
I think you can try to access like this,
And after that you can use the BytesIO class to wrap the image data,
anuragdaksh7 commentedon Jun 4, 2023
Hey @2020Yasir-Sahibzada I think you didn't included mysql imports for the code
adding them might solve your issue