Role Based PHP Script with :roles table with a row for each role and containing the role id, the page for that role, and whatever other info about the roles that I need

[It_Monday]

How can I create a Role Based PHP Script which have :roles table with a row for each role and containing the role id, the page for that role, and whatever other info about the roles that I need.

[SamA74]

How far have you got with this yet?
To start you need to decide what columns your table needs, then create that table.
You can make the table either by a query, or use a tool like PHPmyAdmin if you find it easier.
What happens next depends on your needs for the application.

[It_Monday]

Thanks Sam for you reply.

The issue is the code to be used in the Login Form to capture the entries in my Users and Role Table.

EG User Table Columns are:
UID
UserName
Password
Reg Date
Status
RolesTable Columns are
RID
Role
Permission
Permission Columns are
PID
ScriptName

 Status

User Table are: Columns 1 Column 2 Column 3 Column 4 Column 5 Column 6
1 Me You CurrentTimeStamp 1 or 0

Role Table are: Columns 1 Column 2 Column 3
1 DataClerk 1,3,5,6 (Script name as per PID)

PermissionTable are: Columns 1 Column 2
1 Login.php
2 UpdateTable.php

How can I inculcate this into my Login page to assign role using Switch Statement.

Thanks