<?php  
  
     $type=array("jpg","gif","bmp","jpeg","png","rar");

     if(!in_array(substr($file_name,-3),$type))
      {
        $text=implode(",",$type);
        echo "<div align=center>
      <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
      <p>&nbsp;</p>抱歉!您只能上传以下类型文件: ",$text,"</p><div>";
echo "<a href=\"test.php\">返回重新递交</a>";
exit();
      }  
  else
  
   { $filepath="upload/".$name.substr($file_name,-4);
    
      if(file_exists($file))
            {    
                copy($file,$filepath);
           
          
              
            $handle=opendir("upload/");                   $conn = mysql_connect("localhost","media","media");
if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("yanyan",$conn);
                  $file_type=substr($file_name,-3);     
                  $user_name=$_POST['user'];
  $file_name=$_POST['name'];
  $file_content=$_POST['content'];
               while($file=readdir($handle)){
    if($file!="."and$file!=".."){
   if(filesize("upload/".$file)/1024>1000){$fs=round(filesize("file/".$file)/1024/1024,2)."MB";}
   else{$fs=round(filesize("upload/".$file)/1024,2)."KB";}
   $ft=date("Y-m-d H:i",filectime("upload/".$file));
   $file_date=$ft;
   $file_size=$fs;}        
                 
                  $sql="insert into file (user_name,file_name,file_type,file_content,file_size,file_date) values ('$user_name','$file_name','$file_type','$file_content','$file_size','$file_date')";     
                  if (!mysql_query($sql,$conn))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($conn);  
}echo "<a href= show.php>显示上传文件信息</a>"; 
            }
  else echo "请选择文件!";
 
?>