PHP - Download File From Db Not Working

To give some background, I'm currently working on a private site that allows members access to large document files via a torrent system.

Now, this is the PHP code I have:
Code: [Select]
$id = $_REQUEST['id'];

if (!$id)
httperr();

$res = mysql_query("SELECT name FROM torrents WHERE id = $id") or sqlerr(__FILE__, __LINE__);
$row = mysql_fetch_assoc($res);

$fn = "$torrent_dir/$id.torrent";
if (!$row || !is_file($fn) || !is_readable($fn))
httperr();

$fs = filesize($fn);
$tor_fname = $row["filename"];

mysql_query("UPDATE torrents SET hits = hits + 1 WHERE id = $id");

require_once "include/benc.php";  // Torrent Encoding Functions

$dict = bdec_file($fn, (1024*1024));
$dict['value']['announce']['value'] = "$DEFAULTBASEURL/announce.php?passkey=$CURUSER[passkey]";
$dict['value']['announce']['string'] = strlen($dict['value']['announce']['value']).":".$dict['value']['announce']['value'];
$dict['value']['announce']['strlen'] = strlen($dict['value']['announce']['string']);

    header("Content-Type: application/x-bittorrent");
    header("Content-Disposition: attachment; filename=\"" . basename($tor_fname) . "\"" );
    print(benc($dict));

This is taken from (and is the majority of) the file download.php.  This is called like: download.php?id=??

The above should work, but when I use it, it tries to save the file as download.torrent, even though the $tor_fname variable doesn't contain that value.  I'd obviously like to force the filename to be '<filename>.torrent' rather than the same name as the php script with .torrent on the end.

Any ideas?  Am I doing something stupid, or is there some way of doing this?

I am generating a snapshot of some data and giving the users the ability to download that snapshot.  I am trying to serve that file to the users and it works great in Firefox, but the IE users just get a blank file.  I'm using the following:

<?php
header('Cache-Control: no-cache, no-store, max-age=0, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Pragma: no-cache');
header('Content-Type: text/plain; charset=ISO-8859-1'); // plain text file
$filename = 'C:\WINDOWS\Temp\snapshot.txt';
header("Content-Disposition: attachment; filename=\"".$filename."\";" );
header("Content-Length: ".filesize($filename));
readfile("$filename");
?>

I've changed multiple items several times and each works in FF, but none work in IE.  Is anyone aware of any IE specific headers that need to be sent?  It's just a plain text file, nothing fancy.

The other day I noticed someone had post something like this, well this was actually the solution to the problem. But it got me thinking about a project of mine that I am working on and the need to pump out a downloadable file. We are storing most of the files in a database using base64 encoding the 2 key types of files we are storing are images and PDF's mostly pdf's anyway where I am wanting to go with this is, is there anyway to take the base64 encoded file and get it to download through this, or am I tackling the idea in the wrong way?

<?php
$filename = 'somename.txt'; //this would obviously be changed according to the file type we would output

$data =<<<DATA
I know my data would go here for the given file once decoded.
DATA;

header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=' . $filename);
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
header('Content-Length: ' . strlen($data));
echo $data;
?>

I'm wanting to have users able to download a file, but I'm wanting it to be a file that only users who are logged in can download. Basically, I don't want a user to be able to enter the URL and download it while not being logged in. Does anyone know what I would use to do this? Thanks.

Hi there,

I have a cronjob for PHP which generates a table with dynamic data and this table is exported to excel when run. When i have one table it downloads one excel file.

I want to download multiple excel files using a for loop. Please Help... Any suggestions will be helpful..

Thank you,
Regards,
Rohit

The following code works fine when using chrome or firefox, but fails with IE.
Error: Requested site is either unavailable or cannot be found.

Question: Does anyone see anything here that is a known bug with IE that I don't know about?

Code: [Select]
public function download(){
if($this->validateFile()){
if(!headers_sent()){
header('Content-type: '.$this->getType());
header('Content-Disposition: attachment; filename="'.$this->name.'"');
readfile($this->file);
} else{
echo 'Headers have already been sent and are preventing the file download from taking place.';
}
return true;
}
return false;
}

//I felt this function might be relevant to the issue.  I know, it's kind of a ghetto function, I'll improve on it some other time though.

