<?php
/**
 * Created by PhpStorm.
 * User: mathias
 * Date: 27/03/2016
 * Time: 18:22
 */

include_once "db_config.php";
include_once "User.php";


class UserDAO
{

    public $cxn;

    public $newUser;

    /**
     * User constructor.
     */
    public function __construct()
    {
        $this->cxn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
    }

    //gaat
    public function check_login($uName, $pass)
    {
        $getUserQuery = mysqli_query($this->cxn, "SELECT * FROM users WHERE username = '$uName'");
        $getUser = mysqli_fetch_assoc($getUserQuery);
        extract($getUser);

        if ($password == md5($pass)) {
            $newUser = new User();
            $newUser->makeUser($user_id, $username, $email, $clientrights);
            return $newUser;
        }
        return null;
    }

    //gaat integer returnen met het aantal users in de database
    public function getTotalUsers()
    {
        $getAccountCountQuery  = mysqli_query($this->cxn, "SELECT COUNT(user_id) AS totalUsers FROM users");
        $getAccountCount = mysqli_fetch_assoc($getAccountCountQuery);
        extract($getAccountCount);
        return $totalUsers;
    }
}