CODEWITHSUNDEEP
phpmysqlblob
Sudantha
Sudantha

Reputation: 16194

Show a BLOB image PHP MySQL along with other data

I have some data stored in a MySQL database .. i would like to show the stored image data along with other data in a .php page..

if i fetch data from the database and use header("Content-type: image/jpeg"); its not possible to show the image with other php data.. is there a a other way ?

Upvotes: 3

Views: 38470

Answers (2)

Murolack
Murolack

Reputation: 2167

It depends how you stored you data, but sometimes you have to convert the data to base64. Try this

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

Upvotes: 2

Atticus
Atticus

Reputation: 6720

If you set the header to image/jpeg that treats your entire page as an image file.. You want the data to be insert into the image holder only.

Try something like this

<img alt="Embedded Image" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIA..." />

Where you will next echo the blob data into the image src

 <img alt="Embedded Image" src="data:image/png;base64,<?php echo $image->blob_data; ?> "/>

Upvotes: 4

Related Questions