Untitled

<?php

		session_start();
		$_SESSION['message'] = "";
		$mysqli = new mysqli("localhost", "root", "", "accounts") or die ("Cannot connect");
    $sql = "SELECT `id`, `username`, `email`, `password` FROM `users`";

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

    while ($row = mysqli_fetch_array($query)) {
      $_SESSION['id'] = $row['id'];
      $_SESSION['username'] = $row['username'];
      $_SESSION['email'] = $row['email'];
      $password = $row['password'];
     }

  	$formusername = $mysqli->real_escape_string($_POST['username']);
    $formpassword = $mysqli->real_escape_string($_POST['password']);

    if ($formusername == $_SESSION['username'] && $password == $formpassword) {
      echo "Sisäänkirjautuminen onnistui";
    }else{
      echo $_SESSION['username'];
      echo "<br>";
      echo $_SESSION['email'];
    }

?>
<!DOCTYPE html>
<html lang="fi">
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1">

		<title>HD Finland</title>


	<link href="css/bootstrap.css" rel="stylesheet">
	<link href="carousel.css" rel="stylesheet">
	<link href="style.css" rel="stylesheet">

	</head>
	<body>

	<div class="navbar-wrapper">
			<div class="container">

				<nav class="navbar navbar-inverse navbar-static-top">
					<div class="container">
						<div class="navbar-header">
							<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
								<span class="sr-only">Toggle navigation</span>
								<span class="icon-bar"></span>
								<span class="icon-bar"></span>
								<span class="icon-bar"></span>
							</button>
							<a class="navbar-brand" href="index.php">HD Finland</a>
						</div>
						<div id="navbar" class="navbar-collapse collapse">
							<ul class="nav navbar-nav">
								<li class="dropdown">
									<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Genret <span class="caret"></span></a>
									<ul class="dropdown-menu">
										<li><a href="#">Animaatio</a></li>
										<li><a href="#">Dokumentti</a></li>
										<li><a href="#">Draama</a></li>
										<li><a href="#">Fantasia</a></li>
										<li><a href="#">Kauhu</a></li>
										<li><a href="#">Komedia</a></li>
										<li><a href="#">Länkkäri</a></li>
										<li><a href="#">Scifi</a></li>
										<li><a href="#">Seikkailu</a></li>
										<li><a href="#">Sota</a></li>
										<li><a href="#">Toiminta</a></li>
										<li><a href="#">Trilleri</a></li>
									</ul>
								</li>
								<li><a href="#">Tietoa meistä</a></li>
								<form class="navbar-form navbar-left" action="search.php" method="GET">
									<div class="form-group">
										<input name="keyword" type="text" class="form-control" placeholder="Hae elokuvia...">
									</div>
									<button type="submit" class="btn btn-default">Hae</button>
								</form>
							</ul>
						</div>
					</div>
				</nav>


						<div class='row'>
											<form class='form-signin loginform' action='login.php' method='POST'>
												<span id='reauth-email' class='reauth-email'></span>

												<label for='name' class='cols-sm-2 control-label'>Käyttäjänimi</label>
													<input type='text' id='inputEmail' name='username' class='form-control inputbottom' placeholder='Anna käyttäjänimesi' required autofocus>

												<label for='name' class='cols-sm-2 control-label'>Salasana</label>
													<input type='password' id='inputPassword' name='password' class='form-control inputbottom' placeholder='Anna salasanasi' required>


													<button class='btn btn-lg btn-primary btn-block btn-signin' type='submit'>Kirjaudu sisään</button>
													<a href='#' class='forgot-password'>Salasana unohtunut?</a>
											</form>
											<div class='loginerror'>
												<?= $_SESSION['message']?>
											</div>
									</div>


			</div>
		</div>
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
		<script src="js/bootstrap.js"></script>
	</body>
</html>