Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //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>
- ";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement