lovephp Posted May 21, 2016 Share Posted May 21, 2016 ok i got members table now i need to add 3 plans 1month, 6month and 12month with different fees. my question is do i need to create different table for it on it has to be in members table in db? someone guide through it please also i need to check if users sebscription over then remove some privillages from the website accordingly matching with plan. thanks Quote Link to comment Share on other sites More sharing options...
chriscloyd Posted May 21, 2016 Share Posted May 21, 2016 (edited) Hello, I would create another row in your member table called subscription_id or what ever you would name the subscriptions table. Then in the subscriptions table just create the rows for the id, name, description (if one), term (months, years), cost, renewal automatically, signup_date, end_date? Some of the things I add to the new table. Then just do your magic. Edited May 21, 2016 by chriscloyd 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.