Untitled

<!DOCTYPE html>
<html>
    <head>
        <meta charset='utf-8'/>
        <meta http-equiv='Content-type' content='text/html; charset=utf-8'/>
        <meta name='viewport' content='width=device-width, initial-scale=1'/>
        <title>Submitted.</title>
    </head>
    <body>
        <?php
            $servername = "localhost";
            $username = "root";
            $password = "testing123";
            $database = "main";

            // Create connection
            $sql = new mysqli($servername, $username, $password, $database);
            if ($sql->connect_error) {
                die("Connection failed: " . $sql->connect_error);
            } else {
                echo "Connected successfully to database. <br>";
            }

            //Handle Logins
            if ($_SERVER["REQUEST_METHOD"] == "POST") {
                $username = mysqli_real_escape_string($sql, $_POST["username"]);
                $email = mysqli_real_escape_string($sql, $_POST["email"]);
                $password = mysqli_real_escape_string($sql, $_POST["password"]);
                $repeatpassword = mysqli_real_escape_string($sql, $_POST["repeatpassword"]);
                $encryptedpassword = password_hash($password, PASSWORD_DEFAULT);
                $query = "INSERT INTO USERS (username, email, password) VALUES ('$username', '$email', '$encryptedpassword')";
                if($password == $repeatpassword) {
                    mysqli_query($sql, $query);
                    echo "Account successfully created! <br>";
                }else {
                    echo "Error: passwords do not match. <br>";
                }
            }
        ?>
    </body>
</html>