| 
	
 | 
 Posted by linda on 11/18/06 22:19 
OK please bare with me on this, as I don't know all the correct terminology.  
I would just like some input if this is the correct way to go about this. 
 
User_Reg                      Permissions 
user_id                            user_id 
name                               perm 
date_of_birth 
password 
reg_date 
 
I have two tables, one User_Reg and the other Permissions, they are link  
through user_id.  In Permissions the field perm has a default of 1 (for  
registered users), 2 is for administration and 0 being unregistered.  What I  
would like to know is, is this a good way of going about protecting pages,  
using this information in sessions? 
 
So if the person doesn't log in I would create a session when they visit the  
site of 0, this would only allow them to view certain pages, when they log  
in a session of 1 and their user name, and if admin logs in this would then  
be 2 and user name. 
 
I'm new to php and mysql so I'd be very grateful about how is the best way  
of going about this. 
 
The reason I have gone with permission levels is that later I'd like to work  
on a menu later, that displays links according to permission level. 
 
Many thanks in advance, 
Linda
 
  
Navigation:
[Reply to this message] 
 |