Create Account
Sign In

View display image BLOB with PHP/ORACLE!

To create and answer topics, you must to be logged.
Pages: 1
Author Message
23/12/2014 at 16:06:25
I using..

$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?

Pages: 1