Determine time range between two consecutive queries

[Eliott]

Hi there,
I made a script to login at which furthermore shows the selected data from the table using a query as a scrolling text, based on the Iframe and Javascript options (such as a short info-service). From the login scripts run Javascript that call other small PHP script that produces a query and then Javascript displays the resulting code in layer login skripte. All works beautifully if you use as a normal user, but I am afraid of the possibility that a some user holds down the whole time F5 to refresh page and so overloaded webserver and service crashes. Therefore I would like to know how to skip making a query if the previous query was less than 10 seconds, something like a flood prevention or prevention of multiple consecutive Search queries on some forums if the interval is less than a defined time. Thank you.

There is no good nor evil, just decisions and consequences.

 

[jpadie]

use sessions.
in your query receiving script do this

session_start();
define("TIMEOUT', 60) ; //60 seconds
if (isset($_SESSION['lastQuery'])):
   if ($_SESSION['lastQuery'] + TIMEOUT >=  time()):
        $_SESSION['lastQuery'] = time();
        echo ''; //to avoid browser hangs
        session_write_close();
        exit;
   endif;
endif;
$_SESSION['lastQuery'] = time();
session_write_close();
//run query and output data

 

[Eliott]

Thanks dude, I thought about that but wasn't sure is it good way. I thought also about cookies but this solution seems much easier for implementation. Thank you man.

There is no good nor evil, just decisions and consequences.

 

[ingresman]

if someone keeps refreshing, direct them off to somewhere "inapropriate" !