New Topic/Question
Reply
In this project I am working on there is going to be 4 user levels. Listener, Listener Premium, Artist and Artist Premium. What is the best way of going about implementing this? I was thinking of adding an extra table in the table where the user info is held called permission and set it as a INT(1) and making it so Listeners are 0, Listener Prem is 2, Artist is 3 and Artist Prem is 4. Then run a check ont he page for permissions. Or is there a better way of going about this?
4 Replies - 724 Views - Last Post: 27 April 2011 - 08:36 PM
Rate Topic:
MultiQuoteReplies To: User level permissions
#3
creativecoding
- Hash != Encryption
-
Reputation: 786
- Posts: 2,972
- Joined: 19-January 10
Re: User level permissions
Posted 27 April 2011 - 08:27 PM
"extra table in the table"
Do you mean column? That would be the best and easiest approach.
Do you mean column? That would be the best and easiest approach.
Was This Post Helpful?
0
#5
macosxnerd101
- Self-Trained Economist
-
Reputation: 9044
- Posts: 33,564
- Joined: 27-December 08
Re: User level permissions
Posted 27 April 2011 - 08:36 PM
If you're making a table, then it would have to be separate. I think the table approach is a good idea. That way, you can add additional permissions later. And add to the users table a user_permissions column with an FK to the permissions table.
Was This Post Helpful?
1
Page 1 of 1
|
|
| 