Epidemic Posted November 8, 2008 Share Posted November 8, 2008 Hey, I am making an authentication panel and I want my users to be able to have access to a script for one month. However I do not know how to time one month in PHP. Well 31 days to be honest. I was wondering if anyone could help me out. I want to be able to change an int in my database to 1 for 31 days and after those 31 days change it back to 0. I also want to return how many days they have left until the int is returned to 0. Any help would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
DeanWhitehouse Posted November 8, 2008 Share Posted November 8, 2008 Set a timestamp in the database from there first access (which i would advise being log in) then check each time if it's been 31 days since they first logged in. Quote Link to comment Share on other sites More sharing options...
Epidemic Posted November 9, 2008 Author Share Posted November 9, 2008 How would I go about using a time stamp? Quote Link to comment Share on other sites More sharing options...
DeanWhitehouse Posted November 9, 2008 Share Posted November 9, 2008 In the database you have a row called time (or something similar) then have it contain a timestamp, then in your update sql statement put something like UPDATE table SET time = NOW(); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.