Untitled


<?php
session_start();

	$db = mysqli_connect('localhost', 'Linas', 'pass123', 'authentication');

	if (isset($_POST['login_btn'])) {
		$username = $_POST['username'];
		$password = $_POST['password'];

		$password = md5($password);
		$sql="SELECT * FROM users WHERE username ='$username' AND password ='$password'";
		$result = mysqli_query($db, $sql);

		if(mysqli_num_rows($result)==1){
			$_SESSION['message']="Jūs sekmingai prisijungėtė prie savo paskyros!";
			$_SESSION['username'] = $username;
			header("location: index.php");
		}else{
			$_SESSION['message']="Neteisingai ivestas vartotojo vardas arba slaptazodis!";
		}
		}
		?>


<!DOCTYPE html>
<html>
<head>
<title> Prisijungti</title>

</head>
<body>
<div class="header">
<h1> Prisijungti</h1>
</div>

<form method="post" action="login.php">
<table>
		<tr>
			<td>Username:</td>
			<td><input type="text" name="username" class="textinput"></td>
		</tr>

		<tr>
			<td>Password:</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>