Re: html display images without intermediate file - Mailing list pgsql-php

From Vincent
Subject Re: html display images without intermediate file
Date
Msg-id 534580A4.1060603@xs4all.nl
Whole thread Raw
In response to html display images without intermediate file  (paul@mybofy.net)
List pgsql-php
On 09-04-14 18:01, paul@mybofy.net wrote:

Bonjour
code working :
$link = pg_Connect("host=localhost dbname=... user=... password='...'");
$res = pg_query($link, "select miniature  from photo ");
$numrows = pg_numrows($res);
for($ri = 0; $ri < $numrows; $ri++) {
$row = pg_fetch_array($res, $ri);
$img =  pg_unescape_bytea($row['miniature']);
$fln = "toto".$ri.".jpeg";
file_put_contents($fln, $img);
echo "<img src='".$fln."'/>";
}
How to do without the  intermediate file $fln ?
Merci
The src in the img tag should point to a script that fetches the image, see header() in the PHP manual.

But you probably should not do that, because it is very slow and loads the database up with tasks that it should not do.
Keep images as files on disk, that is *much* faster.

pgsql-php by date:

Previous
From: paul@mybofy.net
Date:
Subject: html display images without intermediate file
Next
From: Jeff Silberberg
Date:
Subject: Looking for some assistance / guidance --