server2.php

<?php
    session_start();
    $errors = array();

// connect to database
$db = mysqli_connect('localhost', 'st2014', 'progress', 'st2014');
//echo "db - " . $db;

if ($db->connect_error) {
    die("Ühendamine andmebaasiga nurjus: " . $db->connect_error);
}
// LOGIN USER
 if (isset($_POST['logInButton'])) {
    $username = mysqli_real_escape_string($db, $_POST['username']);
    $psw = mysqli_real_escape_string($db, $_POST['psw']);

    if ($username == "") {
        array_push($errors, "Kasutajanimi on kohustuslik väli!");
    }
    if ($psw == "") {
        array_push($errors, "Parool on kohustuslik väli!");
    }

    if (count($errors) == 0) {
        //$password = md5($psw);
        $sql = "SELECT * FROM t172500_users WHERE username = '$username' AND psw = '$psw'";
        $results = mysqli_query($db, $sql);

        if (mysqli_num_rows($results) == 1) {

        header('location: index.php');
        }else {
            echo "Vale kasutajanime ja parooli seos!";
        }

    }
}
?>