Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require 'Mysql.php';
- class Membership {
- function validate_user($un, $pwd) {
- $mysql = New Mysql();
- $ensure_credentials = $mysql->verify_Username_and_Pass($un, $pwd);
- if($ensure_credentials) {
- $_SESSION['status'] = 'authorized';
- header("location: index.php");
- } else return "Please enter a correct username and password";
- }
- function log_User_Out() {
- if(isset($_SESSION['status'])) {
- unset($_SESSION['status']);
- if(isset($_COOKIE[session_name()]))
- setcookie(session_name(), '', time() - 1000);
- session_destroy();
- }
- }
- function confirm_Member() {
- session_start();
- if($_SESSION['status'] !='authorized') header("location: login.php");
- }
- }
- require_once 'includes/constants.php';
- class Mysql {
- private $conn;
- function __construct() {
- $this->conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or
- die('There was a problem connecting to the database.');
- }
- function verify_Username_and_Pass($un, $pwd) {
- $query = "SELECT *
- FROM members
- WHERE usr = ? AND pass = ?
- LIMIT 1";
- if($stmt = $this->conn->prepare($query)) {
- $stmt->bind_param('ss', $un, $pwd);
- $stmt->execute();
- if($stmt->fetch()) {
- $stmt->close();
- return true;
- }
- }
- }
- }
- <?php
- require_once 'classes/Membership.php';
- require_once 'includes/constants.php';
- $membership = New Membership();
- $membership->confirm_Member();
- session_start();
- if (isset($_SESSION['username']));
- $username = $_SESSION['username'];
- $dbc = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME);
- $query = "SELECT email FROM members";
- $result = mysqli_query($dbc, $query);
- $row = mysqli_fetch_array($result);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement