useradd.php 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  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. }
  14. else{
  15. $password=mysqli_real_escape_string($db,$_POST['password']);
  16. $hash=password_hash($password,PASSWORD_DEFAULT);
  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', '$hash', '$usertype')";
  24. $users_result=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. $users_info_result=mysqli_query($db,$user_info_sql_query);
  27. if($users_result && $users_info_result){
  28. header("Location: /admin/admin.php?msg=User added");
  29. }
  30. }
  31. }
  32. ?>
  33. <html>
  34. <head>
  35. <title>Add a user</title>
  36. <link rel="stylesheet" type="text/css" href="adminStyle.css">
  37. </head>
  38. <body>
  39. <?php
  40. include($root . "/admin/header.php");
  41. ?>
  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"><br>
  46. <label for="password">User password:</label><br>
  47. <input type="password" id="password" name="password"><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="Submit">
  66. </form>
  67. <div style = "font-size:11px; color:#cc0000; margin-top:10px"><?php if(isset($error)){echo $error;} ?></div>
  68. <?php
  69. include($root . "/admin/footer.php");
  70. ?>
  71. </body>
  72. </html>