Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.71 KB | None | 0 0
  1. <?php
  2. require_once("includes/DbConnector.class.php");
  3. require_once("includes/Sanitizer.class.php");
  4. session_start();
  5. if (isset($_SESSION['logged']) && $_SESSION['logged'] == 1) {
  6. header("location:admin.php");
  7. }
  8. if (isset($_POST['username']) && isset($_POST['password'])) {
  9. $username = $_POST['username'];
  10. $password = $_POST['password'];
  11. $username = html_sanitize($username);
  12. $password = html_sanitize($password);
  13. $DbConnector = new DbConnector();
  14. $DbConnector->DbConnector();
  15. $login_query = $DbConnector->query("SELECT * FROM credentials WHERE username = ".$username." AND password = ".$password.";");
  16. $login_result = $DbConnector->fetchObject($login_query);
  17. $login_count = $DbConnector->count($login_query);
  18.     if ($login_count == 1) {
  19.     $_SESSION['cred_id'] = $login_result->cred_id;
  20.     $_SESSION['role'] = $login_result->role;
  21.     $_SESSION['logged'] = 1;
  22.     header("location:admin.php");
  23.     }
  24. }
  25. ?>
  26. <html>
  27. <head>
  28. <title>Log in to ACL</title>
  29. </head>
  30. <body>
  31. <h1>WELCOME TO ACL</h1>
  32. <form name="login" method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
  33. <fieldset>
  34. <legend>Insert your login credentials</legend>
  35. <p><label for="username">Username:</label><br/> <input type="text" name="username" /></p>
  36. <p><label for="password">Password:</label><br/> <input type="password" name="password" /></p>
  37. <p class="submit"><input type="submit" value="LOG IN" name="submit" /></p>
  38. </fieldset>
  39. </form>
  40. </body>
  41. </html>
  42.  
  43.  
  44.  
  45.  
  46. ------------------------
  47. <?php
  48. ////////////////////////////////////////////////////////////////////////////////////////
  49. // Class: DbConnector
  50. // Purpose: Connect to a database, MySQL version
  51. // Author: Sotiris K.
  52. ///////////////////////////////////////////////////////////////////////////////////////
  53. require_once 'SystemComponent.class.php';
  54.  
  55. class DbConnector extends SystemComponent {
  56.  
  57.     var $theQuery;
  58.     var $link;
  59.     var $result;
  60.     var $fetch;
  61.     var $count;
  62.  
  63.     function DbConnector(){
  64.    
  65.         $settings = SystemComponent::getSettings();
  66.  
  67.         $host = $settings['dbhost'];
  68.         $db = $settings['dbname'];
  69.         $user = $settings['dbusername'];
  70.         $pass = $settings['dbpassword'];
  71.    
  72.         $this->link = mysql_connect($host, $user, $pass);
  73.         mysql_select_db($db);
  74.         register_shutdown_function(array(&$this, 'close'));
  75.     }
  76.  
  77.     function query($query) {
  78.  
  79.         $this->theQuery = $query;
  80.         $this->result = mysql_query($query, $this->link);
  81.         return $this->result;
  82.     }
  83.  
  84.     function fetchObject($result) {
  85.         $result = $this->result;
  86.         $this->fetch = mysql_fetch_object($result);
  87.         return $this->fetch;
  88.     }
  89.    
  90.     function count($result) {
  91.         $result = $this->result;
  92.         $this->count = mysql_num_rows($result);
  93.         return $this->count;
  94.     }
  95.  
  96.     function close() {
  97.  
  98.         mysql_close($this->link);
  99.  
  100.     }
  101. }
  102. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement