<form action="/" method="post">


            <div class="field-wrap">
              <label>
                Name<span class="req">*</span>
              </label>
              <input name="name" type="text" required autocomplete="off" />
            </div>

            <div class="field-wrap">
              <label>
                Username<span class="req">*</span>
              </label>
              <input name = "username" type="text" required autocomplete="off" />
            </div>


          <div class="field-wrap">
            <label>
              Email Address<span class="req">*</span>
            </label>
            <input name="email" type="text"required autocomplete="off"/>
          </div>

          <div class="field-wrap">
            <label>
              Set A Password<span class="req">*</span>
            </label>
            <input name="password" type="password"required autocomplete="off"/>
          </div>

          <button type="submit" class="button button-block"/>Create Account</button>


          <?php
            if(isset($_POST['submit']))
            {

              $name = $_POST['name'];
              $username = $_POST['username'];
              $email = $_POST['email'];
              $password = $_POST['password'];
              $SQL = "INSERT INTO users (name, username, email, password) VALUES ('$name', '$username', '$email', '$password')";
              $result = mysqli_query($SQL);
            }
          ?>

          </form>