Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- array (size=2) 0 => object(stdClass)[40] public 'role' => string '2' (length=1) 1 => object(stdClass)[41] public 'role' => string '5' (length=1)
- DB TABLE
- id user_id role
- 1 4 2
- 2 4 5
- //get logged user roles
- public function user_roles($id){
- $userDB = $this->quickDB();
- $userdata = $userDB->query("SELECT role
- FROM role_assignment
- WHERE user_id = $id
- ")->result();
- $userDB->close();
- return ($userdata);
- }
- public function user_roles()
- {
- $roles=$this->Master_model->user_roles('4');
- if (in_array("1", $roles))
- {
- echo "Admin<br>";
- }
- if (in_array("2", $roles))
- {
- echo "Teacher<br>";
- }
- if (in_array("5", $roles))
- {
- echo "Academic<br>";
- }
- }
- $userdata = $userDB->query("SELECT role
- FROM role_assignment
- WHERE user_id = $id
- ")->result_array();
- $user_roles = array();
- foreach ($userdata as $val) {
- $user_roles[] = $val['role'];
- }
- return $user_roles;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement