Advertisement
Guest User

Untitled

a guest
Jun 21st, 2018
225
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. function loginAdmin($username, $password)
  2. {
  3. $this->db->select('BaseTbl.userId, BaseTbl.password, BaseTbl.name, BaseTbl.roleId, Roles.role');
  4. $this->db->from('tbl_users as BaseTbl');
  5. $this->db->join('tbl_roles as Roles','Roles.roleId = BaseTbl.roleId');
  6. $this->db->where('BaseTbl.username', $username);
  7. $this->db->where('BaseTbl.password', MD5($password));
  8. $query = $this->db->get();
  9.  
  10. $user = $query->result();
  11.  
  12. if(!empty($user)){
  13. return $user;
  14. } else {
  15. return array();
  16. }
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement