id     name     email                 pasword
 1     andrew   email@example.com     hashed password
 2     mike     email2@example.com    hashed password

class Database {
private $host = DB_HOST;
private $user = DB_USER;
private $pass = DB_PASS;
private $dbname = DB_NAME;

private $dbh;
private $error;
private $stmt;

public function __construct() {
    // Set DSN
    $dsn = 'mysql:host=' . $this->host . ';dbname=' . $this->dbname;
    // Set options
    $options = array (
            PDO::ATTR_PERSISTENT => true,
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    );
    // Create a new PDO instanace
    try {
        $this->dbh = new PDO ($dsn, $this->user, $this->pass, $options);
    }       // Catch any errors
    catch ( PDOException $e ) {
        $this->error = $e->getMessage();
    }
}


public function query($query) {
    $this->stmt = $this->dbh->prepare($query);
}


public function bind($param, $value, $type = null) {
    if (is_null ( $type )) {
        switch (true) {
            case is_int ( $value ) :
                $type = PDO::PARAM_INT;
                break;
            case is_bool ( $value ) :
                $type = PDO::PARAM_BOOL;
                break;
            case is_null ( $value ) :
                $type = PDO::PARAM_NULL;
                break;
            default :
                $type = PDO::PARAM_STR;
        }
    }
    $this->stmt->bindValue ( $param, $value, $type );
}


public function execute(){
    return $this->stmt->execute();
}


public function resultset(){
    $this->execute();
    return $this->stmt->fetchAll(PDO::FETCH_OBJ);
}



public function single(){
    $this->execute();
    return $this->stmt->fetch(PDO::FETCH_OBJ);
}


public function rowCount(){
    return $this->stmt->rowCount();
}

public function login($email){
    $this->db->query("SELECT * FROM users
                                WHERE email = :email
    ");

    //Bind Values
    $this->db->bind(':email', $email);
    $row = $this->db->single();

    //Check Rows
    if($this->db->rowCount() > 0){
        $this->setUserData($row);
        return true;
    } else {
        return false;
    }

}
public function bringpassword($email1){
    $this->db->query("SELECT pasword FROM users
                                WHERE email = :email
    ");
     $this->db->bind(':email',$email1);
     $results = $this->db->resultset();
     while($r = $results){
        $results=$r["pasword"];
        return $results;
     }

}

$email=$_POST['user_email3'];
$user= new User;
    $password1 = $_POST['user_password2'];
    $hash = $user->bringpassword($email);
        if($user->login($email) && strlen($_POST['user_password2'])>5 && password_verify($password1, $hash)){
         $_SESSION['loggedin'] = true;
         $_SESSION['username'] = $username;
         $_SESSION["email"]=$emailc;
         redirect('index.php');
        }else{
            echo $hash;
            redirect('register.php','The email and password combination  is incorrect!', 'error1');

    }