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

namespace volucri;

include_once "db_config.php";


class User
{

    public $cxn;

    public $userID, $userName, $clientRights;

    /**
     * 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)) {
            $this->userID = $user_id;
            $this->userName = $username;
            $this->clientRights = $clientrights;
            return true;
        }
        return false;
    }

    //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;
    }
}