<?php

/**
 * Created by PhpStorm.
 * User: jk
 * Date: 01.10.2017
 * Time: 15:59
 */
class connect_db
{
    protected $connect;

    public function __construct()
    {
        $host = 'localhost';
        $login = 'root';
        $pass = 'root';
        $db = 'lekcja';

        $this->connect = new mysqli($host, $login, $pass, $db);

        if (!$this->connect->connect_error) {

        } else {
            print_r($this->connect->connect_error);
        }
    }

    public function checkUser($email, $pass)
    {
        $sql = "SELECT COUNT(*) FROM user    WHERE email = '$email' and pass='$pass'";

        $query = $this->connect->query($sql);
        $row = mysqli_fetch_row($query);
        return $row[0];

    }
    public function idUser($email){
        $sql = "SELECT id FROM user  WHERE email = '$email'";

        $query = $this->connect->query($sql);
        $row = mysqli_fetch_row($query);
        return $row[0];
    }
    public function nameUser($email){
        $sql = "SELECT login FROM user   WHERE email = '$email'";

        $query = $this->connect->query($sql);
        $row = mysqli_fetch_row($query);
        return $row[0];
    }
}