<?php 
class User {
	public $dbh;
	
	public function __construct($db_handle) { 
		$this->dbh = $db_handle; 
	} 

	public function showUsers() {
		$sql = "SELECT * FROM users";
		$result = $this->dbh->query($sql);
		foreach ($result as $row) {
			var_dump($row);
		}
    }
	
	public function getUser($username, $password) {
		$sql = "SELECT * FROM users WHERE username = ? and password = ?";
		$stmt = $this->dbh->prepare($sql);
		$stmt->bindParam(1, $username);
		$stmt->bindParam(2, $password);
		$stmt->execute();
		$result = $stmt->fetch(PDO::FETCH_OBJ);
		return $result;
    }
}
?>