How to pass or display mySQL data based on subscription or billing
- by spm
I want to build a PHP based site where, the user can view data based on the types of data they've paid for.
Allow me to use something simple for an example.
Let's say historical data for basketball was not readily available but could be purchased.
Simple information such as the Winner, Loser, Final score and date are all stored in a mySQL table.
What would be involved so that, when the user logs in, they can only see the historical data they have paid for.
My theories so far about the architecture:
I imagined a mySQL table storing True or False values for all historical game data they have paid for. Based on this, a 'data chart' object enables the user to view all data within their mySQL row which has a value of 'true.'
Follow ups:
Assuming I am correct, what methods are popular or practical for this type of service.
