php - How to create permisison based on user group in codeigniter? -


i using codeigniter ion authentication user group maintenance

here's link ion authenticaiton documentation

in edit user group add menus access particular group alone. how design mysql table , access in our controller , view page restrict page based on user group. please check below imageenter image description here

i have created menu table , menu permission table seperately.

menu table    menu id     menu name menu permission table  id  menuid  usergroup_id 

check whether current logged in user group id available in menu permission table or not

public function get_menus($user_group_id) {     if ($user_group_id == 1) {         $query = $this->db->query("select * menus parent_id=0");         $get_results = $query->result();     } else {         $query = $this->db->query("select * menu_permissions user_group_id = $user_group_id");         $get_results = $query->result();         $user_perm = array();         foreach($get_results $key=> $get_perm){             // echo $get_results[$key]->menu_id;             ////print '<pre>';             $user_perm[] = $get_results[$key]->menu_id;         }         $user_perm = implode(', ', $user_perm);         $query = $this->db->query("select * menus id in (".$user_perm.")");         $get_results = $query->result();     }      //print_r($get_results);     /*$user_perm = array();     foreach($get_results $key=> $get_perm){         // echo $get_results[$key]->menu_id;         ////print '<pre>';           $user_perm[] = $get_results[$key]->menu_id;      }*/      return $get_results; } 

Comments

Popular posts from this blog

Email notification in google apps script -

c++ - Difference between pre and post decrement in recursive function argument -

javascript - IE11 incompatibility with jQuery's 'readonly'? -