useradd.php 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. <?php
  2. $root = $_SERVER['DOCUMENT_ROOT'];
  3. include($root . "/util/session.php"); //checks that the user is logged in
  4. include($root . "/util/privilege_check.php");
  5. checkPrivilege("admin");
  6. if ($_SERVER["REQUEST_METHOD"] == "POST") {
  7. $username = mysqli_real_escape_string($db, $_POST['username']);
  8. $sql_query = "select * from users where username = '$username'";
  9. $result = mysqli_query($db, $sql_query);
  10. //check if user exists
  11. if (mysqli_num_rows($result) != 0) {
  12. $error = "User exists";
  13. } else {
  14. $password = mysqli_real_escape_string($db, $_POST['password']);
  15. $hash = password_hash($password, PASSWORD_DEFAULT);
  16. $full_name = mysqli_real_escape_string($db, $_POST['full_name']);
  17. $usertype = mysqli_real_escape_string($db, $_POST['usertype']);
  18. $ssn = mysqli_real_escape_string($db, $_POST['ssn']);
  19. $gender = mysqli_real_escape_string($db, $_POST['gender']);
  20. $phone = mysqli_real_escape_string($db, $_POST['phone']);
  21. $email = mysqli_real_escape_string($db, $_POST['email']);
  22. $users_sql_query = "INSERT INTO `users` (`username`, `password`, `usertype`) VALUES ('$username', '$hash', '$usertype')";
  23. $users_result = mysqli_query($db, $users_sql_query);
  24. $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)";
  25. $users_info_result = mysqli_query($db, $user_info_sql_query);
  26. if ($users_result && $users_info_result) {
  27. header("Location: /admin/admin.php?msg=User added");
  28. }
  29. }
  30. }
  31. ?>
  32. <html>
  33. <head>
  34. <title>Add a user</title>
  35. <link rel="stylesheet" type="text/css" href="adminStyle.css">
  36. </head>
  37. <?php
  38. include($root . "/admin/header.php");
  39. ?>
  40. <main>
  41. <body>
  42. <li><a href="/admin/admin.php">Back</a></li>
  43. <form action="/admin/useradd.php" method="post">
  44. <label for="username">Username:</label><br>
  45. <input type="text" id="username" name="username" required><br>
  46. <label for="password">User password:</label><br>
  47. <input type="password" id="password" name="password" required><br>
  48. <label for="full_name">Full name:</label><br>
  49. <input type="text" id="full_name" name="full_name"><br>
  50. <label for="usertype">User type:</label><br>
  51. <input type="radio" id="student" name="usertype" value="student">
  52. <label for="student">Student</label><br>
  53. <input type="radio" id="teacher" name="usertype" value="teacher">
  54. <label for="teacher">Teacher</label><br>
  55. <input type="radio" id="admin" name="usertype" value="admin">
  56. <label for="admin">Admin</label><br>
  57. <label for="ssn">Social Security Number:</label><br>
  58. <input type="text" id="ssn" name="ssn"><br>
  59. <label for="gender">Gender:</label><br>
  60. <input type="text" id="gender" name="gender"><br>
  61. <label for="phone">Phone Number:</label><br>
  62. <input type="text" id="phone" name="phone"><br>
  63. <label for="email">Email Address:</label><br>
  64. <input type="email" id="email" name="email"><br>
  65. <input type="submit" value="Add">
  66. </form>
  67. <div style="font-size:11px; color:#cc0000; margin-top:10px"><?php if (isset($error)) {
  68. echo $error;
  69. } ?></div>
  70. </body>
  71. </main>
  72. <?php
  73. include($root . "/admin/footer.php");
  74. ?>
  75. </html>