I am having trouble with the following function working _with_
sessions. If I turn off my session checking function it enables you to
download the file flawlessly, if sessions are turned on then Internet
Explorer displays an error that the file is not available. Is there a way
I can download large objects from postgresql _with_ sessions? Thankyou.
function retrieve_file($id) {
global $dbconn1;
$result1 = pg_exec ($dbconn1, "select data, file_name from files where
id='$id';");
$image_oid = pg_result($result1 ,0, 'data');
$file_name = pg_result($result1 ,0, 'file_name');
header ("Content-disposition: filename=\"$file_name\"");
header("Content-type: application/download");
pg_exec ($dbconn1, "begin transaction;");
$image_handle = pg_loopen ($dbconn1, $image_oid, 'r');
pg_loreadall ($image_handle); pg_loclose ($image_handle);
pg_exec ($dbconn1, "commit transaction;"); }
}
p.s. This has been posted on www.phpbuilder.com
