I am planning to create a simple project management system with PHP/MySQL/Codeigniter.
There will be a super-admin, an admin and around 20 users. User A, B, C...
And there will be around 50 projects. Project 1, 2, 3 ...
User A and B will be able to access project 1 pages, User C, D and F will be able to access project 2 pages etc.
Can I do it with session?
Or do I need to use ACL?
How should I structure the DB?
Can you give me your ideas please?
As sessions are mere tools to save user-specific data in, you are going to need some sort of access control. Some examples:
Here is how I like to do it using a home-made ACL system.
Zend_ACL is said to be very good, but I haven't worked with it myself yet.