PFZ.nl - PHP Community: word bestand openen vanaf link /sql-php - Offtopic - Forum - PFZ.nl - PHP Community

    function dl_file($file) {


        //First, see if the file exists
        if (!is_file($file)) {
            die("<b>404 File not found!</b>");
        }

        //Gather relevent info about file
        $len = filesize($file);
        $filename2 = basename($file);
        $file_extension = strtolower(substr(strrchr($filename2, "."), 1));


        //This will set the Content-Type to the appropriate setting for the file
        switch ($file_extension) {
            case "pdf":
                $ctype = "application/pdf";
                break;
            case "txt":
                $ctype = "text/plain";
                break;
            case "doc":
                $ctype = "application/msword";
                break; //Warning! writes path in file
            case "docx":
                $ctype = "application/msword";
                break; //Warning! writes path in file
            case "xls":
                $ctype = "application/vnd.ms-excel";
                break;
            case "xlsx":
                //$ctype = "application/vnd.ms-excel";
                $ctype = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                break;
            case "ppt":
                $ctype = "application/vnd.ms-powerpoint";
                break;
            case "gif":
                $ctype = "image/gif";
                break;
            case "png":
                $ctype = "image/png";
                break;
            case "jpeg":
            case "jpg":
                $ctype = "image/jpeg";
                break;

                //The following are for extensions that shouldn't be downloaded (sensitive stuff, like php files)
            case "php":
            case "htm":
            case "html":
                die("<b>Cannot be used for " . $file_extension . " files!</b>");
                break;

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

        //Begin writing headers
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header("Cache-Control: public");
        header("Content-Description: File Transfer");
        
        //Use the switch-generated Content-Type
        header("Content-Type: $ctype");

        //Force the download
        $header = "Content-Disposition: attachment; filename=" . $filename2 . ";";
        //header($header);
        header("Content-Transfer-Encoding: binary");
        header("Content-Length: " . $len);
        @readfile($file);
        exit;
    }