<?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 username
				FROM users
				WHERE username = ? AND password = ?
				LIMIT 1";

		if($stmt = $this->conn->prepare($query)) {
			$stmt->bind_param('ss', $un, $pwd);
			$stmt->execute();
			$stmt->bind_result($fetched_user_;
			if($stmt->fetch()) {
				$stmt->close();
				return true;
			}
		}
		return false;
	}
}