Untitled

<?php
	session_start();

	// verbindung zur Datenbank

	$db = mysqli_connect("localhost", "ni591839_4sql1", "huhn1mw3lt4ll", "ni591839_4sql1");
	if (isset($_POST['login_btn'])) {
		$username = mysql_real_escape_string($_POST['username']);
		$password = mysql_real_escape_string($_POST['password']);

		$password = md5($password);  // Erneute verschlüsselung des Passworts nach der Variante md5 zum Vergleich mit der Datenbank
		$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
		$result = mysqli_query($db, $sql);

		if (mysqli_num_rows($result) == 1) {
			$_SESSION['message'] = "Sie sind nun eingeloggt.";
			$_SESSION['username'] = $username;
			header("location: home.php"); //Weiterleitung zur Hauptseite
		} else {
			$_SESSION['message'] = "Nutzername / Passwort ist inkorrekt.";
		}
	}
?>

<html>
<head>
	<title>Aperture-Laboratories.eu</title>
	<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div class="header">
	<h1>Aperture-Laboratories.eu Login</h1>
</div>

<form method="post" action="login.php">
	<table>
		<tr>
			<td>Nutzername:</td>
			<td><input type="text" name="username" class="textInput"></td>
		</tr>
		<tr>
			<td>Passwort:</td>
			<td><input type="password" name="password" class="textInput"></td>
		</tr>
		<tr>
			<td></td>
			<td><input type="submit" name="login_btn" value="Login"></td>
		</tr>
	</table>
</form>
</body>
</html>