Updating a Database upon a Successful Download

xxdrossxx

Hi, I'm a relatively experienced PHP programmer, but I was wondering if there was a way to execute a block of code only if a file was downloaded successfully (that is, only if the user downloaded the file COMPLETELY, not just clicked on the link and cancelled).

Here's a basic layout of what I'm doing. I know for a fact that this code works fine. I just need to know what I could do to create a condition to put into "DOWNLOAD WAS SUCCESSFUL". Is there any way that PHP can actually track this, or is it something that is completely client-side? Thanks for any help you can give.

//if this request is an actual file, send it out and forget everything prior to it
      if (!is_dir(stripslashes($url))) {
        //send the file
        header("Content-Type: application/octet-stream");
        header ("Cache-Control: must-revalidate, post-check=0, pre-check=0");
        header ("Content-Length: " . filesize(stripslashes($url)));
        header("Content-Disposition: attachment; filename=\"" . stripslashes($dir) . "\"");
        header("Content-transfer-encoding: binary");
        readfile(stripslashes($url));

    if (DOWNLOAD WAS SUCCESSFUL)  {
      //log the bandwidth
      $link = @mysql_connect('localhost', $MySQL['username'], $MySQL['password']);
      mysql_select_db($MySQL['database'], $link);
      $userInfo = mysql_fetch_array(mysql_query("SELECT bandwidth FROM member WHERE name = '$username'", $link));
      $bandwidth = $userInfo['bandwidth'];
      $bandwidth += filesize(stripslashes($url));
      mysql_query("UPDATE member SET bandwidth = '$bandwidth' WHERE name = '$username'", $link);
      mysql_close($link);
      return;
    }
  }

planetsim

You'll probably need to check your Apache logs and check on the filesize etc to see if it matches up, however unless your on dedicated server i doubt you will get access.

xxdrossxx

Originally posted by planetsim
You'll probably need to check your Apache logs and check on the filesize etc to see if it matches up, however unless your on dedicated server i doubt you will get access.

I see. It just so happens that I am on a dedicated server, though. Where would I look to check a filesize downloaded by a user? If you can just tell me the path to the log file on a typical Apache installation, I can figure out the rest.

Thanks.

kburger

By default, the Apache config file is named httpd.conf. Do a "locate httpd.conf" at a shell prompt. That should show you where your Apache config file is. Then, open the file in a text editor or 'cat' the file and read it to find the location of the log file.

xxdrossxx

Alright. Once I have the apache log files, when would i handle checking if the download was successful? should i add something after the "readfile($data)" method that reads the apache log file and sees if the transfer was the full filesize?