I have a picture in a blob field and as well as primary key called id.
And ihave created a page that have the following tag:
<IMG SRC="getblob.php?id=$id">
The content of getblob.php:
<?php
require("sid.inc");
$conn = jaltLogon(); //login to my oracle 8i database
$sql = OCIParse($conn,"select photo from testBLOB where id=".$id);
OCIExecute($sql, OCI_DEFAULT);
OCIFetchInto($sql, $row, OCI_RETURN_LOBS);
$lob_data = $row->load();
print $lob_data;
OCIFreeStatement($sql);
OCILogoff($conn);
?>
However, the page cannot display the blob field...
Any suggestion?
Thanks You...