Re: How do I display an image?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: "Cornelia Boenigk" <c(at)cornelia-boenigk(dot)de>
Cc: "PGSQL+PHP" <pgsql-php(at)postgresql(dot)org>
Subject: Re: How do I display an image?
Date: 2002-10-24 12:46:36
Message-ID: OF93F7AE09.B8EEB0CE-ON88256C5C.00462824@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php


that did it! Thank you very much

Patrick Hatcher
Macys.Com
Legacy Integration Developer


"Cornelia Boenigk"
<poppcorn(at)cornelia-b To: "PGSQL+PHP" <pgsql-php(at)postgresql(dot)org>, "Patrick Hatcher"
oenigk.de> <PHatcher(at)macys(dot)com>
cc:
10/23/2002 05:36 PM Subject: Re: [PHP] How do I display an image?
Please respond to
"Cornelia Boenigk"

Hi Patrick

Before storing the binary data in the BYTEA-Field use

pg_escape_bytea($imagedata)

After retrieving the imagedata from the table you must remove the slashes
the above function added. Use stripCslashes().

$image = stripcslashes($imagedata);

This works for me;-)
pg_escape_bytea() is available since php 4.2.0.

regards
Conni

Browse pgsql-php by date

  From Date Subject
Next Message Bruce Young 2002-10-26 17:22:27 can't retrieve data through PHP
Previous Message Andrew McMillan 2002-10-24 10:17:53 Re: Problems with OIDs