Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- Admin on mysql deleting users
- */
- ?>
- <HTML>
- <BODY>
- <script language="php">
- if($react == "delete_user") {
- if($user) {
- $query = "DELETE from login WHERE user='$user' ";
- $result = mysql_query($query, $mysql_link);
- if(mysql_num_rows($result)) {
- print("<strong>$user</strong> successfully deleted<p>");
- }
- } else {
- print("<strong>no users are available to delete yet, sorry.</strong><p>");
- }
- }
- elseif ($react == "add_user") {
- if(($user) and ($pass)) {
- $query = "INSERT into login VALUES ( ";
- $query .= "0, SYSDATE(), '$username', '$password' )";
- mysql_query($query, $mysql_link);
- } else {
- print("<strong>either your user or password field was left blank</strong><p>");
- }
- }
- else {
- print("<center>Administration Area - Choose your option</center>");
- }
- </script>
- <form method="POST" action="admin.php3"><div align="center"><center><p>Delete Users
- <input type="hidden" name="react" value="delete_user">
- <select name="user" size="1">
- <script language="php">
- $query = "SELECT user FROM login ORDER BY user";
- $result = mysql_query($query, $mysql_link);
- if(mysql_num_rows($result)) {
- // we have at least one user, so show all users as options in select form
- while($row = mysql_fetch_row($result))
- {
- print("<option value=\"$row[0]\">$row[0]</option>");
- }
- } else {
- print("<option value=\"\">No users created yet</option>");
- }
- </script>
- </select><input type="submit" value="Submit"></p></center></div>
- </form>
- <form method="POST" action="admin.php3">
- <input type="hidden" name="react" value="add_user">
- <div align="center"><center><p>ADD A New User<br>
- User: <input type="text" name="user" size="20"><br>
- Pass: <input type="text" name="pass" size="20"><br>
- <input type="submit" value="Submit"></p></center></div>
- </form>
- </BODY>
- </HTML>
- 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