<?php


require_once '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_user_pass($un, $pwd)
	{
		$query = "SELECT * FROM Users WHERE Username = ? AND Password = ? LIMIT 1";

		if($stmt = $this->conn->prepare($query))
		{
			$stmt->bind_param('ss', $un, $pwd);
			$stmt->execute();

			if($stmt->fetch())
			{
				$stmt->close();
				return true;
			}
		}
	}
}
?>