image saved as blob does not display

Question

I have followed these examples

Have same way of displaying image saved as blob. I have field name picture longblob

if ( ! $(this).prev().hasClass('input-ghost') ) {
    var element = $("<input type='file' class='input-ghost' style='visibility:hidden; height:0'>");
    element.attr("name",$(this).attr("name"));
    element.change(function(){
     element.next(element).find('input').val((element.val()).split('\\').pop());
    });

to save in table i put it in an array and save in table along other fields

saved in db like this now i want to display image in table row it in table row by using this

<td> echo '<img src="data:image/png;base64,' .base64_encode( $row['Picture_File'] ). '" />';?></td>

It gives error of

Cannot use object of type stdClass as array in

I want to display image as well as allow to download it

After implementing @Hassaan's answer I got the following output.

Somewhere you are using something as an array which is actually an object. Could be that $row["Picture_File"] should be $row->Picture_File. But I cannot see the code that generates your $row variable. — cjs1978, May 31 '18 at 20:32

Muhammad Hassaan · Accepted Answer · 2018-05-31T20:42:40.390

1

It seems to be you are using OOP method of Database connection. I hope the following will resolve the issue.

Replace

$row['Picture_File']

into

$row->Picture_File

Full line of code

echo '<img src="data:image/png;base64,'.base64_encode($row->Picture_File).'">';

NOTE:

Make sure to change mime type near image/png; to respective. For example if jpg then change into image/jpeg; etc

Tip

While save image as blob into database, you may need to store mime type too.

edited May 31 '18 at 20:42

answered May 31 '18 at 20:32

Muhammad Hassaan

7,296
6
30
50

echo ''; – Sarah_Salar May 31 '18 at 20:37
@Sarah_Salar Make sure you are aso assigning right mime type to image. I have updated my answer as well with example. – Muhammad Hassaan May 31 '18 at 20:43
@Sarah_Salar as you are saving other data into database. Just get mime type of image and save into separate field. – Muhammad Hassaan May 31 '18 at 20:54
if select mime type in creating a field in the table does it work – Sarah_Salar May 31 '18 at 20:56
@Sarah_Salar I did not get it. For this issue you can ask new question. As of issue mentioned in this question is resolved. You can mark tick on my answer if you found it useful. – Muhammad Hassaan May 31 '18 at 21:01
kindly view new pic added – Sarah_Salar May 31 '18 at 21:04
@Sarah_Salar ok yes this will work. You just need to pass selected type to post request and save into database field. You can also auto detect this via PHP easily – Muhammad Hassaan May 31 '18 at 21:05
u meant i have to create another filed for this? but how does it work with image field – Sarah_Salar May 31 '18 at 21:16
While fetching blob data from database, you also need to fetch the field where mime is stored and use this in code near `image/png` as `'.$row->mime_type_field.'` – Muhammad Hassaan May 31 '18 at 21:19
but image row show this path and it contains image type so why i need to save type in another field – Sarah_Salar Jun 01 '18 at 04:27

image saved as blob does not display

1 Answers1