Skip to main content

File Download Counter with PHP & MySQL

Hello there! Today we are going to create a simple file download tracker with php and mysql.

To track downloads, we need to upload our file to uploads directory and add files metadata (like file name and path) to database table. When a user will try to download a file by file id the original file path will retrieve from database table then php will update download count value and file will be forced for download.


Live Demo Download Source

Step 1 - Creating MySQL Table

At first we need to create a mysql table called files. The table will hold three column with an auto increment field. The name file will hold file name, path will hold file path in server and count will hold the total number of downloads.

CREATE TABLE `files` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `path` varchar(30) NOT NULL,
  `count` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
);

Step 2 - File Upload

The upload.php file will allow us to upload file to server. It holds some basic file download handler functionality. When we will upload file it will move uploaded file to uploads directory as well as it will insert file metadata to mysql table. I have used a password verifier to prevent unauthorized acction.

<?php
include 'function.php';
dbConnect();

$password = 'mypass'; // password
$max_upload_size = 1024*1024*2; // max file size

if ($_SERVER['REQUEST_METHOD'] === 'POST')
{
  if (!empty($_FILES['file']) and !empty($_POST['password']))
  {  
    // validate password
    if ($_POST['password'] === $password)
    {
      // validate file size
      if ($_FILES['file']['size'] < $max_upload_size) {

        // generate upload path with unique file name
        $path = 'uploads/' . uniqid() . '.';
        $path .= pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION);
        $name = $_FILES['file']['name'];

        // move uploaded file to upload directory
        if ( move_uploaded_file($_FILES['file']['tmp_name'], $path) )
        {
          // insert new file to mysql db
          mysql_query("INSERT INTO files (`name`, `path`)
                VALUES('$name', '$path')");

          // set success message
          $message = 'File Uploaded!';

        } else {
          $message = 'Upload fail';
        }
      } else {
        $message = 'File is too large';
      }
    } else {
      $message = 'Wrong Password!';
    }
  } else {
    $message = 'File not set';
  }
}

?>
<!doctype html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>File download</title>
  <link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
  <div class="container">
    <h1>Upload File</h1>

    <!--messages-->
    <?php if(isset($message)): ?>
      <p class="alert"><?php echo $message; ?></p>
    <?php endif ?>

    <!--file upload form-->
    <form action="" method="post" enctype="multipart/form-data">
      <input type="file" name="file">
      <input type="password" name="password" placeholder="Password">
      <input type="submit" name="upload" value="Upload">
    </form>

  </div>
</body>
</html>

Step 3 - File Download

The download.php file holds file download functionalities. This file retrieves file from database by it's id passed by file_id parameter. If it found file in database and file is exist in file system it updates counter value and forces file to download. We also need to off error reporting to avoid passing extra data and set php execution time to infinity to allow large file download by slow connection.

<?php
// off error reporting
error_reporting(0);
// set unlimited php execution time
set_time_limit(0);

include 'function.php';
// connect to db
dbConnect();

// read file id from url
$id = (int) isset($_GET['file_id']) ? $_GET['file_id'] : 0;
// retrieve file from db with id
$query = mysql_query("SELECT * FROM files WHERE id = '$id'");

if ($row = mysql_fetch_array($query))
{
  if (file_exists($row['path']))
  {
    // increase counter value
    $count = ++$row['count'];
    // update count column
    mysql_query("UPDATE files SET count = '$count' WHERE id = {$row['id']} ");

    // set file download headers
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename="'. $row['name'] .'"');
    header('Content-Transfer-Encoding: binary');
    header('Connection: Keep-Alive');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Pragma: public');
    header('Content-Length: ' . filesize($row['path']));

    // read file
    readfile($row['path']);
  }
  else {
    echo 'File not found!';
  }
}
else {
  echo 'Bad Request!';
}

?>
Labels:

