如何在数据库中回显存储为blob的图像？

Question

I was just wondering what the PHP code is to echo an image I've stored in a particular table of my database.

Answer 1

Well, here is the html you want for the image:

<img src="image_render.php?image_id=4" /> <!-- or any unique identifier for that image -->

in image_render.php you will want to do the following:

// get the image information base on the unique identifier passed in the URL
 header("Content-Type: image/png"); // tell the browser that this is an image
 echo $imageBlog; // this is what you took from the database

Make sure you don't add extra output in this file, or things will go bad.

That's about it.

Note

In most situations it is better/faster to simply store the image location on the server instead of the whole image, so you probably need to document yourself a bit more before making this decision.

Here is a discussion about the advantages and disadvantages of storing images in the database, and another one here.

Good luck!