Download File From Server Folder

obrienkev

Hi all,

I want to download files from a server folder. At the moment nothing happens when I click the download link.

Why is this? Thanks.

if(!empty($_GET))
{
		// Connect to database
    include('../../../db_connect.php');

	// declare variables 
$id = $_GET['id'];

$query   = "SELECT name ".
					 	 "FROM centralised_archive.excel "./*********************/
						 "WHERE id = '$id'";				       /**** FIX HERE - TABLE SELECTION !!!!! */
	$result  = mysql_query($query) or die(mysql_error());
	$num_results = mysql_num_rows($result);
//echo $query;
    if ($num_results > 0)
		{
		 	 list($name) = mysql_fetch_array($result);

		 // filepath
		 $uploaddir = '../../uploads/excel/';
		 $uploadfile = $uploaddir . basename($name);

	// Set Headers
   if(isset($_SERVER['HTTP_USER_AGENT']) && preg_match("/MSIE/", $_SERVER['HTTP_USER_AGENT'])) 
	 {
       // IE Bug in download name workaround
       ini_set( 'zlib.output_compression','Off' );
   }    

   header('Content-type: application/excel');
	 header('Content-length: '. $size);
   header("Pragma: public");
   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
   header('Content-Disposition: attachment; filename="' . $name . '"');
   print($content);

   exit;
	 } // end if ($num_results)

} // end if(!$empty)

Weedpacket

Where does $content come from?

(Oh, and you might want to check that $_GET['id'] has a legitimate value before sticking anything like it into a database query.)

obrienkev

Hi,

I'm trying to amend a script I had for downloading files from a database.

How do I change it to download files from folder?

I think it's to do with the headers...

   header('Content-type: ' . $type);
   header('Content-length: '. $size);
   header("Pragma: public");
   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
   header('Content-Disposition: attachment; filename="' . $name . '"');
   readfile($uploadfile);

$type and $size are not set in the code. What should I change these to?

obrienkev

OK. Here's my entire download code. Any ideas how I can work this out?

if(!empty($_GET))
{
		// Connect to database
    include('../../../db_connect.php');

	// declare variables 
$id = $_GET['id'];

$query   = "SELECT name ".
					 	 "FROM centralised_archive.excel ".
						 "WHERE id = '$id'";				
	$result  = mysql_query($query) or die(mysql_error());
	$num_results = mysql_num_rows($result);

if ($num_results > 0)
	{
	 	 list($name, $type, $size) = mysql_fetch_array($result);

		 // filepath
		 $uploaddir = '../../uploads/excel/';
		 $uploadfile = $uploaddir . basename($name);

	// Set Headers
   if(isset($_SERVER['HTTP_USER_AGENT']) && preg_match("/MSIE/", $_SERVER['HTTP_USER_AGENT'])) 
	 {
       // IE Bug in download name workaround
       ini_set( 'zlib.output_compression','Off' );
   }    

   header('Content-type: ');
	 header('Content-length: '. $size);
   header("Pragma: public");
   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
   header('Content-Disposition: attachment; filename="' . $name . '"');
   readfile($uploadfile);

   exit;
	 } // end if ($num_results)

} // end if(!$empty)

Thanks.

Kevin.

Weedpacket

Well; most obvious thing is - if you want to fetch the name, type and size from the database you have to select more thanjust the name. You have to fetch the type and size as well.