How to retrieve an image from mysql to PyQt4 with python3?

Question

I want to show an image from mysql db on my pyqt4 application. I researched some pages about this topic. But I can not get that. I want to show the image on qlabel.

I have gui file and a callpage.py

From callpage.py I want to show like this:

self.ui.labelPicture.setPixmap(QtGui.QPixmap(img))

How to display a picture from mysql database using python?

How to insert / retrieve a file stored as a BLOB in a MySQL db using python

user1767754 · Accepted Answer · 2017-11-25 10:43:11Z

0

You are basically asking for 2 question. Here are two steps, the first involves you retrieving the base64 image, the second one is the actuall pyqt code.

1) First you need to get your your sql query as base64

Which is described well here: How to display a picture from mysql database using python?

2) Populate a QPixmap and pass it to your label

pm = QtGui.QPixmap()
pm.loadFromData(base64.b64decode(b64_data))
self.ui.labelPicture.setPixmap(QtGui.QPixmap(pm))

answered Nov 25, 2017 at 10:43

user1767754

25.5k21 gold badges167 silver badges177 bronze badges

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

1 Comment

aoyilmaz Over a year ago

All right. I understand why my comment/answer is deleted. I am a newbie. :) Okay. Now my actual problem is there is no image on the label widget. it is getting empty. How can I sure that my code is working?

Collectives™ on Stack Overflow

How to retrieve an image from mysql to PyQt4 with python3?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related