Storing / Retrieving Image from Database

[SpanKie]

Anyone have a good solid tutorial or tutorial site for storing an image in the database and showing it back on pages with other elements.

Most of the tutorials I read they don’t show how to write the image to the page with other html output. I viewed the article here on PHP Builder about it .. but I can only get it to work if its the only output sent to the browser ..

[trex005]

if I'm understanding correctly, you want the image to display inline with the HTML?

HTML does not have the ability to do this.. so, what you do is call an external script using the HTML tag eg
<IMG SRC='make_my_image.php?image_id=1'>

so, the script's only output is still to the browser, and the image is displayed inline in the page

[superwormy]

Yeah, you can't "write the image to the page with other html output", you can only embed a link to a PHP file which spits out the image in your HTML.

Also, it should be noted that you probably don't want to store your images in a database anyway. The MySQL and PostgreSQL developers both reccomend against it, the filesystem does a much better job of caching.