How can i display image from mysql to python gui ?

[2020Yasir-Sahibzada]

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

[somanyadav]

Hello @2020Yasir-Sahibzada,

I think you can try to access like this,

logo = cursor.fetchone()
img_data = logo[0]

And after that you can use the BytesIO class to wrap the image data,

img = Image.open(BytesIO(img_data))

[anuragdaksh7]

Hey @2020Yasir-Sahibzada I think you didn't included mysql imports for the code adding them might solve your issue