<?php

include_once 'index8.php';

$connect = new mysqli ($host, $dbuser, $dbpass, $dbname);

if ($connect->connect_errno!=0) {
    echo "BŁĄD " . $connect_errno();
}
else
{
$login = $_POST['login'];
$password = $_POST['pass'];

$sql = "SELECT * FROM users WHERE uzytkownik='$login' AND haslo='$password'";
    if($rezultat = $connect->query($sql)) {
        $ilu_uzytkownikow = $rezultat->num_rows;
        if ($ilu_uzytkownikow>0){
            $wiersz = $rezultat->fetch_assoc();
            $user = $wiersz['login'];


            header('Location: mainpage.php');
        }
    }
$connect->close();
}
?>