How to pass or display mySQL data based on subscription or billing
Posted
by
spm
on Stack Overflow
See other posts from Stack Overflow
or by spm
Published on 2012-12-04T00:31:17Z
Indexed on
2012/12/04
23:04 UTC
Read the original article
Hit count: 205
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.
© Stack Overflow or respective owner