Display image(BLOB) from mysql database to tkinter window

Question

My database contains an image(BLOB) named LOGO. I want to display the image on python TkInter window

 import Tkinter
    window= Tk()
    db= MySQLdb.connect("localhost","root","anup","NursecallDB")
    cursor=db.cursor()
    sql= "SELECT LOGO FROM SYSTEMDETAILS"
    cursor.execute(sql)
    logo=cursor.fetchone()
    img =PhotoImage(logo)
    panel = Tkinter.Label(window, image = img)
    panel.grid(row=0,rowspan=5,columnspan=2)
    window.mainloop()

when I am running this program it shows error at

panel = Tkinter.Label(window, image = img)
TypeError:_str_returned non-string(type tuple)

Akash Nil · Accepted Answer · 2015-04-09 05:05:15Z

1

upload the image to a folder and insert the path into database. If logo is the path of the image. then program will work.

answered Apr 9, 2015 at 5:05

Akash Nil

7031 gold badge10 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DARK_DUCK · Accepted Answer · 2015-04-02 08:47:29Z

0

PhotoImage take a string into argument which is the filename of the image you want to load or y Python image object. It cannot take blob as an argument. What you need is to load the image from a buffer (see the method here http://effbot.org/imagingbook/image.htm) and then pass the image to the PhotoImage constructor

answered Apr 2, 2015 at 8:47

DARK_DUCK

1,7772 gold badges12 silver badges22 bronze badges

1 Comment

Anup Sarkar Over a year ago

<?php if( $_FILES['image']['name'] != "" ) { copy( $_FILES['image']['name'], "/home/pi/image" ) or die( "Could not copy file!"); } else { die("No file specified!"); } ?> I have a RPI server and i am writing the above code to save the uploaded image.it shows could not copy file.

iceburn_pt · Accepted Answer · 2019-10-04 09:02:10Z

0

If you, like me, don't want to pass the image through disk this is what the code looks like for python3 (following DARK_DUCK suggestion):

    from io import BytesIO
    from PIL import Image, ImageTk

    ...

    logo=cursor.fetchone()

    img = Image.open(BytesIO(logo))    
    phimg = ImageTk.PhotoImage(img)

    panel = Tkinter.Label(window, image = phimg)
    panel.grid(row=0,rowspan=5,columnspan=2)

I think that for python 2.7 you'll have to use StringIO instead of BytesIO. See: Python PIL reading PNG from STDIN

answered Oct 4, 2019 at 9:02

iceburn_pt

13 bronze badges

Collectives™ on Stack Overflow

Display image(BLOB) from mysql database to tkinter window

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related