<?php

//name of host
$sql_hostname = 'sql412.your-server.de';
//username
$sql_username = 'magnususer';
//password
$sql_password = 'cdbHC8nP3Cd96CQ1';
//database name
$sql_database = 'Magnus';

$db = mysq_connect ($sql_hostname, $sql_username, $sql_password);
mysql_select_db($sql_database, $db);

if(isset($_POST['submit']))
{
 $uname = mysql_escape_string($_POST['uname']);
 $pass = mysql_escape_string($_POST['pass']);
 $pass = md5($pass);

 $check = mysql_query("SELECT * FROM `users` WHERE `uname` = '$uname' AND `pass` = '$pass'");
 if(mysql_num_rows($check) >= 1){
  echo "You are logged!";
  exit();
 }
 else{

  echo "Wrong password";
 }
}
else{

 $form = <<<EOT
 <form action="login.php" method="POST">
 Username: <input type="text" name="uname"><br>
 Password: <input type="password" name="pass"><br>
 <input type="submit" name="submit" value="Log in">

EOT;

echo $form;
}
?>