Subject AW: [firebird-php] Show a Jpg stored as Binary blob in a firebird table with PHP
Author Gerhard Knapp
>$sst = "SELECT image, image_type FROM images_tbl WHERE images_id='123'' ";
>$result = ibase_query($sst, $f);
>if(empty($result)) echo SQL_error($f,$sst)."<BR>";
>$tmprow=SQL_fetch_object($result,0);

you mean ibase_fetch_object ??

>$image = $tmprow->image;
>header("Content-type: ".$tmprow->image_type);

i have no imagetype stored in db, what is the value for image_type? "JPG"
p.e.?

>headers_sent();
here comes the error, headers was sent before, sorry -..
ibase_blob_echo($image);


id doesn't work ...
have an working example???

thank you
best regards
-Gerhard



-----Ursprungliche Nachricht-----
Von: Almond [mailto:almond@...]
Gesendet: Mittwoch, 25. Juni 2003 04:27
An: firebird-php@yahoogroups.com
Betreff: Re: [firebird-php] Show a Jpg stored as Binary blob in a firebird
table with PHP


At 19:34 03/06/24 +0000, you wrote:
>Hello,
>can someone help me?
>I try to make a webpage (PHP4, Firebird 1.5 b3, Apace WEbserver)
>and have the following problem:
>show pictures that was stored in a table as binary blob
>...,
>GID integer not null,
>GRUND_FOTO BLOB SUB_TYPE 0 SEGMENT SIZE 80,
>...
>echo row->grund_foto didn't work, smile ...
>thanks
>-Gerhard






Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.