基本的文件上传下载功能

基本的文件上传下载功能,早期源码，供参考

 

基本的文件上传下载功能

包含三个文件，create_table.php创建数据表，upload.php文件上传，download.php文件下载。

代码如下：

create_table.php：

<?php
$con=mysql_connect(“localhost”,”root”,”123456″) or die(“无法连接数据库”.mysql_error());
mysql_select_db(“test”,$con)  or die(“无法选择数据库”.mysql_error());

$create_table_sql=”create table `download`(fileid int(11) NOT NULL primary key auto_increment, filename varchar(50) NOT NULL, filesize int(11) default ’0′, uploadtime datetime NOT NULL,  location varchar(100) NOT NULL)”;

$result=mysql_query($create_table_sql,$con)or die(“不成功，原因为”.mysql_error());

echo “创建表成功”;
mysql_close($con);
?>

 

upload.php：

<?php
$con=mysql_connect(“localhost”,”root”,”123456″) or die(mysql_error());
mysql_select_db(“test”,$con) or die(mysql_error());
$basedir=”upload”;

if($_POST["submit"])
{
if($_FILES["file"]["error"]==0)
{
if(!is_dir($basedir))
{
mkdir($basedir);
}

$newfilename=$basedir.”/”.iconv(‘utf-8′,’gb2312′,$_FILES["file"]["name"]);
if(move_uploaded_file($_FILES["file"]["tmp_name"],$newfilename))
{
$filename=$_FILES["file"]["name"];
$filesize=$_FILES["file"]["size"];
$now=date(“Y-m-d H:i:s”);
$sql=”insert into download(filename,filesize,uploadtime,location)values(‘$filename’,'$filesize’,'$now’,'$newfilename’)”;
mysql_query($sql,$con) or die(mysql_error());
}
}
else
{
echo “<script language=’javascript’>alert(‘上传错误’)</script>”;

}
}
mysql_close($con);
?>
<form method=”POST” enctype=”multipart/form-data” action=”" name=”uploadform”>
<label>
请选择要上传的文件:<br>
</label>
<input type=”file” name=”file”>
<input type=”submit” name=”submit” value=”提交文件”>
</form>
<?php
$con=mysql_connect(“localhost”,”root”,”123456″)or die(mysql_error());
mysql_select_db(“test”,$con)or die(mysql_error());
$sql=”select * from download”;
$result=mysql_query($sql);
while($array=mysql_fetch_array($result))
{
?>
<table border=’1′>
<tr>
<td>文件编号</td>
<td>文件名字</td>
<td>上传日期</td>
<td>文件大小</td>
<td>下载</td>
</tr>
<tr>
<td><?php echo $array["fileid"];?>
<td><?php echo $array["filename"];?>
<td><?php echo $array["uploadtime"];?>
<td><?php echo $array["filesize"];?>
<td>
<a href=”download.php?id=<?php echo $array["fileid"];?>”>下载</a>
</td>
</tr>
<?php
}
?>

 

download.php：

<?php
$filename=”";
if(isset($_GET["id"])&&is_numeric($_GET["id"]))
{
$con=mysql_connect(“localhost”,”root”,”123456″) or die(mysql_error());
mysql_select_db(“test”,$con) or die(mysql_error());
$sql=”select location from download where fileid=”.$_GET["id"];
$result=mysql_query($sql,$con);

if($array=mysql_fetch_array($result))
{
$location=$array["location"];

if(file_exists($location))
{
$filename=pathinfo($location);
$filename=$filename["basename"];

Header(‘Content-type: application/octet-stream’);
header(“accept-length:”.filesize($location));
header(“content-disposition:attachment;filename=”.$filename);
header(“Accept-Ranges: bytes”);

$file=fopen($location,”r”);
readfile($location);
fclose($file);
}
}
}
mysql_close($con);
?>