php 根据用户角色控制数据显示,php – 如何管理数据库中的用户角色？

I just don’t know how I can link roles

to several permissions.

您使用连接表：role_id和permission_id来标识与哪些角色相关联的权限

编辑：

示例表

角色表

Role_ID Role_Name

1 Standard User

2 Super User

3 Guest

许可表

Permission_ID Permission_Name

1 View User List

2 Update Own User Account

3 Update Any User Account

ROLE_PERMISSION表

Role_ID Permission_ID

1 1 // Role 1 (Standard User) grants View User List

1 2 // and Update Own User Account

2 1 // Role 2 (Super User) grants View User List,

2 2 // Update Own User Account,

2 3 // and Update Any User Account

3 1 // Role 3 (Guest) grants View User List

列出指定的Role_ID的权限

select R.role_id,

P.permission_id,

P.permission_name

from role R,

permission P,

role_permission RP

where RP.permission_id = P.permission_id

and RP.role_id = R.role_id

and R.role_id = 1