ociloadlob

(PHP 4, PHP 5)

ociloadlob -- OCI-Lob->load 的别名

说明

本函数是该函数的别名:OCI-Lob->load


add a note add a note User Contributed Notes
FaLL3N at mail dot ru
25-Oct-2006 09:34
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!