How to make session to allow different project?

By : shin
Source: Stackoverflow.com
Question!

I am planning to make a project management with PHP/MySQL/Codeigniter.

It will have 10 - 20 users and 20 - 30 projects going on at the same time.

Let's say John is a member of project A, B and C. Cindy is in A, D, F G etc.

I want to make it only members of project can access the project.

Now I am not sure how to approach this.

What do you suggest in terms of DB-design and session.

Any resources will be appreciated.

By : shin


Answers

As for session storage, I can recommend memcached. There is a PHP function that enables you to set your own session handler. Do not save sessions into a real database. It would add unncessary overhead.

I cannot tell you much about the database design as your post is lacking substantial information. Therefore I would just say, create two tables, "User" and "Project". "user" is made up of the columns ID, Name and E-Mail. Project consists of the columns ID, User ID (foreign key if supported by DBMS), Name etc.



You can use Zend_Acl with Codeigniter or you could try EzAuth



This video can help you solving your question :)
By: admin