I need a php script(s) that will allow me to create a dynamic navigation menu with a submenu (2-3 levels deeps - e.g. Profile --> Settings --> Password) and save it in a mySQL DB table. However, I need to be able to assign a user to a role and choose whether that role can see the pages that have been added. Not necessarily an ACL but page-based access depending on the user's role. There may be 20-30 pages where access can be granted based on the user's role and there may be several roles. All dynamic, even the order in which the menu is displayed on the page. I want to avoid a framework such as Joomla and WordPress. I need this to be simple but functional.
Some clarification: A web application already exists to manage users, including assigning them to a role/group.
Basically, I need three things:
1. a simple menu management system where I can add pages and subpages (main menu and submenu items) and arrange them in a specific order (stored in a mySQL table)
2. grant (and/or deny) access to the pages based on the user roles/groups (stored in a mySQL table)
3. when the user logs in to the application, query the mySQL table(s) and display the menu items based on permissions set in their role/group (currently when the user logs in a session variable is created that includes the user's role/group).
I think this may help in narrowing down the user requirements.
Thanks for all the bids. I hope to review them all and make a decision within the next day.