From: Robert Hazeltine Date: March 14 1999 10:22am Subject: Re: Displaying image from database List-Archive: http://lists.mysql.com/mysql/200 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Sun, 14 Mar 1999, kalle volkov wrote: > hi! > > if u use PHP3 and MySQL then the PHP script should look smthng like > this: ... Thanks very much! However, I guess I should've mentioned I am using Perl and DBI to do this. I am also using Cgi.pm. The interesting thing is in both PHP and Perl, you had to call "header (content/type)" to do this. Whatever, the PHP solution would be fine, but written in Perl! Thanks rob.... > --- > 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 > > > > > > > > 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/ > > > > --------------------------------------------------------------------- > > To request this thread, e-mail mysql-thread197@stripped > > > > To unsubscribe, e-mail the address in the List-Unsubscribe header. > > For additional commands, e-mail: mysql-help@stripped > 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/