<?php

  class DB {
    private $db;
    private $database = "pwi";
    private $host = "localhost";
    private $username = "root";
    private $password = "";


    public function __construct(){
      $this->db = mysqli_connect($this->host,
                                 $this->username,
                                 $this->password,
                                 $this->database);

      if(mysqli_connect_errno()){
        echo "Błąd połączenia z bazą danych";
        die();
      }
    }

    public function myquery($query){
      mysqli_query($this->db, $query);
    }

    public function query($query){
      $result = mysqli_query($this->db, $query);
      $tab = array();
      while($row = mysqli_fetch_array($result)){
        $tab[] = $row;
      }
      return $tab;
    }

    public function getUserId($username){
      $query = "SELECT * FROM users WHERE username=\"$username\"";
      $tab = $this->query($query);
      return $tab[0]['id'];
    }
  }

  ?>