<?php
class agente {
    public $servername = "localhost";
    public $username = "root";
    public $password = "XXXXX";
    public $dbname = "agentes";
    public $link;

    function __construct() {
        $this->link = mysqli_connect($this->servername, $this->username, $this->password);
        mysqli_select_db($this->link,$this->dbname) or die ("No database");
    }
    public function getUsers() {
            $sql = "SELECT id, nickname, status FROM users";
            $res = mysqli_query($this->link,$sql);
            $data = mysqli_fetch_array($res);
            echo "Id: " . $data["id"]. " - Nombre: " . $data["nickname"]. " " . $data["status"]. "<br>";
    }


    public function addUser($nick,$mail,$type = 0) {
        $sql = "INSERT users (nickname,mail,status) INTO ('$nick','$mail', '$type')";
        $res = mysqli_query($sql,$link) or die (mysqli_error());
        return true;
    }
    public function changeStatus($uid,$type) {
        $sql = "UPDATE users SET type = '$type' WHERE id = '$uid'";
        $res = mysqli_query($sql,$link) or die (mysqli_error());
        return true;

    }

}