pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>

view thread (6+ messages)  latest in thread

Message-ID: <fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com>
Permalink:  ../fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com/
Also on:    postgresql.org/message-id/fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com

 · 

reply

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