| Basic php mysql user management (User management in cakephp) [message #175509] |
Mon, 03 October 2011 12:01  |
sathyashrayan
Messages: 3
Registered: October 2011
Karma: 0
|
Junior Member |
|
|
Dear group,
I am working on a project management tool.I have this simple problem
but i could not get an correct solution. I have a user table that
belongs to a role (group). The role table is dynamic and tree in
nature. I could be editable and deletable. Each roles's id is inserted
in a user table as FK key. Now I have a situation where each roles
need to be an multiselect option which should be separate. So i need
an if-else-if. But what to be checked as an condition where all the
roles are dynamic, including ID and name?
My situation is a project management system where each user belongs
to an roles such as super admin, developer, tester ect. Nothing is
static..
I saw druapl, joomla database. They have users, roles, and a mapping
table roles_users table. Is that what i got to do on this situation?
But my project is a tool that has different database for each end-
user. There is no initial level of user at the starting. This project
is in cakephp. Any help?
|
|
|
|
| Re: Basic php mysql user management (User management in cakephp) [message #175511 is a reply to message #175509] |
Mon, 03 October 2011 12:49  |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 10/3/2011 8:01 AM, sathyashrayan wrote:
> Dear group,
> I am working on a project management tool.I have this simple problem
> but i could not get an correct solution. I have a user table that
> belongs to a role (group). The role table is dynamic and tree in
> nature. I could be editable and deletable. Each roles's id is inserted
> in a user table as FK key. Now I have a situation where each roles
> need to be an multiselect option which should be separate. So i need
> an if-else-if. But what to be checked as an condition where all the
> roles are dynamic, including ID and name?
>
> My situation is a project management system where each user belongs
> to an roles such as super admin, developer, tester ect. Nothing is
> static..
>
> I saw druapl, joomla database. They have users, roles, and a mapping
> table roles_users table. Is that what i got to do on this situation?
> But my project is a tool that has different database for each end-
> user. There is no initial level of user at the starting. This project
> is in cakephp. Any help?
I would recommend you ask database questions in a database related
newsgroup. You'll get much better answers.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: Basic php mysql user management (User management in cakephp) [message #175513 is a reply to message #175511] |
Mon, 03 October 2011 13:01 |
sathyashrayan
Messages: 3
Registered: October 2011
Karma: 0
|
Junior Member |
|
|
On Oct 3, 5:49 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> On 10/3/2011 8:01 AM, sathyashrayan wrote:
>
>
>
>
>
>
>
>
>
>> Dear group,
>> I am working on a project management tool.I have this simple problem
>> but i could not get an correct solution. I have a user table that
>> belongs to a role (group). The role table is dynamic and tree in
>> nature. I could be editable and deletable. Each roles's id is inserted
>> in a user table as FK key. Now I have a situation where each roles
>> need to be an multiselect option which should be separate. So i need
>> an if-else-if. But what to be checked as an condition where all the
>> roles are dynamic, including ID and name?
>
>> My situation is a project management system where each user belongs
>> to an roles such as super admin, developer, tester ect. Nothing is
>> static..
>
>> I saw druapl, joomla database. They have users, roles, and a mapping
>> table roles_users table. Is that what i got to do on this situation?
>> But my project is a tool that has different database for each end-
>> user. There is no initial level of user at the starting. This project
>> is in cakephp. Any help?
>
> I would recommend you ask database questions in a database related
> newsgroup. You'll get much better answers.
>
Thanks, will do the same..
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
|
|
|
|
| Re: Basic php mysql user management (User management in cakephp) [message #175523 is a reply to message #175509] |
Mon, 03 October 2011 20:19 |
Jonathan Stein
Messages: 43
Registered: September 2010
Karma: 0
|
Member |
|
|
Den 03-10-2011 14:01, sathyashrayan skrev:
> My situation is a project management system where each user belongs
> to an roles such as super admin, developer, tester ect. Nothing is
> static..
Sounds like a normal many-to-many relation - which is well handled by
CakPHP's "hasAndBelongsToMany" (HABTM)relation.
- Or maybe you could use CakePHP's Access Control Lists (ACL) to handle
this.
Regards
Jonathan
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]