This topic is locked

Display an image stored in oracle

12/12/2007 1:51:18 AM
PHPRunner General questions
Z
zak2000 author

Hi,
I'm trying to display an image stored in oracle 10using PHPRunner 4.1. First time image displayed like encode of symbols ($%#212) I tried to use the image feature and display it as thumbnail that didn't work either. I read that to display image stored in oracle as LONG RAW a header should be called.
So here is the portion of code to do so:

$value="";

$value = $data["IMAGE"];

header("Content-type: image/JPEG");

$row[$col."IMAGE_value"]=$value;


But it didn't work. So I tried also this

$value="";

header("Content-type: image/JPEG");

echo $row[$col."IMAGE_value"]


And it didn't work.
It just display weired code as if the image is opened using notepad.
I'm totally new to this. Can you please help me? Guide me? To away to display/store/upload & store an image in oracle using PHPRunner?
Thank you,

Alexey admin 12/13/2007

Zak,
LONG RAW type is deprected in Oracle 10

You should use BLOB type instead.
Choose Image view type for BLOB field and you'll see it displayed on the page.
If you can not change field type to BLOB send your table structure to support@xlinesoft.com and I'll help you to get this working.