Interbase & BLOB
| From: | Enrico Comini | Date: | Wed, 18 Jul 2001 22:30:11 +0000 |
| Subject: | Interbase & BLOB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10564@lists.php.net to get a copy of this message | ||
This is my page to extract image (as blob) in a interbase table.
I call it with :echo "src=\"blob2img.php?id_product=".$id_product."\"
";
but i don't see the image
<?php
//BLOB2JPG
// in = id_product
$host = "10.10.0.200:/home/interbase/WEB02/WEBG02";
$user = "TEST_USER";
$pass = "PassUser";
$charset="";
$buffers=100000;
$dialect="3";
$rules = "CLIENT";
$conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules)
$set = ibase_query("SELECT IMAGE from products where (id_product =
$id_product)");
$row = ibase_fetch_row($set);
ibase_blob_echo($row[0]);
header("Content-type: image/jpeg");
ibase_close($conn);
?>