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;"); }
}