check IP and datetime to popup survey

Anon

Hi,

I'm working on the servey. And I'm attatching the survey to the main page. But I don't want to popup the survey if the survey has been taken less then 1 hour and IP address is the same or from the same machine:

For this I'm using the PHP with My SQL running on the Apache server on UNIX box.
Thank you

Aanee

gushy

And your question is what?

Assuming you are asking how would you do this, well you can use the following:

for time:

date()
mktime()

for ip:
$REMOTE_ADDR

Also MySQL has a timestamp column type.

Look these up tin the manuals and you'll be well away.

-- Nick Gushlow

Anon

Hi I'm using this function to check the IP and the datetime, But it dosen't stop upload, even if the time is less then 1 hour and newIP = old IP

is there is any better way to do it, if it is please let me know.

function connect_dbs($hostname, $username, $password, $dbname)
{
require ("database1.php3");

             $link = mysql_pconnect("$hostname", "$username", "$password");
             $Err = mysql_error();
             if ($link && mysql_select_db("$dbname"))
             {
                  $Err .= mysql_error;
                  return ($link);
             }
             else
             {
                 echo $Err;
                 exit;
             }
    }

function check_ip($IP, $date_time)
{

        require ("database_info.php3");
         echo $hostname, $username, $password, $dbname;
        ("$hostname", "$user name", "$password");

$lasthour = time() - 3600;
$sql = "select date_time, IP from table_name where date_time > $lasthour and IP = '$REMOTE_ADDR' order by date_time desc" or die( "Query failed: error was $php_errormsg'" );
if (mysql_db_query("$dbname", $sql)== false)
{
echo "not able to get the data: ", mysql_error()."<p>";
exit;
}
return $res;
}

kparker

But I don't want to popup the survey if the survey has been taken
less then 1 hour and IP address is the same or from the same machine:

OK, this will prevent a lot of AOL users from taking your survey, along
with millions (estimated) of folks who live behind address-translating
firewalls and routers--but you don't need to hear from them, right?
Or, I fill it out at my desk, wander over to yours and fill it out again, and
bingo--you can't take the survey at all. :-)

Meanwhile, all the poor folks still using dialup connections can fill
out the survey dozens of times, by the simple expedient of hanging
up and redialing.

Seriously, and all facetiousness aside, this question seems to come up every week or so, but the facts of the matter remain the same: there is not now (nor has there ever been) a one-to-one correspondence between users and ip addresses, and anyone relying on this kind of scheme for identification or non-duplication is in trouble.

gushy

Damn that was gonna be my answer 🙂 Still Kirk put it better than I would have.

The only fool proof solution is to only allow registered users to take the survey, and then record that in a database.

-- Nick Gushlow

kparker

No problem, Nick, we can be a tag team--you take the next one!

gushy

Does that mean we get to wear funky outfits like on WWF?!

🙂

-- Nick Gushlow.