From: Colin Ross <colinross@gmail.com>
To: pgsql-php@postgresql.org
Subject: Re: php, postgresql and graphical images
Date: Wed, 13 Jun 2007 13:58:22 -0700
Message-ID: <fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com> (raw)
In-Reply-To: <4670561B.8020301@postgresql.org>
References: <20070613115155.uykzmxtvxueoo4w8@imp3.uta.fi>
<466FB441.6000204@postgresql.org>
<20070613230611.mewiitg4mnco8kwo@imp3.uta.fi>
<4670561B.8020301@postgresql.org>
Using that, you could just point the src atribute of an img tag to that url,
<img src="http://www.jo-jos-jewellery.co.uk/system/showimage.php?id=<?php
echo $imgId ?>" />
OR present the data inline using the object tag (but that gets tricky fyi
and cane be kinda slow for all but the most trivial of images [hence why its
highly discouraged by the w3c]
<OBJECT id="necklace"
...
data="data:image/jpeg;base64, *...base64 data...*">
A Necklace
</OBJECT>
Again, I **highly** recommend the first method
Colin
http://www.w3.org/TR/html401/struct/objects.html#h-13.2
On 6/13/07, Dave Page <dpage@postgresql.org> wrote:
>
> Mihail Mihailov wrote:
> > Hi Dave and thanks for advice.
> >
> > You show in your example how to create an html file containing only one
> > picture.
> > How do you insert multiple graphical images into a "mixed" document
> > containing text and graphical images?
> > Do I still have to save bytea data into a temporary file (how?) and than
> > get in with <img> tag?
>
> No, I showed how to return an image in response to a http request using
> php, e.g:
> http://www.jo-jos-jewellery.co.uk/system/showimage.php?id=85495. No HTML
> or text was served at al. That URL (or variations thereof) can be used
> directly in an <img> tag as many times as you want in a single HTML
> document.
>
> Regards, Dave.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: colinross@gmail.com
Subject: Re: php, postgresql and graphical images
In-Reply-To: <fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com>
References: <20070613115155.uykzmxtvxueoo4w8@imp3.uta.fi> <466FB441.6000204@postgresql.org> <20070613230611.mewiitg4mnco8kwo@imp3.uta.fi> <4670561B.8020301@postgresql.org> <fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox