Time limitation Function in PHP

realcoder

Hi everyone
i am working with Time limitation in php and i am new with time function
i want that i can limit someone action for sometime.
Mean if user login first time he has to post(or some other action) within 24 hours otherwise his account will block.
and when he post his time start again from beginning mean again he got 24 hours for next action.

and i also want to limit just one post in 24 hours ...

Please guide me if someone has work with time or know about this

cretaceous

Store the log in time in the database.
When he next logs in, if he hasn't done what you want and time is greater than 24 hours show message that he is blocked

To limit post to 1 per 24 hr, store the post time in db and then it's similar to above.

Either use MySql "date time" column type or use unixtime in an integer column type

realcoder

can you explain it little more that how i use this in count down time i have see most of count down scripts are in jqury or java can you suggest me any one which help me with this one

cretaceous

I don't have a script for you !
You need to write something yourself then come back if you have problems.
Don't get confused between the jquery/javascript scripts - which are checking the time every few minutes - and a php script along the lines of my suggestion, which would only check time when a user logs in.

realcoder

i am using current_timestamp in database table but don't have idea how i'll minus 24 hours from this format.
2013-05-20 22:37:56 this the format which is being used how i'll minus only 24 hours

bradgrafelman

dateCol - INTERVAL 24 HOUR

Note you could also do "1 DAY" in case you're interested in days (which aren't always 24 hours in length 😉).

More info under the MySQL manual entry for DATE_ADD().

realcoder

but i don't get your point of view how i'll execute this query for getting remaining time from first_time_login_time colum

bradgrafelman

I had a little trouble understanding your first post, and I also don't know how you're querying your DB at present, but you could add something like:

IF(TIMESTAMPDIFF(HOUR, first_time_login_time, NOW()) >= 24, FALSE, TRUE) loginTimeout

to a SELECT query; the 'loginTimeout' pseudo-column would then be a boolean value that indicates whether or not the desired interval has passed.

The same process could be applied to the 'limit just one post in 24 hours' logic as well.

realcoder

$que = mysql_query("SELECT TIMESTAMPDIFF(HOUR,mytimestoretable,NOW()) AS 'Diff' FROM table where ID='3075'");
while($row=mysql_fetch_array($que))


{
$re = $row['Diff'];
echo $re;
}

where i am wrong :queasy:
please can someone help to execute proper query through that i can get remaining time ?

bradgrafelman

Other than the use of a deprecated PHP extension, a complete lack of error checking, a superfluous variable declaration, and a potentially superfluous while() loop (assuming there is a PRIMARY or UNIQUE index in the ID column), I don't immediately notice anything wrong.

What output, if any, are you getting? If none, try checking to see if your query was successfully executed (something you should always be doing anyway).

realcoder

well thanks for the idea my query working fine now 🙂
but now i want to get exact time with minutes and i use MINUTE instead of second and divided that with 60 but not getting exact minutes
getting some values like

1.2666666666667

how to get exact hours + minutes instead of this big value ??

realcoder

and one more thing do u knwo any good count down script where i can put my values for running count down 🙂

Bonesnap

realcoder;11028651 wrote:
how to get exact hours + minutes instead of this big value ??

Take everything after the decimal and multiply it by 60. Your value would give you 16, which is 16 minutes. 1 hour and 16 minutes.

realcoder;11028655 wrote:
and one more thing do u knwo any good count down script where i can put my values for running count down 🙂

http://keith-wood.name/countdown.html

realcoder

Hi Thanks for the idea but one more thing I don’t know much about Jquery & java So can you explain how and where I’ll place my variable for changing time also want to remove day section from count down.

realcoder

Hi guys I am little confuse in structure of my database and php code.
Infact as I have already mentioned above that I want to restrict user that after his first sign up
He must need to submit post within 24 hours
Second If he don’t post in 24 hours after checking parameters we provide him extra 48 Hours for posting.
And if he post in first 24 hours or in extra 48 hours one more limitation I want to apply that
User can only post once in 24 hours if he has post once for example if he has 24 hours and he has post in first 12 hours than he will not be able to post in next 12 hours,
Once again reviewing my point below

After first sign up user has to post in 24 hours
If he don’t post he will get extra 48 hours
User only post once in 24 hours.
Please suggest me your ideas about database structure and php Code.
Thanks

cretaceous

I don't mean to be harsh but you have been given several suggestions here.
Prior to this last comment of yours you also say you have made good progress - yet now you are asking the original question again - it's hard to know what you need help on.
Step one is to now show the code you are using.

realcoder

well first part of my question i have cleared just asking other parts ...

annaharris

You need a record that expires in 24 hours (246060 seconds). It can be a cookie with expiration = time() + 246060. If cookies are not convenient, you could store the record in a MySQL table or in the file system.

realcoder

how can i get latest record from any table against specific clue
for example want to fetch time against userid=3 but i want that only latest record show me mean last record which is entered against useid=3?
what i use in mysql query?

bradgrafelman

If you have a timestamp or AUTO_INCREMENT column, then you'd want to add an ORDER BY col DESC LIMIT 1 to your query. If you don't have such a column, then there's no way to discern what the "latest record" is.