Advertisement
Guest User

Untitled

a guest
Feb 28th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. require 'Mysql.php';
  2.  
  3. class Membership {
  4.  
  5. function validate_user($un, $pwd) {
  6. $mysql = New Mysql();
  7. $ensure_credentials = $mysql->verify_Username_and_Pass($un, $pwd);
  8.  
  9. if($ensure_credentials) {
  10. $_SESSION['status'] = 'authorized';
  11. header("location: index.php");
  12. } else return "Please enter a correct username and password";
  13.  
  14. }
  15.  
  16. function log_User_Out() {
  17. if(isset($_SESSION['status'])) {
  18. unset($_SESSION['status']);
  19.  
  20. if(isset($_COOKIE[session_name()]))
  21. setcookie(session_name(), '', time() - 1000);
  22. session_destroy();
  23. }
  24. }
  25.  
  26. function confirm_Member() {
  27. session_start();
  28. if($_SESSION['status'] !='authorized') header("location: login.php");
  29. }
  30.  
  31. }
  32.  
  33. require_once 'includes/constants.php';
  34.  
  35. class Mysql {
  36. private $conn;
  37.  
  38. function __construct() {
  39. $this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or
  40. die('There was a problem connecting to the database.');
  41. }
  42.  
  43. function verify_Username_and_Pass($un, $pwd) {
  44.  
  45. $query = "SELECT *
  46. FROM members
  47. WHERE usr = ? AND pass = ?
  48. LIMIT 1";
  49.  
  50. if($stmt = $this->conn->prepare($query)) {
  51. $stmt->bind_param('ss', $un, $pwd);
  52. $stmt->execute();
  53.  
  54. if($stmt->fetch()) {
  55. $stmt->close();
  56. return true;
  57. }
  58. }
  59.  
  60. }
  61. }
  62.  
  63. <?php
  64.  
  65. require_once 'classes/Membership.php';
  66. require_once 'includes/constants.php';
  67. $membership = New Membership();
  68.  
  69. $membership->confirm_Member();
  70. session_start();
  71.  
  72. if (isset($_SESSION['username']));
  73. $username = $_SESSION['username'];
  74. $dbc = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME);
  75. $query = "SELECT email FROM members";
  76. $result = mysqli_query($dbc, $query);
  77. $row = mysqli_fetch_array($result);
  78. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement