Untitled

<?php

/* include "php/connect.php";připojení k databázi */
$host="localhost";
$db_username="root";
$db_password="root";
$db_name="zend_db";


$connection = mysqli_connect("$host", "$db_username", "$db_password") or die('Could not connect: ' . mysqli_error());

mysqli_select_db($connection, $db_name)or die("cannot select DB");

$username = mysqli_real_escape_string($connection,$_POST['username']);
$password = mysqli_real_escape_string($connection,$_POST['user-password']);
$password2 = mysqli_real_escape_string($connection,$_POST['user-password-2']);
$user_avatar = mysqli_real_escape_string($connection,$_POST['user-avatar']);
$first_name = mysqli_real_escape_string($connection,$_POST['first-name']);
$second_name = mysqli_real_escape_string($connection,$_POST['second-name']);

$password = md5($password);
$password2 = md5($password2);

$sql_user_check = "SELECT username FROM user WHERE username='".$username."'";
$user_check = mysqli_query($connection,$sql_user_check);
?>

<!doctype html>
<html>
<head>
    <title>Zend</title>
    <link rel="stylesheet" type="text/css" href="style.css" />
    <meta charset="UTF-8" />
    <meta name="author" content="Lucie Opravilová" />
    <meta name="keywords" content="inf, zend, css, html" />
    <meta name="description" content="Zápočtová úloha do INFS" />

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>

    <script src="js/arrow.js"></script>
    <script src="js/autocomplete.js"></script>

</head>

<body>
    <div id="stranka">
        <?php include 'php/header.php';?>

        <main id="panely">
            <article id="levy-panel">


                <form action="#" method="post">
                    <fieldset class="name-email">
                        <label for="username" >Username</label>
                        <input type="text" name="username" id="username"  autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="first-name" >First name</label>
                        <input type="text" name="first-name" id="first-name"  autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="second-name" >Second name</label>
                        <input type="text" name="second-name" id="second-name" autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="user-password" >Password</label>
                        <input type="password" name="user-password" id="user-password"  autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="user-password-2" >Password</label>
                        <input type="password" name="user-password-2" id="user-password-2" autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="user-email">Email</label>
                        <input type="email" name="user-email" id="user-email"  placeholder="@" autofocus required >
                    </fieldset>

                    <fieldset class="name-email">
                        <label for="user-avatar">Avatar</label>
                        <input type="file" name="user-avatar" id="user-avatar" autofocus required >
                    </fieldset>

                    <input type="submit" formnovalidate name="registration-submit" id="registration-submit" value="Registration">

                  </form>


            </article>

            <aside id="pravy-panel">
                <?php include 'php/aside-small.php';?>
            </aside>

            <div class="clearfix"></div>
        </main>

        <footer>
            <?php include 'php/footer.php'; ?>
        </footer>
    </div>
</body>
</html>