Untitled

<?php

    $error = null;
    $success = false;

    if (isset($_GET['submitButton'])) {

        $servername = "localhost";
        $username = "root";
        $password = "";
        $dbname = "php_vaje";

        // Create connection
        $conn = new mysqli($servername, $username, "", $dbname);
        // Check connection
        if ($conn->connect_error) {
            $error = "Mysql base is not running, please try again later.";
        }

        if ($error === null) {
            $name           = $_GET['nameBox'];
            $password       = $_GET['passwordBox'];
            $passwordRepeat = $_GET['passwordBox2'];

            $sql = "SELECT ID FROM uporabnik WHERE name='$name'";
            $result = $conn->query($sql);

            if ($result->num_rows > 0) {
                $error = "This username is already taken.";
            }

            if ($password !== $passwordRepeat) {
                if ($error !== null) {
                    $error .= "<br />Passwords do not match.";
                }
                else {
                    $error = "Passwords do not match.";
                }
            }

            if ($error === null) {
                $sql = "INSERT INTO uporabnik (name, password) VALUES ('$name', '$password')";

                if ($conn->query($sql) === TRUE) {
                    $success = true;
                } else {
                    $error = "Something went wrong, please try again later.";
                }
            }

            $conn->close();
        }
    }

?>

<!DOCTYPE html>
<html>
    <head>
        <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>

        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.2/css/bootstrap.min.css" integrity="sha384-Smlep5jCw/wG7hdkwQ/Z5nLIefveQRIY9nfy6xoR1uRYBtpZgI6339F5dgvm/e9B" crossorigin="anonymous">
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.2/js/bootstrap.min.js" integrity="sha384-o+RDsa0aLu++PJvFqy8fFScvbHFLtbvScb8AjopnFD+iEQ7wo/CG0xlczd+2O/em" crossorigin="anonymous"></script>

        <title>Register page</title>
    </head>
    <body>
        <div class="row">
            <div class="offset-lg-5 col-lg-2 offset-2 col-8">
                <div class="card mt-5">
                    <div class="card-body">

                        <?php
                            if($success) {
                                include 'userLogin.php';
                       ?>
                            <div class="alert alert-success" role="alert">
                                Thank you for registering!

                            </div>
                        <?php
                            }
                            else {
                        ?>

                            <?php
                                if($error !== null) {
                            ?>
                                <div class="alert alert-danger" role="alert">
                                    <?php echo $error ?>
                                </div>
                            <?php
                                }
                            ?>

                            <form action="register.php" method="get">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Username</label>
                                    <input name="nameBox" type="text" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Username" required>
                                </div>
                                <div class="form-group">
                                    <label for="exampleInputPassword1">Password</label>
                                    <input name="passwordBox" type="password" class="form-control" id="exampleInputPassword1" placeholder="Password" required>
                                </div>
                                <div class="form-group">
                                    <label for="exampleInputPassword1">Repeat password</label>
                                    <input name="passwordBox2" type="password" class="form-control" id="exampleInputPassword1" placeholder="Repeat password" required>
                                </div>
                                <center>
                                    <button name="submitButton" type="submit" class="btn btn-primary">Register</button>
                                </center>
                            </form>

                        <?php
                            }
                        ?>
                    </div>
                </div>
            </div>
        </div>
    </body>
</html>