Untitled

<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>
<form action="prihlaseni.php" method="POST">
<table>
	<label for="username">Uživatelské jméno</label>
	<input type="text" name="username" pattern= "[A-Za-z0-9]{4,20}$">
	<br>

	<label for="pass">Heslo</label>
	<input type="password" name="password" pattern= "[A-Za-z0-9]{4,20}$">
	<br>

	<input type="submit" name="submit" value="registrovat">
	</table>
	</form>
</body>
</html>
<?php
error_reporting((0));
		$username = $_POST["username"];
		$password = $_POST["password"];
		if (!empty($username) && !empty($password)){
		$link3 = mysql_connect("localhost", "root", "") or die("Nepovedlo se pripojit");
        $db3 = mysql_select_db("login", $link3) or die("Nepovedlo se otevrit databazi");
        echo $username."\n".$password;
        $query3 = "INSERT INTO prihlaseni(username, password)
					VALUES ($username,$password);"; //vkládání dat z php do db
        $result3 = mysql_query($query3, $link3) or die("Dotaz nelze provest");
    	}
//____________________________________________________________________________________________________

		$r  = rand(1, 9999);
		echo $r;
        $link2 = mysql_connect("localhost", "root", "") or die("Nepovedlo se pripojit");
        $db2 = mysql_select_db("login", $link2) or die("Nepovedlo se otevrit databazi");
        $query2 = "INSERT INTO prihlaseni (username, password)
					VALUES ($r , $r);"; //vkládání dat z php do db
        $result2 = mysql_query($query2, $link2) or die("Dotaz nelze provest");

//____________________________________________________________________________________________________

        $link = mysql_connect("localhost", "root", "") or die("Nepovedlo se pripojit");
        $db = mysql_select_db("login", $link) or die("Nepovedlo se otevrit databazi"); //načítá databázi do $query
        $query = "select * from prihlaseni";
        $result = mysql_query($query, $link) or die("Dotaz nelze provest"); //mysql_query provede prikaz "query" v db "link" a nacte do result

//INSERT INTO prihlaseni(username, password)
//VALUES ("test", "test");

            echo "\n<br>";
            echo "<table cellspacing='0' border = '1'>\n";
            echo "<tr><th>Username:</th><th>Password:</th></tr>\n";
            while ($row = mysql_fetch_array($result)) {
                echo "<tr><td>" . $row["username"] . "</td><td>" . $row["password"] . "</td></tr>\n";
            } //rikas tomu php: pridavej kazdy radek z mysql do polozky row, dokud nenactes vse
            echo "</table>";
            mysql_free_result($result);
            $randomCislo = rand(1, 9999);


        ?>