the startups.com platform about startups.comCheck out the new Startups.com - A Comprehensive Startup University

Categories

Browse Search

Loading...

Request a Call $1/min

Expert

KP

Kevin Petsche PHP / MySQL Developer

Tampa, FL

Expert in: PHP, MySQL, OOP and Advanced Design Patterns, entrepreneur, startups, passionate about teaching and helping other people program.

$1/min

New Arrival

Request a Call Send a Message

saved 1 time

0

Calls

0

Reviews

PHP

Programming

CSS

HTML

MySQL

jQuery

XML

MVC

Yii

Qt

Member since September 2014

Areas of Expertise

KP

$1/min per minute
New Arrival

PHP / MySQL / Zend2 / Yii / Laravel / Symfony2 / GIT / PHPUnit, Selenium

Kevin Petsche • Tampa, FL
Created 11 years ago in Technology / Other

I've worked in both small and large team environments, am well versed in advanced PHP Frameworks Yii 1 & 2, Symfony2, and Laravel.

Kevin Petsche Tampa, FL

New Arrival

Answers 1

PHP

Programming

CSS

HTML

MySQL

jQuery

XML

MVC

Yii

Qt

Related experts

About

Experts

Answers

Support

Follow

the startups.com platform

Startups Education

Startup Planning

Reach Customers

Virtual Assistants

Copyright © 2025 Startups.com. All rights reserved.

Clarity

Kevin Petsche

Tampa, FL

Expert in: PHP, MySQL, OOP and Advanced Design Patterns, entrepreneur, startups, passionate about teaching and helping other people program.

$1.00/min

—
0 Calls

—

0 Reviews

—

Avg. call

PHP Programming CSS HTML MySQL jQuery XML MVC Yii Qt

Call me to talk about

PHP / MySQL / Zend2 / Yii / Laravel / Symfony2 / GIT / PHPUnit, Selenium

I've worked in both small and large team environments, am well versed in advanced PHP Frameworks Yii 1 & 2, Symfony2, and Laravel.

Answers 1
Reviews 0

Answers

Kevin Petsche answered

What is the best way to do a permissions system for a low traffic administration system, PHP preferred, but general suggestion is also valuable.

Are you using a MySQL Database? And is your PHP application coded using any frameworks that you know of, Zend, Symfony, Yii, Laravel, Codeigniter? A lot of those frameworks already have permission systems built in.

Assuming you're not using any of those, one option is creating roles, then assigning those roles to your different PHP pages, and you would then assign the roles to a user.

Here's an example of how to structure the database.

You need at least 4 tables

roles: id, name
This would be for adding the role names (admin, users, partners, etc)

role_permissions: id, role_id, page_name
This would be assigning what pages a specific role can access.

user_roles: id, user_id, role_id
This is where you assign a user to a role

users: id, username, password, email
(I'm assuming you already have a users table, but this is were your users would be stored)

Now let's assume you have all the roles configured and a users assigned.

SELECT COUNT(rp.page_name) FROM user_roles AS ur
JOIN role_permissions AS rp ON rp.role_id=ur.role_id
WHERE ur.user_id=:user_id AND
rp.page_name=:page_name

If the result equals 1 the user has permission to view the page, if 0, they do not.

This is one of the most scalable and configurable ways to handle RBAS (Role Based Access Systems)

If you'd like I can draw out detailed blueprints (WireFrames) on how the UI would look for configuring roles and assigning them to users and how to implement a re-useable class so you only need to write 1 line of code to check if a user has permission to access a specific page.

I'd be happy to speak with you over the phone to go over this more in detail.

Schedule a call • Share • Flag

Programming

PHP

Web development

Reviews

Member since September 2014