<?php

class Model
{
    private $databaseConnection;

    public $message = "";
    public $usernameVariable = "";

    public function __construct()
    {
        $this->databaseConnection = mysqli_connect(ServerConfig::$dbServerName, ServerConfig::$dbUsername, ServerConfig::$dbPassword, ServerConfig::$dbName);
    }

    public function usernameExist($username)
    {
        $sqlSearchString = "SELECT * FROM users WHERE BINARY user_username='$username';";

        $result = mysqli_query($this->databaseConnection, $sqlSearchString);

        // If user was found, result is larger than 0
        $resultCheck = mysqli_num_rows($result);
        if ($resultCheck > 0) {
            return true;
        }
    }

    public function saveUserToDb($username, $password)
    {
        $passwordHash = password_hash($password, PASSWORD_BCRYPT);
        $cookiePasswordHash = password_hash($password, PASSWORD_BCRYPT);

        $sqlSearchString = "INSERT INTO users (user_username, user_pwd, user_cookiePassword) VALUES ('$username', '$passwordHash', '$cookiePasswordHash');";
        mysqli_query($this->databaseConnection, $sqlSearchString);
    }

    private function getUser($username)
    {
        $sqlSearchString = "SELECT * FROM users WHERE BINARY user_username='$username';";

        $result = mysqli_query($this->databaseConnection, $sqlSearchString);

        // If user was found, result is larger than 0
        $resultCheck = mysqli_num_rows($result);
        if ($resultCheck > 0) {
            return mysqli_fetch_assoc($result);
        }
    }

    public function verifyPassword($username, $password)
    {
        $databaseUser = $this->getUser($username);

        return password_verify($password, $databaseUser['user_pwd']);
    }
}