Re: php, postgresql and graphical images - Mailing list pgsql-php

From Colin Ross
Subject Re: php, postgresql and graphical images
Date
Msg-id fd3e08f30706131358j13979710w5d74378ac98c9b0a@mail.gmail.com
Whole thread Raw
In response to Re: php, postgresql and graphical images  (Dave Page <dpage@postgresql.org>)
Responses Re: php, postgresql and graphical images  (Mihail Mihailov <Mihail.Mihailov@uta.fi>)
List pgsql-php
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

pgsql-php by date:

Previous
From: Dave Page
Date:
Subject: Re: php, postgresql and graphical images
Next
From: Mihail Mihailov
Date:
Subject: Re: php, postgresql and graphical images