<?php
    include 'connector.php';
    $conn = new connector("root","","jedzenie");
    $login = $_POST['login'];
    $haslo = $_POST['password'];
    $hashlo = sha1($haslo);
    $sql = "SELECT password FROM users WHERE login = '$login'";
    $query = $conn->query($sql);
    $wynik=$query->fetch_assoc();
    $wynik = $wynik['password'];
    if($wynik==$hashlo)
    {
    echo "haslo poprawne";
    setcookie('log','logged');
    $sql1 = "SELECT id_us FROM users WHERE login = '$login'";
    $query = $conn->query($sql1);
    $wynik = $query->fetch_assoc();
    $wynik = $wynik['id_us'];
    $sql2 = "INSERT INTO sesje (sessionid,id_us,state) VALUES ('".$_COOKIE['PHPSESSID']."','".$wynik."','".$_COOKIE['log']."')";
    $query = $conn->query($sql2);
    header("location: indeks.php?remarks=success");
    }
    else
    echo "haslo niepoprawne";
?>