Advertisement
Guest User

Untitled

a guest
Jul 11th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. <?php
  2. class M_login extends Model {
  3.  
  4. function M_login()
  5. {
  6. // Call the Model constructor
  7. parent::Model();
  8. $this->DB_mockingbird = $this->load->database('DB_mockingbird',TRUE);
  9. $this->DB_asteriskcdrdb = $this->load->database('DB_asteriskcdrdb',TRUE);
  10. }
  11.  
  12. function db_checkCredentials($username, $password)
  13. {
  14. $retVal = TRUE;
  15.  
  16. print_r($this->DB_mockingbird);
  17. echo "<br/><br/>";
  18. print_r($this->DB_asteriskcdrdb);
  19.  
  20. $sql = "SELECT * FROM customers where c_username=? and c_password=MD5(?)";
  21. $result = $this->DB_mockingbird->query($sql, array($username, $password));
  22.  
  23. $retVal = $result->num_rows();
  24.  
  25. if (!$retVal) {
  26. return ($retVal);
  27. }
  28.  
  29. $resultArray = $result->result_array();
  30. $this->session->set_userdata('username', $username);
  31. $this->session->set_userdata('id_customer', $resultArray[0]['id']);
  32. $this->session->set_userdata('perm', $resultArray[0]['c_perm']);
  33. $this->session->set_userdata('status', 'online');
  34.  
  35. return ($retVal);
  36. }
  37.  
  38. }
  39. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement