[Moises]

Hey Guys!..Thanks a lot for helping me!!...Now i've a new question for ya!!!

What can i do to make a little code for download files..i mean every single (not all, but most of them) website has the old mode like this:
http://thesite.com/downloads/the-file-name.mp3
And what i want is:
http://thesite.com/downloads.php?file=FILENAME.MP3

how can i do that???

Sorry for all those silly questions but, i'm new with PHP..hahaha!!

[Nico]

Here are a lot of examples:

http://php.net/manual/en/function.readfile.php

[Moises]

Thank u!!

[Moises]

Hey Nico...i've one more question...i don't get this... in this code

PHP Code:

<?

   # Protect Script against SQL-Injections

   $fileid=intval($_GET[id]);

   # setup SQL statement

   $sql = " SELECT id, fileurl, filename, filesize FROM ibf_movies WHERE id=' $fileid' ";



   # execute SQL statement

   $res = mysql_query($sql);



       # display results

       while ($row = mysql_fetch_array($res)) {

       $fileurl = $row['fileurl'];

       $filename= $row['filename'];

       $filesize= $row['filesize'];



           $file_extension = strtolower(substr(strrchr($filename,"."),1));



           switch ($file_extension) {

               case "wmv": $ctype="video/x-ms-wmv"; break;

               default: $ctype="application/force-download";

           }



// required for IE, otherwise Content-disposition is ignored

if(ini_get('zlib.output_compression'))

ini_set('zlib.output_compression', 'Off');



           header("Pragma: public");

           header("Expires: 0");

           header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

           header("Cache-Control: private",false);

           header("Content-Type: video/x-ms-wmv");

           header("Content-Type: $ctype");

           header("Content-Disposition: attachment; filename=\"".basename($filename)."\";");

           header("Content-Transfer-Encoding: binary");

           header("Content-Length: ".@filesize($filename));

           set_time_limit(0);

           @readfile("$fileurl") or die("File not found.");



}



$donwloaded = "downloads + 1";



   if ($_GET["hit"]) {

       mysql_query("UPDATE ibf_movies SET downloads = $donwloaded WHERE id=' $fileid'");



}



?>

where I can specify the downloading directory 'cause i have my files in a diferent host!

and BTW that code is only for WMV files...and i have MP3, MPG and WMV... i found another one, but, i don't get it either:

PHP Code:

<?

$filename = 'dummy.zip';

           $filename = realpath($filename);



           $file_extension = strtolower(substr(strrchr($filename,"."),1));



           switch ($file_extension) {

               case "pdf": $ctype="application/pdf"; break;

               case "exe": $ctype="application/octet-stream"; break;

               case "zip": $ctype="application/zip"; break;

               case "doc": $ctype="application/msword"; break;

               case "xls": $ctype="application/vnd.ms-excel"; break;

               case "ppt": $ctype="application/vnd.ms-powerpoint"; break;

               case "gif": $ctype="image/gif"; break;

               case "png": $ctype="image/png"; break;

               case "jpe": case "jpeg":

               case "jpg": $ctype="image/jpg"; break;

               default: $ctype="application/force-download";

           }



           if (!file_exists($filename)) {

               die("NO FILE HERE");

           }



           header("Pragma: public");

           header("Expires: 0");

           header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

           header("Cache-Control: private",false);

           header("Content-Type: $ctype");

           header("Content-Disposition: attachment; filename=\"".basename($filename)."\";");

           header("Content-Transfer-Encoding: binary");

           header("Content-Length: ".@filesize($filename));

           set_time_limit(0);

           @readfile("$filename") or die("File not found.");

?>

and...do i have to create a MYSQL DB ??? ... I don't understand that code...Sorry!

[Nico]

On a different host? I don't think PHP forced download is possible in this case.

[Moises]

Ok...i'll try to put them into the same host...but...where i can specify the Directory (in the first script)

and DO i have to create a SQL DB ???

[Nico]

Try this

PHP Code:

<?php



    $filename = $_GET["file"];

    

    $path_to_files = "./wherever/";

    

    $filename = realpath($path_to_files . $filename);

    

    $file_extension = strtolower(substr(strrchr($filename,"."),1));

    

    switch ($file_extension) 

    {

        case "pdf": $ctype="application/pdf"; break;

        case "exe": $ctype="application/octet-stream"; break;

        case "zip": $ctype="application/zip"; break;

        case "doc": $ctype="application/msword"; break;

        case "xls": $ctype="application/vnd.ms-excel"; break;

        case "ppt": $ctype="application/vnd.ms-powerpoint"; break;

        case "gif": $ctype="image/gif"; break;

        case "png": $ctype="image/png"; break;

        case "jpe": case "jpeg":

        case "jpg": $ctype="image/jpg"; break;

        default: $ctype="application/force-download";

    }

    

    if (!file_exists($filename)) 

    {

        die("NO FILE HERE");

    }

    

    // required for IE, otherwise Content-disposition is ignored

    if(ini_get('zlib.output_compression'))

    ini_set('zlib.output_compression', 'Off'); 

    

    header("Pragma: public");

    header("Expires: 0");

    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

    header("Cache-Control: private", false);

    header("Content-Type:". $ctype);

    header("Content-Disposition: attachment; filename=\"". basename($filename) ."\";");

    header("Content-Transfer-Encoding: binary");

    header("Content-Length: ".@filesize($filename));

    set_time_limit(0);

    @readfile($filename) or die("File not found."); 

    



?>

EDIT: No, you don't need a database.

[Moises]

OK thank u....but..hahaha..sorry for bothering u but...i've one more question...I promise this is the last question!!

with this:

PHP Code:

    {

        case "pdf": $ctype="application/pdf"; break;

        case "exe": $ctype="application/octet-stream"; break;

        case "zip": $ctype="application/zip"; break;

        case "doc": $ctype="application/msword"; break;

        case "xls": $ctype="application/vnd.ms-excel"; break;

        case "ppt": $ctype="application/vnd.ms-powerpoint"; break;

        case "gif": $ctype="image/gif"; break;

        case "png": $ctype="image/png"; break;

        case "jpe": case "jpeg":

        case "jpg": $ctype="image/jpg"; break;

        default: $ctype="application/force-download";

    } 

what if i want to put a MPG, MP3, AND WMV Extension???

[Nico]

Try adding this:

PHP Code:

case "mp3": $ctype="audio/mp3"; break;

case "wmv": $ctype="video/wmv"; break;

case "mpg": $ctype="video/mpg"; break; 

[Moises]

Thank u so much!!!!..It works now!!!...Thank so so so much!!