[phpfreek]

Hello, below is a code that will update database information :

PHP Code:

$query="UPDATE $usernamee SET rank=rank+2"; 

$result = mysql_query($query) or die(mysql_error()); 

I will let users update their database info with these 2 lines of code;
However, this is not my problem, i would like users to be able to update info only each 2 minutes, that means i want to restrict update of database info for a period of 2 minutes after the info is updated last.

Does anyone know a code that cn do that ?
Thank you in advance.
Best Regards;
PHPFREEK

[mousegu]

You have to add a field to the databas that will hold a datetime stamp.
Then, before you update, select the datetime stamp from the database, check to see if its older than two minutes, if it is then update the database and add the new timestamp.

Hope that helps..

[Nico]

Add an INT field to the table and change your update query to something like this.

PHP Code:

$query="UPDATE $usernamee SET rank=rank+2, lastupdate =". time(); 

So that it stores the time it has been updated for the last time.

Now the next time when you want to update, you check when it has been updated for the last time.

PHP Code:

$query = mysql_query("SELECT lastupdate FROM $usernamee");

$userinfo = mysql_fetch_array($query);



if ($userinfo['lastupdate'] > (time() - 120))

{

    echo 'Please wait 2 minutes before updating your profile again.';

}

else

{

    // Update profile

} 

EDIT:

And topic moved to database.

[phpfreek]

:|
I have absolutely no idea what to SAY ... it's like the 10th time you help me with my projects ... all i can do is thank you

I really appreciate it bro, it worked perfectly ! ...

Thank again ...
Best Regards;
PHPFREEK

Originally Posted by nico_swd

Add an INT field to the table and change your update query to something like this.

PHP Code:

$query="UPDATE $usernamee SET rank=rank+2, lastupdate =". time(); 

So that it stores the time it has been updated for the last time.

Now the next time when you want to update, you check when it has been updated for the last time.

PHP Code:

$query = mysql_query("SELECT lastupdate FROM $usernamee");

$userinfo = mysql_fetch_array($query);



if ($userinfo['lastupdate'] > (time() - 120))

{

    echo 'Please wait 2 minutes before updating your profile again.';

}

else

{

    // Update profile

} 

EDIT:

And topic moved to database.