<?php

session_start();

require_once('connection.php');

$connection= new mysqli($host, $dbUser,$password,$dbName);

if($connection->connect_errno){
    echo "Cannot connect to db";
}else{

    $username= $_POST['username'];
    $password=$_POST['password'];

    $query= "SELECT * FROM users WHERE login='$username' AND password='$password' ";
    $result=$connection->query($query);

        if ($result->num_rows != 0) {
            $_SESSION['logged']=true;
            $data = $result->fetch_assoc();
            $_SESSION['id']= $data['id'];
            $_SESSION['login'] = $data['login'];

            unset($_SESSION['wrongLogging']);
            $result->close();
            header('Location: logged.php');
        }else{
            $_SESSION['wrongLogging']='<span style="color:red; margin-left: 42.5%; font-weight: bold;">Wrong login or password</span>';
            header('Location:login.php');
        }




    $connection->close();
}




?>