Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.14 KB | None | 0 0
  1. Hey nerve, I've got all my work saved in my documents so let get it out. Because I don't know what your excatly looking for I'll just show you something easy
  2.  
  3.  
  4. Admin on mysql deleting users
  5.  
  6.  
  7. */
  8. ?>
  9. <HTML>
  10. <BODY>
  11. <script language="php">
  12. if($react == "delete_user") {
  13.    if($user) {
  14.       $query = "DELETE from login WHERE user='$user' ";
  15.       $result = mysql_query($query, $mysql_link);
  16.          if(mysql_num_rows($result)) {
  17.             print("<strong>$user</strong> successfully deleted<p>");
  18.          }
  19.    } else {
  20.       print("<strong>no users are available to delete yet, sorry.</strong><p>");
  21.    }
  22. }
  23. elseif ($react == "add_user") {
  24.    if(($user) and ($pass)) {
  25.       $query = "INSERT into login VALUES ( ";
  26.       $query .= "0, SYSDATE(), '$username', '$password' )";
  27.       mysql_query($query, $mysql_link);
  28.    } else {
  29.       print("<strong>either your user or password field was left blank</strong><p>");
  30.    }
  31. }
  32. else {
  33.    print("<center>Administration Area - Choose your option</center>");
  34. }
  35. </script>
  36. <form method="POST" action="admin.php3"><div align="center"><center><p>Delete Users
  37. <input type="hidden" name="react" value="delete_user">
  38. <select name="user" size="1">
  39. <script language="php">
  40.    $query = "SELECT user FROM login ORDER BY user";
  41.    $result = mysql_query($query, $mysql_link);
  42.      if(mysql_num_rows($result)) {
  43.        // we have at least one user, so show all users as options in select form
  44.        while($row = mysql_fetch_row($result))
  45.        {
  46.           print("<option value=\"$row[0]\">$row[0]</option>");
  47.        }
  48.      } else {
  49.        print("<option value=\"\">No users created yet</option>");
  50.      }
  51. </script>
  52. </select><input type="submit" value="Submit"></p></center></div>
  53. </form>
  54. <form method="POST" action="admin.php3">
  55. <input type="hidden" name="react" value="add_user">
  56. <div align="center"><center><p>ADD A New User<br>
  57. User: <input type="text" name="user" size="20"><br>
  58. Pass: <input type="text" name="pass" size="20"><br>
  59. <input type="submit" value="Submit"></p></center></div>
  60. </form>
  61. </BODY>
  62. </HTML>
  63.  
  64.  
  65. I've got plenty more to show you but here I'm just showing you something easy
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement