mySQL, BLOBs and image streams
Date: 02/09/07
(PHP Community) Keywords: browser, html, database, java
I was wondering if anyone had thought of a useful way to get images out of BLOB fields in a database table and send them to a rendered HTML page inline. This whole calling another script via a URI that fetches the picture as a served "page" via a second request seems very redundant.
I've seen the client side encoded binary tricks through javascript, and they are clever but rely on the client's browser settings too much to be comfortable. The fact that IE refuses to implement the data: URI is a pain in the royal parts. An idea I had was to save the results as temp files and serve them that way, but again, terribly redundant - not to mention hard on the server.
So have any bright sparks come up an elegant and W3C friendly way to pull an image binary from a BLOB and include it in an tag?
(I'm aware of the database overhead with many BLOBs - this is just an exercise in extreme cleverness)
Source: http://community.livejournal.com/php/539857.html