Page 1 of 1

View display image BLOB with PHP/ORACLE!

Posted: Tue Dec 23, 2014 9:36 am
by elyssonraphael
I using..

Code: Select all

$consulta = oci_parse($conexao,"select photo from userp where usrph_status = 'A' and id = :didbv");
$didbv = $_POST["id"];
 
oci_bind_by_name($consulta, ':didbv', $didbv);
oci_execute($consulta, OCI_NO_AUTO_COMMIT);
while (($row = oci_fetch_array($consulta, OCI_ASSOC)) != false) {
 
$arr = oci_fetch_assoc($consulta);
header("Content-type: image/JPEG");
$result = $arr['PHOTO']->load();
 
print "<img src='".$arr['PHOTO']."'>";
print $result;
echo $result;
 
}


What appears in the result page is:

This image contains errors and can not be displayed.

How to fix this?

Re: View display image BLOB with PHP/ORACLE!

Posted: Tue Dec 23, 2014 1:41 pm
by requinix
If you're outputting an image then don't put any HTML in it. If the PHOTO is a file then you have to dump the contents of the file (like with readfile) and if it's raw image data, which is the case here, then you simply output it.