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