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: 208

Filed under:
|
|
|
|

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

Related posts about php

Related posts about mysql