<form method="post" action="scripts/signup.php" class="ui form"">
                <div class="field">
                    <label>UserName</label>
                    <input type="text" name="username" placeholder="Choose a unique UserName">
                </div>
                <div class="field">
                    <label>Name</label>
                    <input type="text" name="name" placeholder="Name" required>
                </div>
                <div class="field">
                    <label>Address</label>
                    <input type="text" name="address" placeholder="Address" required>
                </div>
                <div class="field">
                    <label>E-mail</label>
                    <input type="email" name="email" placeholder="Your E-Mail" required>
                </div>
                <div class="field">
                    <label>Password</label>
                    <input type="password" name="password" placeholder="Your Password" required>
                </div>
                <div class="field">
                    <label>Confirm Password</label>
                    <input type="password" name="password2" placeholder="Confirm Password" required>
                </div>


                <button type="submit" name="submit" class="ui  big inverted red button" value="submit">Register</button>
                <br/>
                <br/>
            </form>

<?php


if (isset($_POST['submit'])) {
    include_once 'dbh.php';

    $username = mysqli_escape_string($conn, $_POST['username']);
    $name = mysqli_escape_string($conn, $_POST['name']);
    $address = mysqli_escape_string($conn, $_POST['address']);
    $email = mysqli_escape_string($conn, $_POST['email']);
    $password = mysqli_escape_string($conn, $_POST['password']);



        // cccheck if username is already in db
        $query = "SELECT * FROM users WHERE username='$username'";
        $res = mysqli_query($conn, $query);
        $rescheck = mysqli_num_rows($res);

        //if the query returns a row or multiple
        if ($rescheck > 0) {
            header("Location: ../reg.php?reg=usernamesame");
            exit();

        } else {

            //password hashing
            $hashed_password = password_hash($password, PASSWORD_DEFAULT);


            //write user too db
            $sql_insert = "INSERT INTO users(username, name1, address, email, pass)VALUES ('$username','$name','$address','$email','$hashed_password');";

            $results = mysqli_query($conn, $sql_insert);

            echo $results;
            header("Location: ../reg.php?reg=succcess");
            exit();

        }




} else {
    header("Location: ../reg.php?reg=Error");
    exit();
}

$conn =  mysqli_connect($server_name, $username,$password,$db_Name);