How do I display an image?

Fairly new to PHP. How do I display an image I have stored in my db? I
found code on phpbuilder.com, but I must be doing something wrong. If I
just print out the field, it prints the machine code immediately. But I
alas my users want an image instead of machine language.

CREATE TABLE mdc_imageref (
keyp_imageref int4,
modid int8,
img bytea,
keyf_image int4
)


$id = $_GET["id"];
if($id) {
$db = db_connect();
$result = pg_query($db,"Select ir.img,p.keyp_products
from mdc_products p join mdc_product_images pi on
p.keyp_products = pi.keyf_product
join mdc_attributes a on a.keyp_attribute =
pi.keyf_attribute
join mdc_images i on i.keyp_images = pi.keyf_image
join mdc_imageref ir on ir.keyf_image = i.keyp_images
where p.keyp_products = $id and keyp_attribute = 7");
$row = pg_fetch_array($result);
$type = "JPG";
Header( "Content-type:$type");
echo $row[0];
}


TIA
Patrick Hatcher
Macys.Com
Legacy Integration Developer




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: How do I display an image?

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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: How do I display an image?

that did it! Thank you very much

Patrick Hatcher
Macys.Com
Legacy Integration Developer






"Cornelia Boenigk"
, "Patrick Hatcher"
oenigk.de>
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







---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html