List:General Discussion« Previous MessageNext Message »
From:Chris Date:March 17 1999 10:00pm
Subject:Re: Displaying image from database
View as plain text  
Rob, how about storing the full paths of the images in the database and inserting them
into your HTML pages? That would also cut down on your DB size a little!


On Sun, 14 Mar 1999 04:51:07 Robert Hazeltine wrote:
> 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?

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