Re: html display images without intermediate file

From: Vincent <vinny(at)xs4all(dot)nl>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: html display images without intermediate file
Date: 2014-04-09 17:17:24
Message-ID: 534580A4.1060603@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

On 09-04-14 18:01, paul(at)mybofy(dot)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.

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Jeff Silberberg 2014-07-29 00:45:06 Looking for some assistance / guidance --
Previous Message paul 2014-04-09 16:01:16 html display images without intermediate file