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 ?

回答1:

Read this: displaying an image stored in a mysql blob

回答2:

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; ?> "/>

回答3:

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) . '"/>