List:General Discussion« Previous MessageNext Message »
From:Robert Hazeltine Date:March 14 1999 9:51am
Subject:Displaying image from database
View as plain text  
Hi
I am working on a project whereby all the relevant data is stored in the 
Mysql database and then when required the data is compiled into 
a web page.

I have all the text data working properly, but cannot figure out how
to display the image BLOBS I have created at the same time, or 
being able to format them within the appropriate HTML tags.

I was hoping I could do something similar to (pseudo-code):

# get the image from the database
$image = "select image from table where id = foo";
 
# display the image in HTML

<IMG SRC = "$image">


I tried many different ways of getting to this, but none of them 
work.  I found an example in a news archive somewhere that lets 
me display the BLOB direct from the database, but it requires that 
I pass a lot of the information about the file (content/type &c) 
myself and it does not let me do any proper formatting on the images 
layout and nor can I display text in the browser at the same time.

Given that I have my image BLOB properly accessible in the database,
and I can already pop out any arbitrary text as I wish, what do I 
do next for images?


Thanks

Rob...
Robert Hazeltine                      Member of UWSN Web Management Group
Project Officer (Web Development)     Phone:  +61 (2) 4736 0218
Central Administration                Email:  r.hazeltine@stripped
University of Western Sydney, Nepean  http://www.nepean.uws.edu.au/

Thread
Displaying image from databaseRobert Hazeltine14 Mar
  • Re: Displaying image from databasekalle volkov14 Mar
    • Re: Displaying image from databaseRobert Hazeltine14 Mar
      • Re: Displaying image from databaseThimble Smith15 Mar
    • Re: Displaying image from databaseOliver Artelt15 Mar
  • Re: Displaying image from databaseSasha Pachev15 Mar
Re: Displaying image from databaseChris17 Mar
  • Re: Displaying image from databaseTommi Rintala17 Mar