private function getType(){
$types=array( 'txt' => 'text/plain',
'mp3' => 'audio/x-mp3',
'jpg' => 'image/jpeg',
'jpeg' => 'image/jpeg',
'gif' => 'image/gif',
'png' => 'image/png',
'doc' => 'application/msword',
'swf' => 'application/x-shockwave-flash',
'flv' => 'video/flv',
'mpg' => 'video/mpeg',
'mpeg' => 'video/mpeg',
'avi' => 'video/x-msvideo',
'rtf' => 'application/rtf',
'pdf' => 'application/pdf',
'zip' => 'application/zip',
'exe' => 'application/octet-stream',
'xls' => 'application/msexcel',
'xlsxl' => 'application/msexcel');
if(!$types[$this->getExt()]==''){
return $types[$this->getExt()];
}
return 'application/octet-stream';
}

Hi PHP freaks!!   I have manage to make a script to upload file in database and its working. I will share to you the codes so for other viewers and readers to use also.

if($result){
			if($_FILES['LRCard']['name'] != ""){
				$filename = $_FILES['LRCard']['name'];
				$ext = strrchr($filename,".");
				$LRCardname = $student_id;
				$LRCardname .="_". $filename; 
				if($ext ==".jpg" || $ext ==".jpeg" || $ext ==".JPG" || $ext ==".JPEG" || $ext ==".gif" || $ext ==".GIF"){
					$size = $_FILES['LRCard']['size'];
					if($size > 0 && $size < 5000000){
						$archive_dir = "LRCards";
						$userfile_tmp_name = $_FILES['LRCard']['tmp_name'];
						if(move_uploaded_file($userfile_tmp_name, "$archive_dir/$LRCardname")){
							/*
								if LRC is successfully uploaded then LRC is stored in database.
							*/
							mysql_query("update student_information set LRCard='$LRCardname' where student_id='$student_id'", $link_id); 
							$flag = "success"; 
							if(mysql_error()!=null){
								die(mysql_error());
							}

						}
						else{
							if(file_exists('LRCard/' . $LRCardname)) {
								unlink('LRCards/' . $LRCardname); 
							}
							rollbackData();
						}
					}
					else{
						if(file_exists('LRCards/' . $LRCardname)) {
							unlink('LRCard/' . $LRCardname); 
						}
						rollbackData();
						die("You can upload LRCard of 5 MB size only. Please, try again.");
					}
				}
				else{
					if(file_exists('LRCards/' . $LRCardname)) {
						unlink('LRCards/' . $LRCardname); 
					}
					rollbackData();
					die("You can upload LRCard of .jpg, .jpeg, .gif extensions only. Please, try again. ");
				}
			} 	
		}
		else{
			$flag="error";
		}
		if($flag == "success"){
			mysql_query(" COMMIT ");
			$flag="success";
			if(mysql_error() != null){
				die(mysql_error());
			}
	    }

Now, my problem is how to make a Php script to DOWNLOAD this uploaded file considering the 1. file path 2. file name 3. file extension. 4. student_id (to determine the specific file from a specific student)   My plan is to make a download button which hyperlink to download.php and after clicking that button the specified file to a specific student id will automatically be downloaded by the browser.  

On PHP 5.2.14.

I want to make files downloadable from my website. This seems easy enough:
<?php
$file = "downloads/someFile.txt";
// Set headers
header( "Content-Description: File Transfer" );
header( "Content-Type: application/force-download");
header( "Content-Length: " . filesize( $filename ) );
header( "Content-Disposition: attachment; filename=$file");
// header( "Content-Transfer-Encoding: binary");
readfile( $file );
unlink( $file );
?>
You'll notice, however, that I have "unlink" at the end of this file. That's exactly what I want: to remove the file from the server once it has been downloaded, to prevent anyone else from downloading it.

Here's the conundrum: When the user navigates to this URL, browsers offer the choice of Open/Save/Cancel. I don't want users to "open", and if the user presses "cancel", well then I probably don't really want the file deleted.

In short: I want the file SAVED, only. And I want to delete the file immediately after it has been downloaded.

Thoughts?

Hiya guys

After getting everything else working how I expected, I'm sort of struggling on the last step. Downloading

I have an upload.php file that allows me to upload a file to Mysql, the fields available a

upid - Primary
id - Need to link this to the logged on user id name
type
size content   The upload works perfectly

Can anyone help with implmenting it to the profile.php (1st page after login)

On profile page I have:

Welcome "username" from Session
Dynamic Table display his user id, username and password at the moment, this will be changed as not needed tho. I am using the sessions MM_Username to pass from the login

The table for Login looks like:

id - primary username password

I assume that if I can copy the ID from login and put it in ID in Upload and add colums to dynamic table to show the upload file, will this make that file only available to logged in user?

Cheers

Hello everyone!

 I'm somewhat of a newb in this so anyways I have this script and I try to force a browser to download a file when someone hits a download button.

here is what I'm trying:

   header('Content-Type: application-download');
   header('Content-Disposition: attachment; filename=' .basename($dl_id));
   readfile($dl_id);

It seems to work in Chrome, Firefox, but it doesn't work in IE

Any suggestions?

Hi,

Just looking how to create a link to download a file located on the server, it will be files like .doc etc.

Cant seem to find anything on the net so i think i need php but may be html.

Can anyone point me in the right direction?

Thanks

p.s. it will be used for more than one file so im looking for a small ish amount of code.

Hi

I have to submit an assignment where a user can upload a file of the type "Application/octet" and the script should be able to split this file into multiples files of smaller sizes and display a page where the user can download the split parts. Also the files are not to stay on the webserver after they are downloaded.

Any recommendation or lead or even code pieces would be appreciated.

Regards,
GuddooSk.

hi,


I want to download the file, where i have the search query in session variable, in my local system its working good, but in server its not working, any guidance please

Code: [Select]
<?php
include("global.php");
// Original PHP code by Chirp Internet: www.chirp.com.au 
// Please acknowledge use of this code by including this header. 

function cleanData(&$str) 
{
 $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); 
 if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; 
} 

$sql = $_SESSION['emp_search_sql'];
// file name for download 
$filename = "employees_" . date('Ymd') . ".xls";
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel; charset=UTF-8"); 
header("Pragma: no-cache");


$flag = false;
 $result = $DB_site->query($sql) or die('Query failed!');
while(false !== ($row = mysql_fetch_assoc($result)))
{
if(!$flag) 
{
// display field/column names as first row 

echo implode("\t", array_keys($row)) . "\n"; $flag = true; 
} 
array_walk($row, 'cleanData'); 
echo implode("\t", array_values($row)) . "\n";
}

?>

Thanks

Hi Chaps,

I'm using readfile to force the download of a file:

set_time_limit(0);

$file = 'monkey.gif';

if (file_exists($file)) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename='.basename($file));
    header('Content-Transfer-Encoding: binary');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('Content-Length: ' . filesize($file));
    ob_clean();
    flush();
    readfile($file);
    exit;
}
flush();


And this works fine, however, I do have some software installation files that could be downloaded (these are in excess of 280Mb).
I have checked php.ini:
Quote

memory_limit = 128M
post_max_size = 300M


But Internet Explorer hangs and then crashes.
Is there a way to allow big files to download using this method, or is there another way of forcing the download, without php 'reading' the file first?
I'm guessing that the problem lies with the memory_limit being smaller than the file size. Is it a good idea to increase the memory_limit to eg. 280Mb?
Cheers

Hi, i have a table which shows some mysql data, every entry has a checkbox to select individual entries, now i want to be able to export those selected entries into a xml or txt file, i tried this:

Code: [Select]
<?php
if($_POST['exporttxt']){
for($i=0;$i<count($_POST['checkbox']);$i++){
$export_id = $checkbox[$i];

$sql = "SELECT * FROM table WHERE id='$export_id'";
$result = mysql_query($sql);}
 

$output = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<root>\n";
if($result->num_rows > 0)
{
while($myrow = $result->fetch_assoc())
{
$output .= "\t<row>\n";
foreach($myrow as $_name => $_value)
{
$output .= "\t\t<$_name>$_value</$_name>\n";
}
$output .= "\t</row>\n";
}
}
$output .= "</root>";
}

header('content-type: text/xml');
header('content-disposition: attachment; filename=data_export.xml');
echo $output;
exit;

?>
but that doesn't seem to work. Any hints ?