Downloadeing files in php

Wanasa · #1 (**permalink**) 06-12-09, 10:28 AM

hi there,

am working on download script and i want it to work just like realplayer.com and microsoft where a yellow bar is shown at the top of the browser and download the file in most pupular web browser such as Firefox and IE ...

also i want it to count the number of downloads, Here where is submit and update query. is there an query that update fields by adding anumber to it or do i have to do read the field and then do the math thing and update the field again ...

here are the headeres and the code am working on :
when you click on the download link you will be targted to the page download.php and in IE it shows a box to save or to open as or to cancel in firefox it shows to download the file download.php ( which is a problem ) and the page where you've praccess on download link it will remain as it is no refreashin or anything ...

the download.php code is :

PHP Code:


			
<?php



# including the configuration files and all needed functions files

require_once("includes/config.php");





# SET THE GOLBALES FOR THE SYSTEM

# ------------------------------------------------------



# the defualt variables for the templates in the system

global $vars;



# the settings from the config.php file

global $setting;



# the language file array

global $lang;



# ------------------------------------------------------



# i need to supbmit thies tow queries too. how can it be done with headers and is it the write way !!

/*

# read the numof downloades and update it

$downloaded = mysql_query("SELECT `downloaded` FROM `files` WHERE `filename` = "'". $_REQUEST['filename'] ."'");

# update the number of downloadeds by one

$update = mysql_query("UPDATE `files` SET `downloaded` = '". (#downloaded + 1) ."' WHERE `filename` = "'". $_REQUEST['filename'] ."'");

*/



$requested_file = $_REQUEST['nickname'] . "___" . $_REQUEST['filename'];



$download_path = getSetting('filesdirectory') . "/";



$size = filesize ($download_path . $requested_file);







    header("Content-Type: application/octet-stream");

    header("Content-Disposition: attachment; filename=" . $_REQUEST['filename']);

    header ('Expires: 0');

    header ('Last-Modified: ' . gmdate ('D, d M Y H:i:s', filemtime ($requested_file)) . ' GMT');

    header ('Pragma: public');

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

    header("Content-Type: application/force-download");

    header("Content-Type: application/download");

    header ('Accept-Ranges: bytes');

    header ('Content-Length: ' . $size);

    header ('Connection: close');



    readfile($download_path . $requested_file); 

?>

Jcbones · #2 (**permalink**) 06-12-09, 12:29 PM

PHP Code:


			
$update = mysql_query("UPDATE `files` SET `downloaded` = downloaded + 1 WHERE `filename` = "'". $_REQUEST['filename'] ."'");

will update your database by adding the column by one.

I would steer clear of using $_REQUEST, and use the specific $_GET, or $_POST array's.

Wanasa · #3 (**permalink**) 06-12-09, 01:20 PM

thankx Jcbnes aloooot.

still do anyone know how to do the download thing !!

=OTS=G-Man · #4 (**permalink**) 06-12-09, 04:01 PM

as far as I know. the yellow bar is just in IE, and is from the default security settings in IE6 and up to warn people about a download thats trying to download.

If you wanted to recreate it, I have seen it down using CSS and javascript.

Wanasa · #5 (**permalink**) 06-12-09, 09:31 PM

no man am talking about the submiting queries while using headers.

Wanasa · #6 (**permalink**) 06-13-09, 07:54 AM

this is the final code but its not woeking if the update line exists else it works

PHP Code:


			
<?php



/* HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH *\

-------------------------------------------------------------------------------

#                            #

#    P.V. SHARE v1.0                    #

#    System Copy Type : FULL COPY            #

#    P.V. SHARE COMPANY - www.pvshare.com        #

#    Last Modify : 01/04/09                #

#    -----------------------------------------------------------    #

#    FILE CONTENT :                    #

#    this file holdes the download function to brevint        #

#    knowing the file real source                #

#                            #

--------------------------------------------------------------------------------

\* HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH */







# including the configuration files and all needed functions files

require_once("includes/config.php");





# SET THE GOLBALES FOR THE SYSTEM

# ------------------------------------------------------



# the defualt variables for the templates in the system

global $vars;



# the settings from the config.php file

global $setting;



# the language file array

global $lang;



# ------------------------------------------------------



if($_GET['filename'] && $_GET['nickname']) {



    # update the number of downloadeds by one

    $update = mysql_query("UPDATE `files` SET `downloaded` = downloaded + 1 WHERE `filename` = "'". $_GET['filename'] ."'");







    $GETed_file = $_GET['nickname'] . "___" . $_GET['filename'];



    $download_path = getSetting('filesdirectory') . "/";



    $size = filesize ($download_path . $GETed_file);





    set_time_limit(0);



    header("Content-Type: application/octet-stream"); 

    header("Content-Disposition: attachment; filename=" . $_GET['filename']); 

    header ('Expires: 0'); 

    header ('Last-Modified: ' . gmdate ('D, d M Y H:i:s', filemtime ($GETed_file)) . ' GMT'); 

    header ('Pragma: public'); 

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

    header("Content-Type: application/force-download"); 

    header("Content-Type: application/download"); 

    header ('Accept-Ranges: bytes'); 

    header ('Content-Length: ' . $size); 

    header ('Connection: close'); 



    ob_clean();

    flush();



    readfile($download_path . $GETed_file);  

    exit();



} else {



    exit();



}









?>

Jcbones · #7 (**permalink**) 06-13-09, 09:13 AM

Try this, there was an error with your double quotes in the $update line.

PHP Code:


			
<?php

/* HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH *\
-------------------------------------------------------------------------------
#                            #
#    P.V. SHARE v1.0                    #
#    System Copy Type : FULL COPY            #
#    P.V. SHARE COMPANY - www.pvshare.com        #
#    Last Modify : 01/04/09                #
#    -----------------------------------------------------------    #
#    FILE CONTENT :                    #
#    this file holdes the download function to brevint        #
#    knowing the file real source                #
#                            #
--------------------------------------------------------------------------------
\* HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH */



# including the configuration files and all needed functions files
require_once("includes/config.php");


# SET THE GOLBALES FOR THE SYSTEM
# ------------------------------------------------------

# the defualt variables for the templates in the system
global $vars;

# the settings from the config.php file
global $setting;

# the language file array
global $lang;

# ------------------------------------------------------

if($_GET['filename'] && $_GET['nickname']) {

    # update the number of downloadeds by one
    $update = mysql_query("UPDATE `files` SET `downloaded` = downloaded + 1 WHERE `filename` = ' ". $_GET['filename'] ."'");



    $GETed_file = $_GET['nickname'] . "___" . $_GET['filename'];

    $download_path = getSetting('filesdirectory') . "/";

    $size = filesize ($download_path . $GETed_file);


    set_time_limit(0);

    header("Content-Type: application/octet-stream"); 
    header("Content-Disposition: attachment; filename=" . $_GET['filename']); 
    header ('Expires: 0'); 
    header ('Last-Modified: ' . gmdate ('D, d M Y H:i:s', filemtime ($GETed_file)) . ' GMT'); 
    header ('Pragma: public'); 
    header ('Cache-Control: must-revalidate, post-check=0, pre-check=0'); 
    header("Content-Type: application/force-download"); 
    header("Content-Type: application/download"); 
    header ('Accept-Ranges: bytes'); 
    header ('Content-Length: ' . $size); 
    header ('Connection: close'); 

    ob_clean();
    flush();

    readfile($download_path . $GETed_file);  
    exit();

} else {

    exit();

}




?>