<?php

$stranka="login.php";
if (isset($_GET['jazyk']))
    {
    $jazyk=$_GET['jazyk'];
    }
    else
    {
        $jazyk="1";
        }
$lang = $_GET['lang'];

switch ($lang)
{
    case '1':
    $jazyk="1";
    break;

    case '2':
    $jazyk="2";
    break;

    case '3':
    $jazyk="3";
    break;

}

$znamenko="#";
$soubor=fopen("soubor.txt", "w");
$db = mysql_connect("localhost","root", "");
if (!$db)
  {
    die('Could not connect: ' . mysql_error());
  }
mysql_select_db("grenja10it");

$vysledek = mysql_query("SELECT * FROM tbl_web where stranka='login.php' and jazyk_ID='$jazyk' order by

'poradi' ", $db);
while ($zaznam = mysql_fetch_array($vysledek) ):
$text= $zaznam['text'] .$znamenko;
fwrite($soubor, $text);
endwhile;
$soubor = fopen("soubor.txt", "r");
$texts = fread($soubor, 60);
fclose($soubor);
  list($text1, $text2, $text3, $text4, )=explode("#", $texts);


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

$vysledek1 = mysql_query("SELECT * FROM tbl_osoba where username='$username'") ;
while ($zaznam1 = mysql_fetch_array($vysledek1) ):
$username2= $zaznam1['username'];

$vysledek2 = mysql_query("SELECT * FROM tbl_osoba where password='$password'") ;
while ($zaznam2 = mysql_fetch_array($vysledek2) ):
$password= $zaznam2['password'];
echo $username2;


?>

<a href="login.php?lang=3"  name="de">
<img src="de.gif" height="30" widht="20" align="right">
</a>
<a href="login.php?lang=2"  name="en">
<img src="en.jpg" height="30" widht="20" align="right">
</a>
<a href="login.php?lang=1"  name="cz">
<img src="cz.gif" height="30" widht="20" align="right">
</a>
<br>


<table border="5" align="center" cellpadding="5" bgcolor="gray">
<tr><td align="center">
<?php echo $text1;?>
</td></tr>
<tr><td align="center">
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" align="center">
<input type="hidden" value="<?php echo $jazyk;?>" name="jazyk" size="0">
<br><?php echo $text2;?>
<input type="text"   name="username" size="10">
<br><?php echo $text3;?>
<input type="password" name="password" size="10">
<br>
<input type="submit" value="<?php echo $text4;?>" name="send">
</form>
</td></tr>
<tr><td align="center">
<a href="registrace.php">
</a>
</td></tr>
</table>

<?php
if ($username == $username2 and $passwordhash == $password2) {
     echo "jsi prihlasen<br>";
    session_start();
    $_SESSION['user'] = "$user";
    }
    else
    {
    echo "spatne zadane udaje";
    }

?>