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 image
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
Post a Comment