This is my first time using MySQL and I want to create a membership site. This is the table I outlined so far:
When users of my site pays for a month of subscription, I want to set membership_date to date when they subscribed. Then after that, do I check if their date has expired every time they log in?
What I thought of doing is maybe perform a check when they are logged in and visit the site to see if membership_date + 31 is greater than today's date, if so, then deactivate membership by changing subscription to false.
Something like this...
if membership_date + 31 > today's date
then assign FALSE to subscription
How can I find out the common and secure way to go about this?