Date test - 3 months from date of subcription

[Anon]

Hi,

Q: Every user gets a subscription for 3 months when he registers on the site. The registration date is stored in MySQL table in the format 2000-09-25. How can I test registration date against current date and let user know when his/her subscription expires. I'm working with PHP3.

I can calculate expiration date when user registers --- $exp_d = date("Y-m-d", mktime($CurrentDay+2160)). Do you think I should also store this expiration date in the table and compare it against current date every time user tries to login?

Thank you,

alex

[Anon]

You can do date-calculations in mysql too, check out the manual.
If you also store the length in days of the trial period, you can build a query like this:

SELECT IF(current_date>signupdate+trialperiod,1,0) FROM table WHERE userid=id;

that would return "1" if the current date is past the trial period for that user,
or 0 if the user is still in the trial period.

[Anon]

Hi there!
Can u please send me the date validations in Java Script code on my e-mail address.
Bye!!!!

[Anon]

First of all, there is no javascript involved.
Second, if there was, I'd post it here, and not send it to you personally. This is a forum after all...