From: tommy dot yan at hp dot com Operating system: windows2000 PHP version: 4.3.9 PHP Bug Type: OCI8 related Bug description: cannot display JPEG from oracle db using oci8
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 bug report at http://bugs.php.net/?id=33196&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33196&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33196&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33196&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33196&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33196&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33196&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33196&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33196&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33196&r=support Expected behavior: http://bugs.php.net/fix.php?id=33196&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33196&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33196&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33196&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33196&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33196&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33196&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33196&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33196&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33196&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33196&r=mysqlcfg