<?php

		session_start();
		$_SESSION['message'] = "";
		$mysqli = new mysqli("localhost", "root", "", "accounts") or die ("Cannot connect");
		if ($_SERVER['REQUEST_METHOD'] == 'POST') {

			$fusername = $mysqli->real_escape_string($_POST['username']);
		    $fpassword = $mysqli->real_escape_string($_POST['password']);

		    if (empty($fusername) && empty($fpassword)) {
		    	$_SESSION['message'] = "Syötä käyttäjätieodt";
		    }else{
		    	$sql = "SELECT `id`, `username`, `email`, `password`, `active` FROM `users` WHERE username = '$fusername' AND password = '$fpassword'";

			    $query = mysqli_query($mysqli, $sql);

			    $count = mysqli_num_rows($query);

			    if ($count > 0) {
			    	while($row = mysqli_fetch_array($query)){
			    	$_SESSION['username'] = $row['username'];
			    	$_SESSION['email'] = $row['email'];
			    	$_SESSION['id'] = $row['id'];
			    	$active = $row['active'];

				    	if ($active > 0) {
				    		$_SESSION['message'] = "Sisäänkirjautuminen onnsitui, sinut ohjataan takasin etusivulle.";
				    		sleep(2);
				    		header("location: index.php");
				    	}else{
				    		$_SESSION['message'] = "Tiliäsi ei ole aktovoitu.";
				    	}
			    	}
			    }else{
			    	$_SESSION['message'] = "Väärä käyttäjänimi tai salasana.";
			    }
		    }
  		}

?>