postgres+php实现下载问题

Question

下面是我以前写的代码，不知道是否用的上：
$conn=pg_pconnect("dbname=deputynet user=postgres password=postgres port=5432");
if (!$conn) {echo " An database connection error occurred.\n";exit;}
$result3=pg_exec($conn,"select lo_export(paper1.context,'/tmp/随便起个文件名) from paper1 where paper1.context='$file'");
$result4=pg_exec($conn,"update paper1 set num_downloaded=num_downloaded+1 where paper1.context='$file' ");if (!$result3) {echo "An download query error occurred.\n"; exit;}
pg_close($conn);
pg_freeresult($result3);
pg_freeresult($result4);
?>
<a href=down.php?file=<? echo $file1;?>>点击下载</a>down.php:
<?
function download()
{      $file =$_GET['file'];
//echo $file;
$filename='/tmp/'.$file;
//echo $filename;
       //echo filesize($filename);
$fp = fopen($filename,"r"); 
       //echo filesize($filename);
 
     Header("Content-type: application/octet-stream");
Header("Accept-Ranges: bytes");       Header("Accept-Length: filesize($filename)");
         

Header("Content-Disposition: attachment; filename=" . $file);       echo fread($fp,filesize($filename)); 
       fclose($fp);
 $new=unlink("filename");
 if (!$new)
    echo "删除失败";
  
}
download();
?>

Answer 1

居然真有高手，让人惊奇，多谢了！老兄！