Databases
StackOverflow2013
Postsdbo
POWhats the program workflow for paid membership on sites?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhats the program workflow for paid membership on sites?
    text
    copied!<p>I'm building a paid membership site in php using the Zend Framework. I need to work out a workflow for charging users. We have a number of monthly packages each offering varying degrees of services. For an example:</p> <p>A free plan which allows users to create one workspace and one user</p> <p>A Basic plan which allows to create 5 workspaces and 3 users and costs 15 dollars/month</p> <p>A Premium Plan which allows to create 20 workspaces and 10 users and costs 35 dollars/month</p> <p>A Heavy Duty Plan which allows to create 50 workspaces and 30 users and costs 65 dollars/month</p> <p>I would mostlikelye be integrating with a third party gateway like AlertPay for now - however the packages are monthly and :( sorry to say I haven't actually signed up on any monthly membership service site so far and wonder on how do you incrementally charge a user each month.</p> <p>Do you insist that they enter their credit card details each month or do you actually ask them for the detaisl once and then you charge it monthly - I honestly doubt the latter can even be considered.</p> <p>Or do users pay in advance for how many months they wish to use - how is it done normally.</p> <p>Also I would like to give my users a 10 day free trial of all the paid packages upon signing up. How would I implement this in code. I have my application set up and is functioning as though all users were administrators i.e no holds on anything and would now want to build in teh restrictions to monetise but am a bit lost on the work flow and the code implementation and data design to do this.</p> <p>Reminds me are there any online services or open source applications that I can use to plug in to my application and handle this aspect of the site for me?</p> <p>UPDATE =========================</p> <p>Very comprehensive answers, however on a development level - what should I store in my database and how would I design the tables required. I understand not that each month for a monthly subscription a postback would be made to a url I would provide the gateway. Like what would be the bare essentials here for the database.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload