Using PHP To Print Elements From MySQL Database As Links To Respective Image

Question

Say I have a MySQL database structured like this:

id    name    png
1     Bob     img1
2     Jim     img2
.      .       .
.      .       .
.      .       .

where the png column store images as the BLOB datatype.

What I would like to do is loop through the database and print out all of the contents in the "name" field on a page where each name link provides a link to the respective image. Any feedback would be most helpful.

Another Code · Accepted Answer · 2012-03-02 20:25:02Z

1

If the images are only saved as a BLOB in the database, you'll have to write a second script that fetches an image from the database and sends it to the client. You can then output links to this script (with a GET parameter so the correct image is displayed).

If the images are very small, I think you could also do it with the data URI scheme (you'd have to output the BLOB content of every image encoded as base64 inside the href of the link).

answered Mar 2, 2012 at 20:25

Another Code

3,14123 silver badges23 bronze badges

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

2 Comments

RobinJ Over a year ago

Or you could just save the images in the database as base64 =)

Another Code Over a year ago

@RobinJ: base64 has about 33% overhead compared to the original data, so it will take up a lot of storage space unnecessarily. Also, a rule of thumb is to always store data in databases in their most pure and natural form, in this case the binary representation of the image file.

Collectives™ on Stack Overflow

Using PHP To Print Elements From MySQL Database As Links To Respective Image

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related