Comments

  1. AnonymousSeptember 28, 2013 at 3:50 AM

    Nice tutorial!

    ReplyDelete
  2. AnonymousOctober 2, 2013 at 12:45 AM

    hello very nice tutorial but I am getting some few errors,

    First: My files keep opening as damaged or corrupted
    Second: The path is being saved in the local folder instead of file name so I end up having funny letters and numbers in my directory.

    Where am I going wrong? please help.

    Thanks

    ReplyDelete
    Replies
    1. KiashOctober 2, 2013 at 3:03 AM

      I don't know why it is happing! You got some bug on download.php file.

      First: Your file getting corrupted because this script suppling extra data. Set error_reporting(0);

      Second: getting funny file name it is due to bug on header('Content-Disposition: attachment; filename="'. $row['name'] .'"');

      Delete
  3. AnonymousOctober 4, 2013 at 1:39 AM

    Hello, Thank you for the info,

    But I have checked and I have included the error_reporting (0); but the error is still occurring.

    So how do i get rid of the funny names and number appearing in the directory, i would prefere the name of the file to be saved instead.

    Also i have just got another problem today, running the script in the local host works fine but when i run it on the live web, the script does not run.

    Please help.

    ReplyDelete
  4. AnonymousOctober 4, 2013 at 2:03 AM

    Thanks for your script. It is working well!

    ReplyDelete
  5. bubhamDecember 4, 2013 at 5:15 AM

    i want to add my path media fire link ..so it's counted
    ..Thanks

    ReplyDelete
  6. bubhamDecember 4, 2013 at 5:50 AM

    i want to add my path media fire link ..so it's counted
    ..Thanks

    Like that

    http://uppit.com/4z37rhr5arx8/Avast_Internet_Sucurity-9.0.2008.177_Licence_File.rar
    so it to be counted

    ReplyDelete
  7. UnknownDecember 9, 2013 at 8:14 PM

    I am getting error like "bad request",files are successfully uploaded but in download process i can't get those files for download.How I rectify these bug? Please help me

    ReplyDelete
  8. UnknownMarch 6, 2015 at 6:24 AM

    Than You So Much, I successfully done my work using your file uploading & downloading process code. now i don't showing uploading file in browser to order buy ASC or DESC. Please Help Me.

    ReplyDelete
  9. UnknownJanuary 12, 2016 at 8:40 AM

    Hi,
    my download.php is not opening, error ' bad request'
    would you know why please?
    thanks

    ReplyDelete
  10. Quân ĐàoJanuary 19, 2016 at 8:26 PM

    dịch vụ thành lập doanh nghiệp công ty trọn gói
    dịch vụ thành lập doanh nghiệp công ty tại thanh xuân
    dịch vụ thành lập doanh nghiệp công ty tại hà đông
    dịch vụ thành lập doanh nghiệp công ty tại long biên
    dịch vụ thành lập doanh nghiệp công ty tại cầu giấy
    dịch vụ thành lập doanh nghiệp công ty tại hải phòng
    dịch vụ thành lập doanh nghiệp công ty tại quận 3 tphcm
    dịch vụ thành lập doanh nghiệp công ty tại quận đống đa
    dịch vụ thành lập doanh nghiệp công ty tại quận thủ đức
    dịch vụ thành lập doanh nghiệp công ty tại huyện đông anh
    dịch vụ thành lập doanh nghiệp công ty tại huyện nhà bè
    dịch vụ thành lập doanh nghiệp công ty tại huyện hoài đức
    dịch vụ thành lập doanh nghiệp công ty tại bình dương
    dịch vụ thành lập doanh nghiệp công ty tại hưng yên

    ReplyDelete
  11. UnknownMarch 24, 2016 at 1:45 AM

    Dapatkan disini , karena Obat Pelangsing slimming Capsule Di Apotik belum tersedia , karena slimming capsule tidak di jual di sembarang temapat termasuk di apotik pun tujuannya untuk menjaga ke aslian produk tersebut, karena sekarang banyak perusahaan yang meniru produk produk herbal sehingga herbal yang asli khasiatnya bisa di rusak oleh produk yang palsu. Untuk itu hati hati dengan slimming capsule

    and obat vig power capsule

    ReplyDelete
  12. navyaAugust 23, 2016 at 1:19 AM

    I have read your blog its very attractive and impressive. I like it your blog.

    PHP Training in chennai | PHP Training Course

    PHP Training in chennai | Online PHP Course

    ReplyDelete
  13. norhanNovember 16, 2019 at 7:00 AM


    اعالى الخليج تقدم افضل خدمات نقل العفش الدولى المتميزه باسعار متميزة ومنها :

    شركة شحن عفش من الرياض الى دبي
    نقل عفش من الرياض الى الاردن شحن عفش من الرياض الى الاردن

    ReplyDelete

Post a Comment

Popular posts from this blog

Multiple File Upload with Progress Bar using PHP & jQuery

Some days age I have created a post that deals with How we can upload file with progress bar using php and jQuery . Some of my readers asked me how we can upload multiple files with progress bar. In this post I am going to show you how we can upload multiple files with progress bar. We can upload multiple files with progress bar exactly same way as I shown previous. But we need to do some modification with our file upload form and our php script to handle multiple files.
364 comments
Read more

File Upload with Progress Bar using jQuery and PHP

In this post you will learn how to create a AJAX file uploading system with progress bar using jQuery and PHP. For this purpose we will going to use jQuery Form Plugin . It is a easy to use and powerful jQuery AJAX form submitting plugin. It supports XMLHttpRequest Level 2 and iframe file transportation. That's why it will work for both old and new browsers.
302 comments
Read more

Multiple File Upload with PHP

Sometimes we need to allow our users to upload multiple file upload. On my previous post I was shown the basic of simple file upload with PHP. Today I am going to show you how to allow users to upload multiple files. It is almost similar like simple file upload but we need to do some modification with html markup and php code . multiple attribute is needed to add on the html markup. Major web browsers like Firefox, Chrome, Safari and IE 9+ support this attribute. Now I am going to show you how to upload multiple file with PHP and basic HTML form.
239 comments
Read more