ociloadlob

(PHP 4, PHP 5, PECL OCI8 >= 1.0.0)

ociloadlob — Alias of OCI-Lob::load()

Description

Warning

This alias has been DEPRECATED as of PHP 5.4.0. Relying on this alias is highly discouraged.

add a note User Contributed Notes ociloadlob

FaLL3N at mail dot ru 26-Dec-2006 12:19


Ps. To prevent IE errors like 'File not found!' after downloading file from db I recommend to add next two lines into header:

header('Cache-Control: max-age=0');

header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");



With this, IE will open any file normally :)

FaLL3N at mail dot ru 25-Oct-2006 11:04


I'll give you example how to download a file from db without storing it on server's FS:

It works like this - point yor browser to index.php?name=file.ext

Just make sure that file "file.ext" exists in your db!



Code:



<?php



 $dbConnection=ocilogon('user','pass','data.world'); //login stuff

 $sql_SelectBlob='select document_body,filename from tdocuments where id=1'; //selecting a blob field named 'document_body' with id = 1

 $statement=OCIParse($dbConnection,$sql_SelectBlob);



 OCIExecute($statement) or die($sql_SelectBlob.'<hr>');



if(OCIFetch($statement)) //if file exists

 {

 $a=OCIResult($statement,"DOCUMENT_BODY");

 }

header('Content-type: application/octet-stream;');

header('Content-disposition: attachment;filename='.$_GET['name']);



print $a->load();

//browser promts to save or open the file

?>



Have fun!

add a note