Membership Deactivation/Renewal

Yrogerg

I'm building a project that requires users to sign up for an annual membership. My question is how do I manage the accounts so once their year of membership expires it deactivates their account and possibly sends them an email prompting them to renew it?

All their info will be stored in MySQL but how do I automatically detect a membership expiration?

Thanks in advance...

LordShryku

I have something like this that I do. I have the expiration date inserted in the database

$expire = date("Y-m-d", mktime(0,0,0, date(m), date(d), date(Y)+1));

Then I have a script that I run in a cron job every day that gathers the list of people about to expire and shoots them the email.

Yrogerg

The site is remotely hosted so what is a cron job and how would I arrange that? Is it just a script that I could pass to the hosting facility and have them run it daily?

LordShryku

Yeah, if they are using linux or BSD, they should be able to put it in the cron for you. Or if they run CPanel, you could do it yourself. You may want to get a hold of them and ask them what your options are. The cron is just a scheduler. You tell it what to run, when, and how often, at it will execute it for you.

Yrogerg

sweet. many thanks...