One Download Per IP?

[MrLogic]

Hello,I was wondering if anyone knows how to make a PHP script(or what ever language)to allow one download per IP.So if you know,please tell me.Thanks

 

[xHissy]

The best way I think you could do would be to make a DB with a table for downloads.
And when someone downloads it add their IP to the database.

Then before they download it check the DB to see if the IP exists. If it doesn't insert it and allow the download.

 

[JoshuaLuke]

<?php
if(mysql_num_rows(mysql_query("SELECT * FROM downloads_log WHERE ip = '" . $_SERVER['REMOTE_ADDR'] . "')) == 1) {
// what you wanna do
}
?>

something like that, might not be exactly right as i just wrote it

 

[Weasel]

<?php
if(mysql_num_rows(mysql_query("SELECT * FROM downloads_log WHERE ip = '" . $_SERVER['REMOTE_ADDR'] . "')) == 1) {
// what you wanna do
}
?>

something like that, might not be exactly right as i just wrote it

That seems about right, a little update:

<?php
$download_amount = 1 // How many downloads are allowed per IP
$download_amount_per_ip_query = "SELECT * FROM downloads WHERE ip = '".$_SERVER['REMOTE_ADDR']."'";
$download_amount_per_ip = mysql_num_rows($download_amount_per_ip_query);
 
if($download_amount_per_ip >= $download_amount) {
echo "You already downloaded the max amount of downloads possible per IP";
}
?>

 

[ButtLord420]

Use the one above, and if you wanted it to be like 1 download per day, use a cron job to clear the database each day?

 

[JoshuaLuke]

That seems about right, a little update:

<?php
$download_amount = 1 // How many downloads are allowed per IP
$download_amount_per_ip_query = "SELECT * FROM downloads WHERE ip = '".$_SERVER['REMOTE_ADDR']."'";
$download_amount_per_ip = mysql_num_rows($download_amount_per_ip_query);
 
if($download_amount_per_ip >= $download_amount) {
echo "You already downloaded the max amount of downloads possible per IP";
}
?>

There needs to be a mysql_query after the num rows

 

[Sean]

There needs to be a mysql_query after the num rows

It needs to be before, you can't count the number of rows before you do the query....

 

[JoshuaLuke]

It needs to be before, you can't count the number of rows before you do the query....

No... it's mysql_num_rows(mysql_query("query"));

 

[Sean]

No... it's mysql_num_rows(mysql_query("query"));

$result = mysql_query($query);
$number = mysql_num_rows($result);

 

[Heaplink]

Why not just use MySQLi or PDO - better security, less work & cleaner code (using a wrapper) - With COUNT() function in SQL you can get the number of rows of the column

e.g. SELECT COUNT(`ip_addr`) WHERE `ip_addr` = ?

 

[Sean]

Why not just use MySQLi or PDO - better security, less work & cleaner code (using a wrapper) - With COUNT() function in SQL you can get the number of rows of the column

e.g. COUNT(`ip_addr`) or COUNT(*)

Yeah mysqli is an easier and better way to go

 

[Jian]

Some users have static IP, which means it changes everyday. Maybe you can record the current IP address in a database and store a cookie in their browser at the same time?

 

[TyleRJc]

You could use a cookie, But then you can edit/delete them.