note 10168 deleted from function.ocibindbyname by sixd
| From: | sixd@php.net | Date: | Wed, 20 Nov 2013 19:47:16 +0000 |
| Subject: | note 10168 deleted from function.ocibindbyname by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-197584@lists.php.net to get a copy of this message | ||
Note Submitter: gmarcos at netspace dot com dot mx
----
to load an image from oracle:
<?
Header("Content-Type: image/png");
$conn = OCILogon("user","passwd","bd");
$stmt = OCIParse($conn,"select picture
from table_with_picture ");
$picture = OCINewDescriptor($stmt,OCI_D_LOB);
OCIDefineByName($stmt,"PICTURE",&$picture);
OCIExecute($stmt);
while(OCIFetch($stmt)){
}
OCIFreeStatement($stmt);
$fp = fopen ("/directory/picture.tif","wb");
fwrite($fp,$picture);
fclose($fp);
passthru("/usr/bin/X11/convert /directory/picture.tif png:-");
?>
This work for blobs.