AndroidDownloadAction.php

<?php
	//连接数据库
	require_once 'connect.php';
	//获取用户输入的文件提取码
	$downloadnumber = $_POST['DownLoadNumber'];
	//echo $downloadnumber;
	
	if(!$downloadnumber){
		echo "This_downloadnumber_is_null";// 没有输入文件提取码！
		exit();
	}else{
		//在数据库中根据输入的提取码查找数据
		$sql1 = "select * from fileinfo where downloadnumber = $downloadnumber";
		//将查找到的那一行赋值给$query作为资源标识符
		$query1 = @mysql_query($sql1);
		//echo $query;
		//获取资源标识符$query所指向的对象，也就是所要查找的这一行
		$arr1 = @mysql_fetch_object($query1);//
		//如果没有查找到对应的对象，则说明数据库中没有这条数据，$downloadnumber不存在于系统fileinfo数据表里面
		if($arr1 == NULL){
			echo "This_downloadnumber_is_not_valid";// 此文件提取码无效！
			exit();
		}
		//从$arr对象中获取path的值，并将其赋值给$downloadpath
		//$downloadpath = $arr1 -> path;
	
		//echo $downloadpath;
		//echo "<script>alert('$downloadpath');window.location.href='index.php'</script>";
	
	
		/********************以下是将下载相关的记录写入数据库filedownloadrecords********************/
		//获取下载的时间
		$date_tmp = time();//获取Linux时间戳
		$dateline2 = date("Y-m-d H:i:s", $date_tmp+8*60*60);//将时间戳转换为标准时间
	
		$name2 = $arr1 -> name;
		$path2 = $arr1 -> path;
		$md5name2 = $arr1 -> md5name;
		$type2 = $arr1 -> type;
		$size2 = $arr1 -> size;
		$downloadnumber2 = $arr1 -> downloadnumber;
	
		//下载者的IP
		$requestIP = $_SERVER["REMOTE_ADDR"];
	
		//echo $requestIP;
	
	
		//在用户下载数据库里面重找是否有下载的记录
		//$downloadtimes = 0;
	
		$sql2 = "select * from filedownloadrecords where downloadnumber = $downloadnumber";
	
		$query2 = mysql_query($sql2);
	
		$arr2 = mysql_fetch_object($query2);
	
		/**如果下载记录表中没有这条记录，那么久插入这条记录*/
		//	if ($arr2 == NULL){
	
		$downloadtimes=1;
	
		$insertsql = "insert into filedownloadrecords(name,path,md5name,type,size,downloadnumber,requestIP,downloadtimes,dateline) values ('$name2','$path2','$md5name2','$type2','$size2','$downloadnumber2','$requestIP','$downloadtimes','$dateline2')";
		//echo $insertsql;
		mysql_query($insertsql);
	
	
	
		/**如果有这条记录就判断是否为同一IP，如果是就增加下载次数，如果不是就重新插入一条数据*/
		// 	}else
			// 	{
	
		// 		if ($requestIP == $arr2 -> requestIP){
		// 		//获取下载记录表中存储的下载次数的数据downloadtimes
	
		// 		$downloadtimes = $arr2 -> downloadtimes + 1;
	
		// 		$sql3 = "update filedownloadrecords set downloadtimes = $downloadtimes where downloadnumber = $downloadnumber";
	
		// 		mysql_query($sql3);
		// 		}else {
		// 			/**不是同一条IP，那个就需要再插入一条数据*/
		// 			$downloadtimes=1;
			
		// 			$insertsql2 = "insert into filedownloadrecords(name,path,md5name,type,size,downloadnumber,requestIP,downloadtimes,dateline) values ('$name2','$path2','$md5name2','$type2','$size2','$downloadnumber2','$requestIP','$downloadtimes','$dateline2')";;
		// 			//echo $insertsql2;
		// 			mysql_query($insertsql2);
			
		// 		}
	
		// 	}
	
	
		/***********强制让用户下载文件的代码，用Header实现************/
		/* $file_dir = 'FilesUpload/';
		$file_name = $arr1 -> md5name;
	
		$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(); */
		//返回文件路径，然后在安卓端下载此文件
		echo("$path2");
		
	
		//echo "<script>window.location.href='$downloadpath';window.location.href='index.php'</script>";
	}