Guest User

Untitled

a guest
Mar 22nd, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. <?php
  2. /*Create new user data*/
  3. public function insertUser($prm){
  4. $data = array(
  5. 'nik' => $prm['nik'],
  6. 'nama' => $prm['nama'],
  7. 'password' => md5($prm['pwd']),
  8. 'role' => 'user'
  9. );
  10. $this->db->insert('tbl_user', $data);
  11. }
  12.  
  13. /*Get user's detail to be updated*/
  14. public function getUserDetail($nikUser){
  15. $query = $this->db->query("
  16. SELECT *
  17. FROM tbl_user
  18. WHERE nik = '{$nikUser}'
  19. ");
  20.  
  21. return $query->result();
  22. }
  23.  
  24. /*Updating user data*/
  25. public function updateUser($prm){
  26. $nikUser = $prm['nikUser'];
  27. $nik = $prm['nik'];
  28. $nama = $prm['nama'];
  29. $pwd = md5($prm['pwd']);
  30.  
  31. $query = $this->db->query("
  32. UPDATE tbl_user
  33. SET nik = '{$nik}', nama = '{$nama}', password = '{$pwd}'
  34. WHERE nik = '{$nikUser}'
  35. ");
  36.  
  37. return $query;
  38. }
  39.  
  40. /*Deleting user data*/
  41. public function deleteSelectedUser($nikUser){
  42. $this->db->delete('tbl_user', array('nik' => $nikUser));
  43. }
  44. ?>
Add Comment
Please, Sign In to add comment