Oracle retrieving jpg from blob into memory

From: Date: Thu, 03 Aug 2000 15:55:52 +0000
Subject: Oracle retrieving jpg from blob into memory
Groups: php.db 
Request: Send a blank email to php-db+get-1758@lists.php.net to get a copy of this message
Hello, I have this piece of code that pulls in and displays a blob in text format: $stmt = ociparse($connection,"select * from table"); ociexecute ($stmt,OCI_DEFAULT); while (ocifetchinto($stmt,&$arr,OCI_RETURN_LOBS)) { var_dump($arr); } What I've been trying to do is pull out a jpg that exists as a blob in a table, and properly display it in a web page. I've seen and used scripts that would take a blob, write it to a file (picture.jpg) and then refer to it in the html script. But I've seen perl scripts pull in a blob to memory and output it to the web page WITHOUT writing to the file system. Thanks in advance -- Paul Fernandez Webmaster Structural GenomiX, Inc.

« previous php.db (#1758) next »