header("Content-type: text/html; charset=utf-8");// 创建数据库连接$con = mysql_connect('localhost', 'root', 'root') or die('Could not connect: ' . mysql_error());//echo 'Connected successfully';$db=mysql_select_db('download',$con);if (!$db){ die ("Can\'t use download : " . mysql_error());}else{ // 将用户信息插入数据库的user表 $sql = "SELECT * FROM `f_detail` WHERE `id` ='".$_GET['id']."' LIMIT 0 , 30"; $result = mysql_query($sql,$con); $row=mysql_fetch_row($result); if (!$result) { // 释放结果集 mysql_free_result($result); // 关闭连接 mysql_close($db); echo '数据记录插入失败!'; exit; } }//下载文件名//$file_name = "xxx.rar";$file_name = $row[1]; //var_dump($file_name);//下载文件存放目录$file_dir = "up/"; //检查文件是否存在if (!file_exists($file_dir . $file_name)) { echo "文件找不到"; exit; }else { // 打开文件 $file = fopen($file_dir . $file_name,"r"); // 输入文件标签 Header("Content-type: application/octet-stream"); Header("Accept-Ranges: bytes"); Header("Accept-Length: ".filesize($file_dir . $file_name)); Header("Content-Disposition: attachment; filename=" . $file_name); // 输出文件内容 //读取文件内容并直接输出到浏览器 echo fread($file,filesize($file_dir . $file_name)); fclose($file); exit;}
数据库
CREATE TABLE `f_detail` ( `id` int(11) NOT NULL auto_increment, `filename` varchar(100) NOT NULL, `des` varchar(64) NOT NULL, `fsize` varchar(10) NOT NULL, `ftype` varchar(100) NOT NULL, `utime` datetime NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;