Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. <form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>">
  2. <table border="1" cellpadding="4">
  3. <tr>
  4. <th>Id</th>
  5. <th>Name</th>
  6.  
  7. </tr>
  8. <?php
  9. include('connect.php');
  10. $getQuery = "SELECT id,username,admin FROM tutorial_users ORDER BY id ASC";
  11. $getResult = mysql_query($getQuery) or die("Query not executed");
  12. while (list($id, $userName, $admin) = mysql_fetch_row($getResult)) {
  13. ?>
  14. <?php
  15. $checked = ($admin == 1) ? 'checked="checked"' : '';
  16. ?>
  17. <tr align="center">
  18. <td><?php echo $id; ?></td>
  19. <td><?php echo $userName; ?></td>
  20. <td><?php echo "<input type='checkbox' name='admin[]' value='$id' $checked>"; ?></td>
  21. <?php } ?>
  22. <tr>
  23. </table>
  24. <p>
  25. <input type="submit" name="submit" value="Update Role">
  26. </p>
  27. </form>
  28. <?php
  29. $updated = FALSE;
  30. if (isset($_POST['submit'])) {
  31. $admin = $_POST['admin'];
  32. $admin = join(",", $admin);
  33. $admin = "(" . $admin . ")";
  34. $defaultQuery = "UPDATE tutorial_users SET admin=0";
  35. $defaultResult = mysql_query($defaultQuery);
  36. $upQuery = "UPDATE tutorial_users SET admin=1 WHERE id IN $admin";
  37. echo $upQuery;
  38. $upResult = mysql_query($upQuery);
  39. $updated = TRUE;
  40. }
  41. ?>
  42.  
  43. <option value="the_value_of_option" <?php if(isset($_POST['something']) && ($_POST['something'] == 'the_value_of_option')){echo "selected";}?> >Label of option</option>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement