我如何下载一个文件使用PHP和Mysql数据库 - How do I download a file using PHP and Mysql DB

How do I download a file using PHP and Mysql DB

我是新手，我真的很纠结如何下载我在本地服务器上上传的文件。

我上传的脚本是-

require_once ('dbcon.php');
if(isset($_POST['log'])){
foreach($_FILES['files']['tmp_name'] as $key => $name_tmp){
        $file = $_FILES['files']['name'][$key];
        $tmpnm = $_FILES['files']['tmp_name'][$key];
        $type = $_FILES['files']['type'][$key];
        $size = $_FILES['files']['size'][$key];
        $dir = "file/".$file;
        $move = move_uploaded_file($tmpnm, $dir);
if ($move){             
            $query = ("INSERT into dfile VALUES(null,'$file','$type','$size')");
            $result = $dbLink->query($query);
            if($result){
                echo "<h4>Upload Complete</h4></br>";
            }else{
                echo "Error Table DB";
            }
        }
 }
}

SomePage.php

<a href="download.php?FileNo=<?echo $FileNo;?>">File Name</a>

download.php

$FileNo=$_GET['FileNO'];
//Use Mysql Query to find the 'full path' of file using $FileNo.
// I Assume $FilePaths as 'Full File Path'.
download_file($FilePaths);
function download_file( $fullPath )
{
  if( headers_sent() )
    die('Headers Sent');

  if(ini_get('zlib.output_compression'))
    ini_set('zlib.output_compression', 'Off');

  if( file_exists($fullPath) )
  {
    $fsize = filesize($fullPath);
    $path_parts = pathinfo($fullPath);
    $ext = strtolower($path_parts["extension"]);
    switch ($ext) 
    {
      case "pdf": $ctype="application/pdf"; break;
      case "exe": $ctype="application/octet-stream"; break;
      case "zip": $ctype="application/zip"; break;
      case "doc": $ctype="application/msword"; break;
      case "xls": $ctype="application/vnd.ms-excel"; break;
      case "ppt": $ctype="application/vnd.ms-powerpoint"; break;
      case "gif": $ctype="image/gif"; break;
      case "png": $ctype="image/png"; break;
      case "jpeg":
      case "jpg": $ctype="image/jpg"; break;
      default: $ctype="application/force-download";
    }
    header("Pragma: public"); 
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Cache-Control: private",false); 
    header("Content-Type: $ctype");
    header("Content-Disposition: attachment; filename='"".basename($fullPath)."'";" );
    header("Content-Transfer-Encoding: binary");
    header("Content-Length: ".$fsize);
    ob_clean();
    flush();
    readfile( $fullPath );
  } 
  else
    die('File Not Found');
}

路径取决于脚本的结构，但基本上是这样的:

while($row = $result->fetch_assoc()) { 
  echo " <tr> 
  <td>{$row['comp']}</td> 
  <td>{$row['expire']}</td> 
  <td>{$row['file']}</td> 
  <td>{$row['size']}</td>
  <td>
    <a download href='"file/{$row['file']}'">Download this file</a>
  </td>
  </tr>";
}

您可以通过设置headers:

<?php
$file = $_GET['file'];
$dir = '';
if(isset($_GET['file']) && file_exists($dir . $file)) {
    $finfo = new finfo(FILEINFO_MIME_TYPE);
    $type = $finfo->file($file); // get MIME-Type
    header("Content-Type: " . $type);
    header("Content-Disposition: attachment; filename='"" . $file . "'"");
    readfile($dir . $file);
}

确保Content-Type是MIME-Type。你可以把这段代码放在一个单独的文件dl.php中，然后在视图中这样调用它:

<a href="dl.php?file=path/to/your/file.txt">Download</a>