<?php
if($_POST['submit'])
{
$host="localhost"; // Host name
$username="np70170_jaamak"; // Mysql username
$password="F7mAlbQe"; // Mysql password
$db_name="np70170_jaamak"; // Database name
$tbl_name="kasutajad"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("Ei suuda ühenduda !");
mysql_select_db("$db_name")or die("Ei suuda valida databaasi !");

// username and password sent from form
$username=$_POST['kasutaja'];
$password=$_POST['pass'];

$sql="SELECT * FROM $tbl_name WHERE kasutaja='$username' and pass='$password'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
session_register("username");
session_register("password");
echo "<font color=white>Suuname kohe edasi!";
header("Location: avaleht.php"); // Suuname lehele avaleht.php kolme sekundiga.
}
else {
echo "<font color=red>Vale kasutajanimi või parool!";
}
}
else {
echo "";
}
?>
<hr></hr>
<form action="avaleht.php" method="post">
Kasutajanimi: <input name="kasutaja"><br>
Parool: <input type="password" name="pass"><br><br>
<input type="submit" name="submit" value="Logi sisse"></form>