Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. array (size=2) 0 => object(stdClass)[40] public 'role' => string '2' (length=1) 1 => object(stdClass)[41] public 'role' => string '5' (length=1)
  2.  
  3. DB TABLE
  4. id user_id role
  5. 1 4 2
  6. 2 4 5
  7.  
  8. //get logged user roles
  9. public function user_roles($id){
  10. $userDB = $this->quickDB();
  11. $userdata = $userDB->query("SELECT role
  12. FROM role_assignment
  13. WHERE user_id = $id
  14. ")->result();
  15. $userDB->close();
  16. return ($userdata);
  17. }
  18.  
  19. public function user_roles()
  20. {
  21. $roles=$this->Master_model->user_roles('4');
  22.  
  23. if (in_array("1", $roles))
  24. {
  25. echo "Admin<br>";
  26. }
  27. if (in_array("2", $roles))
  28. {
  29. echo "Teacher<br>";
  30. }
  31. if (in_array("5", $roles))
  32. {
  33. echo "Academic<br>";
  34. }
  35. }
  36.  
  37. $userdata = $userDB->query("SELECT role
  38. FROM role_assignment
  39. WHERE user_id = $id
  40. ")->result_array();
  41.  
  42. $user_roles = array();
  43. foreach ($userdata as $val) {
  44. $user_roles[] = $val['role'];
  45. }
  46. return $user_roles;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement