Download links

Quote wkempees:

As to the meaning of your post, you could leave the real link and change the static text only, the browser will however still display the real link (in statusbar and upon execute)

Quote :

As to the meaning of your post, you could leave the real link and change the static text only, the browser will however still display the real link (in statusbar and upon execute)

Quote wkempees:

Next you would have to alter the Download.php
Feed it the file_id through the url (would rather do it different but that's up to you)
Download.php would then select the databse row containing the filename and location (as well as type), identified by the URL variable.
It could then generate the correct MIME type and offer up the file for download and/or opening.

Quote 3140:

Walter,
That is not clear for me. I've managed the grid so far and download works but the link is visible. What I'm doing wrong?

Torsten

   // Edit this to point at your document/image path    
   $path = dirname(__FILE__)."/documents/";    
     
   // Change this to your DB class     
   $db = new clsDBmentecky();  
  
   // Change this to matck your table definition	    
   $file_name = CCDLookup("file_name", "files", "file_id=".$db->ToSQL(CCGetParam("file_id", "-1"), ccsInteger), $db);    
          
   $file_parts = explode(".", $file_name);    
   $ext = strtoupper($file_parts[count($file_parts) - 1]);    
    
   // Set header information    
   header('pragma: no-cache');    
   header('expires: 0');    
   header('Cache-Control: no-cache');    
   header('Content-Length: '.filesize($path.$file_name));    
   header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"');    
    
   // do some MIME stuff    
   if ($ext == "DOC")    
   {    
      $content_type = "application/msword";    
   }    
   else if ($ext == "PDF")    
   {    
      $content_type = "application/pdf";	      
   }    
   else if ($ext == "RTF")    
   {    
      $content_type = "application/rtf";	      
   }    
   else if (($ext == "MPG2") || ($ext == "MP3") || ($ext == "MP2"))    
   {    
      $content_type = "audio/mpeg";	      
   }    
   else if ($ext == "WAV")    
   {    
      $content_type = "audio/x-wav";	      
   }    
   else if ($ext == "GIF")    
   {    
      $content_type = "image/gif";	      
   }    
   else if ($ext == "JPG")    
   {    
      $content_type = "image/jpeg";	      
   }    
   else if ($ext == "PNG")    
   {    
      $content_type = "image/png";	      
   }    
   else if (($ext == "TIF") || ($ext == "TIFF"))    
   {    
      $content_type = "image/tiff";	      
   }    
   else    
   {    
      $content_type = "text/plain";	      
   }    
    
   header('Content-type: '.$content_type);    
    
   // output the file    
   readfile($path.$file_name);    
    
   exit;  

Quote jjrjr1:

Hi

This is great help. I do have one question for you guys.

If you wanted to link to the download file this way but want the file to automatically open in the application instead of the open save cancel dialoge box, what would you do?

Is there a way to bypass the dialoge box?

Thanks

header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"'); 

header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"'); 

   if (CCGetParam("inline", "0") == "0")  
   {    
      header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"');    
   }  

Quote jjrjr1:

Hey Rick

That works great. Question is, will this only display if there is a plug-in for the browser or will the associated application load?

For example, video files, excel spread sheets etc

Thanks very much

   if (CCGetParam("inline", "0") == "0")  
   {    
      header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"');    
   }  
   else  
   {    
      header('Content-Disposition: inline; filename="'.CCGetOriginalFileName($file_name).'"');    
   }  

Quote mentecky:

3140,

Here's how I make files downloadable:

First get your uploads working... there are plenty of tips here for that feature.

Create a blank page, in this example "download". Click the blank page and in Properties/Events select On Before Show and "Add Code...".

Put the following in the event handler:

   // Edit this to point at your document/image path    
   $path = dirname(__FILE__)."/documents/";    
     
   // Change this to your DB class     
   $db = new clsDBmentecky();  
  
   // Change this to matck your table definition	    
   $file_name = CCDLookup("file_name", "files", "file_id=".$db->ToSQL(CCGetParam("file_id", "-1"), ccsInteger), $db);    
          
   $file_parts = explode(".", $file_name);    
   $ext = strtoupper($file_parts[count($file_parts) - 1]);    
    
   // Set header information    
   header('pragma: no-cache');    
   header('expires: 0');    
   header('Cache-Control: no-cache');    
   header('Content-Length: '.filesize($path.$file_name));    
   header('Content-Disposition: attachment; filename="'.CCGetOriginalFileName($file_name).'"');    
    
   // do some MIME stuff    
   if ($ext == "DOC")    
   {    
      $content_type = "application/msword";    
   }    
   else if ($ext == "PDF")    
   {    
      $content_type = "application/pdf";	      
   }    
   else if ($ext == "RTF")    
   {    
      $content_type = "application/rtf";	      
   }    
   else if (($ext == "MPG2") || ($ext == "MP3") || ($ext == "MP2"))    
   {    
      $content_type = "audio/mpeg";	      
   }    
   else if ($ext == "WAV")    
   {    
      $content_type = "audio/x-wav";	      
   }    
   else if ($ext == "GIF")    
   {    
      $content_type = "image/gif";	      
   }    
   else if ($ext == "JPG")    
   {    
      $content_type = "image/jpeg";	      
   }    
   else if ($ext == "PNG")    
   {    
      $content_type = "image/png";	      
   }    
   else if (($ext == "TIF") || ($ext == "TIFF"))    
   {    
      $content_type = "image/tiff";	      
   }    
   else    
   {    
      $content_type = "text/plain";	      
   }    
    
   header('Content-type: '.$content_type);    
    
   // output the file    
   readfile($path.$file_name);    
    
   exit;  

The above assumes a table called "files" with file_id, file_desc and file_name as it's columns.

On your download page, set the link to "download.ccp" with a parameter of "link_id".

You can see it work on a demo page at: http://www.mentecky.com/demo/files_list.php

Currently you can upload JPG, GIF and TXT files, up to 20K. I will be disabling UPLOAD there once this problem is resolved though.

Hope that works for you.

Rick