//Where my connection is.
include ("global.php");


$sql = "SELECT * FROM user_tb";
$result = $conn->query($sql);
 $row = $result->fetch_assoc();

if($_POST)
    {
            if($username==null)
            {
            echo"<font face ='Trebuchet MS'><font color='black'><div class='content'>Please input required field.</div></font>";

            }

        elseif($result->num_rows==$row['username'])
        {
        echo"<font face ='Trebuchet MS'><font color='black'><div class='content'>Username already exist.</div></font>";

        }


        elseif($password==null)
        {
        echo"<font face ='Trebuchet MS'><font color='black'><div class='content'>Please input required field.</div></font>";

        }


        else if($password!==$retypepassword)

        {
        echo "<font face ='Trebuchet MS'><font color='black'><div class='content'>Password Does not Match. </div></font>";
        }


else if (strlen($password < 5 ))
        {
        echo"<font face ='Trebuchet MS'><font color='black'><div class='content'>Password must contain at least 8-10 characters.</div></font>";

        }


    else if($fname==null)

        {
        echo "<font face ='Trebuchet MS'><font color='black'><div class='content'>Please input required field.</div> </font>";
        }

    else if($type==null)

        {
        echo "<font face ='Trebuchet MS'><font color='black'><div class='content'>Please input required field. </div></font>";
        }


 else if ($type=="mis")


    {


        $none="mis";

                    $sql = "INSERT INTO user_tb (username , password  , type ,branch , name  ) VALUES ('$username' , '$password'  ,'$type' , '$none' , '$fname')";
$conn->query($sql);


         echo " <script type="text/javascript">

    alert('New User Added');
        window.close();

    </script>
    ";
    }



 else if ($type=="warehouse")

    {

        $none="warehouse";

                    $sql = "INSERT INTO user_tb (username , password  , type ,branch , name  ) VALUES ('$username' , '$password'  ,'$type' , '$none' , '$fname')";
$conn->query($sql);


         echo " <script type="text/javascript">

    alert('New User Added');
        window.close();

    </script>
    ";
    }


        else {





                    $sql = "INSERT INTO user_tb (username , password  , type ,branch , name ) VALUES ('$username' , '$password'  ,'$type' , '$user' , '$fname')";
$conn->query($sql);

    echo " <script type="text/javascript">

    alert('New User Added');
        window.close();

    </script>
    ";


    }
}

?>