echo 'jsi user';
        session_start();

        if (isset($_POST['login'])) {

            if (!empty($_POST['username']) && !empty($_POST['password'])) {
                $jmeno = $_POST['username'];
                $heslo = $_POST['password'];

                $t = $db->parseAndExecute("SELECT * FROM USERSS WHERE USERNAME ='" . $_POST['username']
                        . "' AND PASSWORD ='" . $_POST['password'] . "'");



                while (($row = oci_fetch_array($t, OCI_ASSOC + OCI_RETURN_LOBS)) != false) {

                    if (count($row) > 0) {
                    $dbusername = $row['USERNAME'];
                    $dbpassword = $row['PASSWORD'];
                    $dbgroup_id = $row['ADMIN'];
                    $dbemail = $row['EMAIL'];
                    //echo $dbusername;
                }

                    ?>

                    <form method="post" action="<?php echo $_SERVER['SCRIPT_NAME'] . '?' . $_SERVER['QUERY_STRING']; ?>">
                        <label for="id">Id:</label>
                        <input type="text" name="id_zmen2" value="<?php echo $row['ID'] ?>" onfocus="if (this.value ==<?php echo $row['ID'] ?>) {
                                    this.value = ''
                                }" onblur="if (this.value == '') {
                                            this.value = 'Vaše id'
                                        }" /><br/>
                        <label for="user">Jméno: </label>
                        <input type="text" name="user" value="<?php echo $row['USERNAME'] ?>" onfocus="if (this.value ==<?php echo $row['USERNAME'] ?>) {
                                    this.value = ''
                                }" onblur="if (this.value == '') {
                                            this.value = 'Vaše jméno'
                                        }"/><br/>
                        <label for="pass">Heslo: </label>
                        <input type="text" name="pass" value="<?php echo $row['PASSWORD'] ?>" onfocus="if (this.value == <?php echo $row['PASSWORD'] ?>) {
                                    this.value = ''
                                }" onblur="if (this.value == '') {
                                            this.value = 'Vaše heslo'
                                        }"/><br/>

                        <input type="submit" value="Změnit uživatelské údaje" name="zmen2"/><br/>
                    </form><br/>
                    <?php
                }

                if ($jmeno == $dbusername) {
                session_start();
                $_SESSION['admin'] = $dbgroup_id;
                $_SESSION['session_username'] = $username;
                $_SESSION['user_email'] = $dbemail;
                //echo $username;
            }
            }
        }
        ?>