Subject | Re[2]: [firebird-php] blob -> jpg |
---|---|
Author | Dmitry Kalugin |
Post date | 2005-03-30T07:10:28Z |
Hello, Lester!
----------------------------
<?php
if (isset($_GET["ID"])) {
header("Content-type: image/jpeg");
$pID=$_GET["ID"];
$psql="select FOTO from B_FOTOS where ID=".$pID;
require("user.and.pasword.inc.php");
//----------------1---------dont work---FROM php.net--------------
// $result = ibase_query($dbh,$psql);
// $data = ibase_fetch_object($result);
// $blob_data = ibase_blob_info($data->BLOB_VALUE);
// $blob_hndl = ibase_blob_open($data->BLOB_VALUE);
// echo ibase_blob_get($blob_hndl, $blob_data[0]);
// ibase_blob_close($blob_hndl);
//-------------- 2 -----------work-----Method Tika--(mymethod)----
$prs=ibase_query($psql);
$prow=ibase_fetch_row($prs);
ibase_blob_echo($prow[0]);
ibase_free_result($prs);
//-------------- 2 ---------------------------
ibase_close();
}
?>
ibase_fetch_object - is false function
--
Best regards,
Dmitry Kalugin
Ukraine, Donetsk
ICQ177363
>You need to get the information *IN* the BLOB rather than the BLOBWorking final result is
>handle itself.
----------------------------
<?php
if (isset($_GET["ID"])) {
header("Content-type: image/jpeg");
$pID=$_GET["ID"];
$psql="select FOTO from B_FOTOS where ID=".$pID;
require("user.and.pasword.inc.php");
//----------------1---------dont work---FROM php.net--------------
// $result = ibase_query($dbh,$psql);
// $data = ibase_fetch_object($result);
// $blob_data = ibase_blob_info($data->BLOB_VALUE);
// $blob_hndl = ibase_blob_open($data->BLOB_VALUE);
// echo ibase_blob_get($blob_hndl, $blob_data[0]);
// ibase_blob_close($blob_hndl);
//-------------- 2 -----------work-----Method Tika--(mymethod)----
$prs=ibase_query($psql);
$prow=ibase_fetch_row($prs);
ibase_blob_echo($prow[0]);
ibase_free_result($prs);
//-------------- 2 ---------------------------
ibase_close();
}
?>
ibase_fetch_object - is false function
--
Best regards,
Dmitry Kalugin
Ukraine, Donetsk
ICQ177363