add to database when user downloads a file

[LeeS]

I would like to be able to add a yes/no to a field in a 'user' database when a logged in user clicks on a link to download a file.

The site I have built stores docs and applications. and my client would like to know which user has downloaded a certain application (clicked on a button to 'download' and installer file.

Is this possible?

[samshel]

Create a PHP file which accepts the download path as parameter.

Link the download to this PHP file.

the PHP file will increment the counter or do whatever action you want and then redirect to the download path.

[LeeS]

Thanks for the reply, but don't quite understand.

 

I need to be able to show in a 'user profile' that this user has downloaded 'application1' but not downloaded 'application2'

 

I am a newbie, so sorry for not understanding.

 

Lee

[litebearer]

Psuedo code...

page 1
<a href="log_down_load.php?what_file_id<?PHP echo $file1_id; ?>">File 1</a>
<a href="log_down_load.php?what_file_id<?PHP echo $file2_id; ?>">File 2</a>
<a href="log_down_load.php?what_file_id<?PHP echo $file3_id; ?>">File 3</a>
<a href="log_down_load.php?what_file_id<?PHP echo $file4_id; ?>">File 4</a>

log_down_load.php
$what_file = $_GET['what_file'];
$user_id  = $_SESSION['user_id']
connect to database
insert into what_file table the user_id, the what_file_id
header to activate download of appropriate file (see http://www.ryboe.com/tutorials/php-headers-force-download)