Advertisement
Guest User

Untitled

a guest
Apr 20th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.72 KB | None | 0 0
  1. <?php
  2.  
  3. class WebsiteUser{
  4. /* Host address for the database */
  5. protected static $DB_HOST = "localhost";
  6. /* Database username */
  7. protected static $DB_USERNAME = "rwmolito_eater";
  8. /* Database password */
  9. protected static $DB_PASSWORD = "cst@8238";
  10. /* Name of database */
  11. protected static $DB_DATABASE = "rwmolito_eatery";
  12.  
  13. private $username;
  14. private $password;
  15. private $mysqli;
  16. private $dbError;
  17. private $authenticated = false;
  18.  
  19. function __construct() {
  20. $this->mysqli = new mysqli(self::$DB_HOST, self::$DB_USERNAME,
  21. self::$DB_PASSWORD, self::$DB_DATABASE);
  22. if($this->mysqli->errno){
  23. $this->dbError = true;
  24. }else{
  25. $this->dbError = false;
  26. }
  27. }
  28. public function authenticate($username, $password){
  29. $loginQuery = "SELECT AdminID, Username, Password, AdminLevel, Lastlogin FROM adminusers WHERE username = $username AND password = $password";
  30. $stmt = $this->mysqli->prepare($loginQuery);
  31. $stmt->bind_param('ss', $username, $password);
  32. $stmt->execute();
  33. $stmt->store_result();
  34.  
  35. $num_rows = $stmt->num_rows;
  36.  
  37. $stmt->bind_result($AdminID, $username, $password, $AdminLevel, $Lastlogin);
  38.  
  39. if($num_rows == 1){
  40. $this->username = $username;
  41. $this->password = $password;
  42. $this->authenticated = true;
  43. }
  44. $stmt->free_result();
  45. }
  46.  
  47. public function isAuthenticated(){
  48. return $this->authenticated;
  49. }
  50.  
  51. public function hasDbError(){
  52. return $this->dbError;
  53. }
  54. public function getUsername(){
  55. return $this->username;
  56. }
  57. }
  58. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement