PHP - Download A File

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;
?>

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

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?

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.

I was able to upload the files to the DB but now am trying to retrieve it from the table but it's not working.   my code below

<?php                              
while($row = mysql_fetch_array($query1))
{
	 (list($id, $name) = mysql_fetch_array($query1));


echo"<tr>";
    
    echo"<td>&nbsp;$row[category]</td>";                
    echo"<td>&nbsp;$row[description]</td>"; 
	 echo"<td>&nbsp;$row[amount]</td>";
	 	?>
    <td> <a href="approved_req.php?id=<?php echo urlencode($id);?>"
><?php echo urlencode($name);?></a> </td>
<?php
	echo"<td>&nbsp;$row[status]</td>"; 
	?>
    <td><a class="btn btn-success" <?php echo"  href='invoice.php?id=$row[id]'> Pay </a></td>";?></a>
    
    
	  
  
     <?php  
    echo"</tr>";
}
  // }
   ?>
  </table>
  
   <?php 
if(isset($_GET['id'])) 
{
// if id is set then get the file with the id from database
//$con = mysql_connect('localhost', 'root', '') or die(mysql_error());
//$db = mysql_select_db('test', $con);
$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
         "FROM requisition WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$name");
ob_clean();
flush();
echo $content;
mysql_close();
exit;
}
?>  
 

Thanks in advance  

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';
}

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?

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

I wrote a very simple web form that allows my user to view text files from within their Internet browser.

I implemented a feature whereby the text files returned by the search are compressed into a ZIP. Here's my code
Code: [Select]
            function getFiles() {
             $result = null;
             $ZIPresult = null;
             if (empty($_POST['DBRIDs'])) { return null; }
             $mydir = MYDIR;
             $dir = opendir($mydir);
             $DBRIDs = $_POST['DBRIDs'];
             $getfilename = mysql_query("select filename from search_table where rid in (" . $DBRIDs . ")") or die(mysql_error());
             while ($row = mysql_fetch_array($getfilename)) {
             $filename = $row['filename'];
             $result .= '<tr><td><a href="' . basename($mydir) . '/' . $filename . '" target="_blank">' . $filename . '</a></td></tr>';
             $ZIPresult .= basename($mydir) . '/' . $filename;
            }
            if ($result) {
            $result = "<table><tbody><tr><td>Search Results.</td></tr> $result</table>";
           shell_exec("zip -9 SearchResult.zip ". $ZIPresult ." > /dev/null ");
   
    $fileName = 'SearchResult.zip';
    header("Cache-Control: public");
    header("Content-Description: File Transfer");
    header("Content-Transfer-Encoding: binary");
    header('Content-type: application/zip');
    header("Content-length: " . filesize($fileName));
    header('Content-Disposition: attachment; filename="' . $fileName . '"');
    readfile($fileName);
            } return $result;
            }

It works great If I download the ZIP file from the server using FTP (for example) but I force the download from the page header, the ZIP is corrupted.

What am I missing? Thanks for your input.

**PS: The new ZipArchive() library/class is not available on our production environment so I chose to use the Unix utility ZIP instead.**

I have a page in which i upload a circular & also select users who can view this page using multiple select dropdown box.

Now how to display the uploaded file to selected users when they login and not to other users.

Can anybody help.
Thanks in advance.

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.

Writing a text file in php. File is created apparently okay and appears in the directory. But cannot then download it (but can open it in Dreamweaver if just using local test server). Does some kind of EOF character need to be written to the file (I'm just guessing). Simple example:

<div id="mainContent">
<?php
$list="abcdef";
$cellfile=fopen("celltext.txt",'w') or die("Failed to create file");
fwrite($cellfile, $list) or die ("Could not write to file");
fclose($cellfile);
?>
<p><a href="cellfile.txt">Download</a> cell text file</p>
</div>

Clicking the link yields 404 File not found (even though it's there).

Dear all,

I'm trying to build an application to retrieve PDF documents from a site. The document being there is byte-served, so that I'm not able to get the complete document.

When i do a curl get for the document I get only the below.

Quote

HTTP/1.1 302 Found Date: Mon, 02 Aug 2010 01:14:18 GMT Server: Microsoft-IIS/6.0 Via: 1.1 COMP-NLB-9C Content-Length: 176 Location: http://xxxxx.yyyy.com/0012345.pdf Content-Type: text/html; charset=utf-8 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private HTTP/1.1 404 Not Found Date: Mon, 02 Aug 2010 01:14:18 GMT Server: Microsoft-IIS/6.0 Via: 1.1 COMP-NLB-9C Content-Length: 1635 Content-Type: text/html; charset=ISO-8859-1 X-Powered-By: ASP.NET



In firebug, I could see three GET requests. First one has the status '302 Found'. Second and third has status as '206 Partial Content'.

How to get the complete file in this case. Or guide me, if I'm doing it in a wrong way.

Regards,
Ursvmg

Is thier some code I can use to Notifiy me of files that are downloaded from my site.
I would like to put some public files (PDF) in a folder to where the public could download what ever, but I want to know who downloaded these files. Dont know much more than that just got the idea from another site cause they new I downloaded a file and I thought it would be a good idea on may site to do something like that.

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 ?