<?php

// obtaining login info
require("info.php");

// connecting to server
$connect = mysql_connect("$host","$user","$pass");
if (!$connect){
die('Could not connect to server: ' . mysql_error());
}

// selecting database

//mysql_select_db($database, $connect);

if (!mysql_select_db($database, $connect)){
die('Unable to select database: ' . mysql_error());
}

// obtaining user input

$input_username = mysql_real_escape_string($_POST["username"]);
$input_password = md5(mysql_real_escape_string($_POST["password"]));

// checking user input versus records

$stored_password = mysql_fetch_assoc(mysql_query("SELECT password FROM
users WHERE username = \"$input_username\"));

if(!$stored_password){
die('Unable to select table: '. mysql_error());
}

if ($stored_password != $input_password){
print'The password does not match, please try again';
}

else{
session_start();
print'U bent nu ingelogd';
mysql_close($connect);
}

?>