Re: [PHP-DB] File Downloads

On May 28, 2010, at 4:49 PM, Michael Stowe wrote:

> For that you would probably need to setup a databased system in  
> which (best scenario) they would need to register prior to  
> downloading or (not so secure) capture their IP address and prevent  
> that IP from downloading it again (example below).
>
> Since you are already using the php script to detect the download,  
> you could simply add (assuming MySQL) a Mysql query such as:
>
> $result = mysql_query('select dt.downloads, ip.ip_address from  
> downloads_table dt RIGHT JOIN downloads_ip ip ON ip.track_id = "% 
> your track id%" AND ip.ip_address = "'.$_SERVER 
> ['REMOTE_ADDRESS'].'" where dt.track_id = "%your track id%"');
> $results = mysql_fetch_array($result);
>
> if(($results['downloads'] <= 150) && (empty($results 
> ['ip_address']))) {
>
> mysql_query('INSERT INTO downloads_ip (track_id,ip_address) VALUES  
> ("%track_id%","'.$_SERVER['REMOTE_ADDRESS'].'")'); // insert IP  
> into downloads_ip table
> mysql_query('UPDATE downloads_table SET downloads = downloads + 1  
> WHERE track_id = "%track_id%" LIMIT 1'); // update the count of the  
> downloads
> // do download here
>
> } elseif (!empty($results['ip_address'])) {
> echo 'you have already downloaded this track...';
>
> } else {
> echo 'this track is no longer available for download';
> }
>
>
> (note I haven't checked the code, but it should give you a quick  
> example of how you can keep track of this)
>
> Hope this helps, and if you have any questions just let me know.
>
> Take care,
> Mike :o)
>
>
>
> "My command is this: Love each other as I
> have loved you."                         John 15:12
>
> -----------------------


Oh my.. thank you for that.



Karl DeSaulniers
Design Drumm
http://designdrumm.com