useradd.php 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. $root = $_SERVER['DOCUMENT_ROOT'];
  3. include($root . "/util/config.php");
  4. include($root . "/util/session.php");//checks that the user is logged in
  5. include($root . "/util/privilege_check.php");
  6. checkPrivilege("admin");
  7. if($_SERVER["REQUEST_METHOD"] == "POST"){
  8. $username=mysqli_real_escape_string($db,$_POST['username']);
  9. $sql_query="select * from users where username = '$username'";
  10. $result=mysqli_query($db,$sql_query);
  11. //check if user exists
  12. if(mysqli_num_rows($result) != 0){
  13. $error="User exists";
  14. }
  15. else{
  16. $password=mysqli_real_escape_string($db,$_POST['password']);
  17. $full_name=mysqli_real_escape_string($db,$_POST['full_name']);
  18. $usertype=mysqli_real_escape_string($db,$_POST['usertype']);
  19. $ssn=mysqli_real_escape_string($db,$_POST['ssn']);
  20. $gender=mysqli_real_escape_string($db,$_POST['gender']);
  21. $phone=mysqli_real_escape_string($db,$_POST['phone']);
  22. $email=mysqli_real_escape_string($db,$_POST['email']);
  23. $users_sql_query="INSERT INTO `users` (`username`, `password`, `usertype`) VALUES ('$username', '$password', '$usertype')";
  24. mysqli_query($db,$users_sql_query);
  25. $user_info_sql_query="INSERT INTO `user_info` (`login`, `full_name`, `ssn`, `gender`, `phone`, `email`, `picture`) VALUES ('$username', '$full_name', '$ssn', '$gender', '$phone', '$email', NULL)";
  26. mysqli_query($db,$user_info_sql_query);
  27. echo "$password $full_name $usertype $ssn $email";
  28. }
  29. }
  30. ?>
  31. <html>
  32. <body>
  33. <li><a href="/admin/admin.php">Back</a></li>
  34. <form action="/admin/useradd.php" method="post">
  35. <label for="username">Username:</label><br>
  36. <input type="text" id="username" name="username"><br>
  37. <label for="password">User password:</label><br>
  38. <input type="password" id="password" name="password"><br>
  39. <label for="full_name">Full name:</label><br>
  40. <input type="text" id="full_name" name="full_name"><br>
  41. <label for="usertype">User type:</label><br>
  42. <input type="radio" id="student" name="usertype" value="student">
  43. <label for="student">Student</label><br>
  44. <input type="radio" id="teacher" name="usertype" value="teacher">
  45. <label for="teacher">Teacher</label><br>
  46. <input type="radio" id="admin" name="usertype" value="admin">
  47. <label for="admin">Admin</label><br>
  48. <label for="ssn">Social Security Number:</label><br>
  49. <input type="text" id="ssn" name="ssn"><br>
  50. <label for="gender">Gender:</label><br>
  51. <input type="text" id="gender" name="gender"><br>
  52. <label for="phone">Phone Number:</label><br>
  53. <input type="text" id="phone" name="phone"><br>
  54. <label for="email">Email Address:</label><br>
  55. <input type="email" id="email" name="email"><br>
  56. <input type="submit" value="Submit">
  57. </form>
  58. <div style = "font-size:11px; color:#cc0000; margin-top:10px"><?php if(isset($error)){echo $error;} ?></div>
  59. </body>
  60. </html>