troubleshooting Question
Logic for Access Levels
asked on
Hi Experts,
Can anyone give my any ideas on how I can about creating Login Access Levels that admins can use to specify which access level can access which module for a PHP/MySQL application.
There is a pre-defined list of ~25 modules going up to 2 levels deep, for example:
As you can see there are modules, and sub-modules, but there won’t be sub-sub-…-modules… just the 2 levels. I tried to make the 2 reports indented to demonstrate sub-levels, but EE won't let me.
To further complicate it, each may have either yes/no as options, or Full Access / Read-Only / No Access as options.
I guess, I’m looking for ideas on how to structure my DB for this, so when admins create a new level, I can use it as a template, then save the selections for each level.
As for the actual restriction, that I have figured out partly… I imagine that each module would be a database record, so I would pull all records associated to the user’s level, store it into a Session Associative array, then for each module do an If statement.
Any ideas would be greatly appreciated!
Can anyone give my any ideas on how I can about creating Login Access Levels that admins can use to specify which access level can access which module for a PHP/MySQL application.
There is a pre-defined list of ~25 modules going up to 2 levels deep, for example:
Orders
Login Levels
Reports
Today’s Sales
Monthly Sales
As you can see there are modules, and sub-modules, but there won’t be sub-sub-…-modules… just the 2 levels. I tried to make the 2 reports indented to demonstrate sub-levels, but EE won't let me.
To further complicate it, each may have either yes/no as options, or Full Access / Read-Only / No Access as options.
I guess, I’m looking for ideas on how to structure my DB for this, so when admins create a new level, I can use it as a template, then save the selections for each level.
As for the actual restriction, that I have figured out partly… I imagine that each module would be a database record, so I would pull all records associated to the user’s level, store it into a Session Associative array, then for each module do an If statement.
Any ideas would be greatly appreciated!
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.