#33196 [Opn->Bgs]: cannot display JPEG from oracle db using oci8
| From: | pajoye@php.net | Date: | Tue, 31 May 2005 05:17:23 +0000 |
| Subject: | #33196 [Opn->Bgs]: cannot display JPEG from oracle db using oci8 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-79740@lists.php.net to get a copy of this message | ||
ID: 33196
Updated by: pajoye@php.net
Reported By: tommy dot yan at hp dot com
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: windows2000
PHP Version: 4.3.9
New Comment:
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
Do not print out any chararter while trying to display an image.
Previous Comments:
------------------------------------------------------------------------
[2005-05-31 05:27:33] tommy dot yan at hp dot com
Description:
------------
cannot display the picture uploaded, only a 'cross' sign displayed.
I use apache 2.0.54, php 4.3.6, win2k, oracle 10g, ado 4.11.
Reproduce code:
---------------
mainly part is here:
<?php
$db = myconnect();
$rs=$db->Execute("SELECT BLOBDATA FROM BTAB WHERE BLOBID =".$id);
print "id=".$id;
header("Content-type: image/JPEG");
$row = $rs->FetchRow();
print $row[0];
?>
PLEASE SEE
http://forums.oracle.com/forums/thread.jsp?forum=178&thread=233174&message=664237#664237
BOTTOM MESSAGE.
Expected result:
----------------
jpeg display normally
Actual result:
--------------
a 'cross sign' is displayed. if SQL debugging is enabled, a lot of
wrong character is displayed.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33196&edit=1