是这样,我想通过数据库实现文件上传和下载,是在lamp下。
上传到数据库已经成功了,下载页我是通过单选框把已经上传的内容显示出来(编号和文件名),上传的文件被存放到了/tmp/文件夹下,文件名与我上传时的名称一致。在下载页点击下载后出来的是空白,没有想要的结果,大神帮我看下,代码如下。(下载页的代码略去)
xz_ppt.php:
<?php
header("Content-type:text/html; charset=utf-8");
include "downFile.inc.php";
include "conn.php";
if(empty($_GET['id'])){
return;
}
$id = $_GET['id'];
$sql = "select * from downfile where id=$id;";
$res1 = mysql_query($sql,$con) or die(mysql_error());
$record = mysql_num_rows($res1);
if($record==0){
echo "<script type='text/javascript'> alert('对不起!该文件不存在或已被删除!'); </script>";
return;
}
$row = mysql_fetch_array($con);
$filename = $row['filename'];
mysql_free_result($con);
downFile($filename);
$sql = "update downfile set downcount=downcount+1 where id=$id;";
mysql_query($sql,$con) or die(mysql_error());
?>
downFile.inc.php:
<?php
function downFile($file_name){
$file_path = "/tmp/".$file_name;
$buffer = 102400; //一次返回102400个字节
if(!file_exists($file_path)){
echo "<script type='text/javascript'> alert('对不起!该文件不存在或已被删除!'); </script>";
return;
}
//若文件存在,则打开文件
$fp = fopen($file_path,"r");
//获取下载文件的大小
$file_size = filesize($file_path);
//返回的文件
header("Content-type:application/octet-stream");
//按照字节大小返回
header("Accept-Ranges:bytes");
//返回文件大小
header("Accept-Length:$file_size");
header("Content-Disposition:attachment; filename=$file_name");
while(!feof($fp)){
$file_data = fread($fp,$buffer);
echo $file_data;
}
fclose($fp);
}
?>
上传到数据库已经成功了,下载页我是通过单选框把已经上传的内容显示出来(编号和文件名),上传的文件被存放到了/tmp/文件夹下,文件名与我上传时的名称一致。在下载页点击下载后出来的是空白,没有想要的结果,大神帮我看下,代码如下。(下载页的代码略去)
xz_ppt.php:
<?php
header("Content-type:text/html; charset=utf-8");
include "downFile.inc.php";
include "conn.php";
if(empty($_GET['id'])){
return;
}
$id = $_GET['id'];
$sql = "select * from downfile where id=$id;";
$res1 = mysql_query($sql,$con) or die(mysql_error());
$record = mysql_num_rows($res1);
if($record==0){
echo "<script type='text/javascript'> alert('对不起!该文件不存在或已被删除!'); </script>";
return;
}
$row = mysql_fetch_array($con);
$filename = $row['filename'];
mysql_free_result($con);
downFile($filename);
$sql = "update downfile set downcount=downcount+1 where id=$id;";
mysql_query($sql,$con) or die(mysql_error());
?>
downFile.inc.php:
<?php
function downFile($file_name){
$file_path = "/tmp/".$file_name;
$buffer = 102400; //一次返回102400个字节
if(!file_exists($file_path)){
echo "<script type='text/javascript'> alert('对不起!该文件不存在或已被删除!'); </script>";
return;
}
//若文件存在,则打开文件
$fp = fopen($file_path,"r");
//获取下载文件的大小
$file_size = filesize($file_path);
//返回的文件
header("Content-type:application/octet-stream");
//按照字节大小返回
header("Accept-Ranges:bytes");
//返回文件大小
header("Accept-Length:$file_size");
header("Content-Disposition:attachment; filename=$file_name");
while(!feof($fp)){
$file_data = fread($fp,$buffer);
echo $file_data;
}
fclose($fp);
}
?>