PHP - Download File Question

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

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

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?

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

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.  

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 am using a script for users to download a file, however after the download I want to be able to
redirect the user or display a message etc... but I cannot get it to work.

My download code is below;

if($do_download){

 $filename = 'file.zip';
 $itemfile = ('/abc/123/htdocs/bin/'.$filename);
 $filelength = filesize($itemfile);

 $fp = @fopen($itemfile, "rb");

ob_start();
  Header("Pragma: public");
  Header("Expires: 0");
  Header("Cache-control: private");
  Header("Content-Type: application/x-zip-compressed");
  Header("Content-Transfer-Encoding: binary");
  Header("Content-Length: $filelength");
  Header("Accept-Ranges: bytes");
  Header('Content-Disposition: attachment; filename="'.$filename.'"');
  Header("Connection: close");
ob_end_clean();
  while(!feof($fp)){
  print stream_get_contents($fp); // for PHP 5+ else use fread
 }
 fclose($fp);

 header('Location: page2.php');
}

It doesn't seem to matter what I do whether a redirect or just an echo command nothing continues after the file is downloaded????

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, I want to force download an asf (audio) file, i have found a script, but it is not for asf but pdf, i was searching for mime types, but not sure what asf classifies?

<?php  
// your file to upload  
$file = '2007_SalaryReport.pdf';  
header("Expires: 0");  
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");  
header("Cache-Control: no-store, no-cache, must-revalidate");  
header("Cache-Control: post-check=0, pre-check=0", false);  
header("Pragma: no-cache");  
header("Content-type: application/pdf");  
// tell file size  
header('Content-length: '.filesize($file));  
// set file name  
header('Content-disposition: attachment; filename='.basename($file));  
readfile($file);  
// Exit script. So that no useless data is output-ed.  
exit;  
?>  

i found this page http://www.utoronto.ca/web/htmldocs/book/book-3ed/appb/mimetype.html#audi
so sould it be audio/x-wav?
Thanks,
Ted

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,

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

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.**