download counter

Sign in to answer this question.

• 

  Manikandan Murugesan9y agoPosted Sep 2, 2017, 9:48 PM

  For download counts you could save to database

   

  1. $sql = "UPDATE `novels` SET `count`=`count`+1 WHERE `id`=".(int)$id; 
     

   

  Assuming you have a count column

  For download size you should move filesize out:

  1. header("Content-Length: ".filesize($file)); 
     

   This is for allowing browser to see progress, if you want to display it, it's same, you can store it in database

  1. $sql = "UPDATE `novels` SET `size`=".filesize($file)." WHERE `id`=".(int)$id; 
     

   

  This should be set when you upload.

  Remeber to escape your mysql queries because of vulnerability. For integers is simple as you can cast (int).