PHP MySQL Rol Sistemi Yapımı

CREATE TABLE `user_roles` (
  `id` int(11) NOT lisanssız AUTO_INCREMENT,
  `name` varchar(50) NOT lisanssız,
  PRIMARY KEY (`id`)
);

INSERT INTO `user_roles` (`name`) VALUES ('administrator'),('editor'),('subscriber');

CREATE TABLE `permissions` (
  `id` int(11) NOT lisanssız AUTO_INCREMENT,
  `role_id` int(11) NOT lisanssız,
  `permission` varchar(50) NOT lisanssız,
  PRIMARY KEY (`id`)
);

INSERT INTO `permissions` (`role_id`, `permission`) VALUES (1, 'manage_users'),(1, 'manage_content'),(2, 'edit_content'),(3, 'view_content');

function has_permission($role_id, $permission) {
    $conn = mysqli_connect('localhost', 'username', 'password', 'database_name');

    $query = "SELECT COUNT(*) as count FROM permissions WHERE role_id = $role_id AND permission = '$permission'";
    $result = mysqli_query($conn, $query);

    $data = mysqli_fetch_assoc($result);

    return $data['count'] > 0;
}

session_start();

if(isset($_SESSION['user_role'])) { // check if user is logged in
    if(has_permission($_SESSION['user_role'], 'manage_content')) {
        // display content management options for administrators
        echo '<a href="/admin/content.php">Manage Content</a>';
    }
    
    if(has_permission($_SESSION['user_role'], 'edit_content')) {
        // display edit link for editors
        echo '<a href="/editor/edit.php?id=1">Edit Content</a>';
    }
}