MySQL BLOB back to image with PHP

tuomol

Hi,

I am a beginner with PHP and especially with MySQL databases. I have a form for storing data and also a couple of images as blob to db. Now I would need to retrieve those images from the db. How do I do that?

I tried to find some help from this forum, but I didn't understand those examples I found at all.

[deleted]

Now you've learnt one reason why it's is a very very bad idea to put binaries in a database.

The others are mentioned here:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=22

Oh, and here's an example of how to put data in and get how to get it back out:
http://www.phpbuilder.com/columns/florian19991014.php3

tuomol

Perhaps I will think this over once again. I thought it would be best in 'a kind of' user gallery to have all data stored in the database incl. user photos, but perhaps those image files should be saved in a certain folder instead. Any suggestions?