Advertisement
lowheartrate

adminModule

Nov 15th, 2016
1,152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.31 KB | None | 0 0
  1. // if user is level 2 or greater
  2.         if($adminLevel > 1) {
  3.  
  4.         // start query to fetch all users that aren't admins
  5.         $fetchNonAdmins = dbConnect()->prepare("SELECT * FROM users WHERE level < 1");
  6.         $fetchNonAdmins->execute();
  7.         $nonAdmins = $fetchNonAdmins->fetchAll();
  8.  
  9.         // echo users in table that are not admins
  10.         echo '
  11.        <div class="col-md-4 admin_module">
  12.  
  13.          <table class="nonAdmins" border="1">
  14.            <tr>
  15.              <td class="table_header">ID</td>
  16.              <td class="table_header">Register Date</td>
  17.              <td class="table_header">Username</td>
  18.              <td class="table_header">Level 1</td>
  19.              <td class="table_header">Level 2</td>
  20.            </tr>
  21.        ';
  22.  
  23.         // start to fetch users that aren't admins
  24.         foreach($nonAdmins as $row) {
  25.  
  26.           echo '
  27.  
  28.          <tr>
  29.            <td class="table_content">' .$row['id']. '</td>
  30.            <td class="table_content">' .$row['register_date']. '</td>
  31.            <td class="table_content">' .$row['username']. '</td>
  32.  
  33.            <td class="table_content">
  34.            <form method="post" class="table_content_form">
  35.              <button class="btn btn-default" type="submit" name="changeLevel">Change to level 1</button>
  36.              <input type="hidden" name="user_id" value="' .$row['id']. '"/>
  37.              <input type="hidden" name="user_level" value="1"/>
  38.            </form>
  39.            </td>
  40.  
  41.            <td class="table_content">
  42.            <form method="post" class="table_content_form">
  43.              <button class="btn btn-default" type="submit" name="changeLevel">Change to level 2</button>
  44.              <input type="hidden" name="user_id" value="' .$row['id']. '"/>
  45.              <input type="hidden" name="user_level" value="2"/>
  46.            </form>
  47.            </td>
  48.          </tr>
  49.  
  50.          ';
  51.  
  52.         }
  53.  
  54.         var_dump($_POST['changeLevel_1']);
  55.         var_dump($_POST);
  56.  
  57.         // if users hits a change level 1/2 button;
  58.         if(isset($_POST['changeLevel'])) {
  59.  
  60.         // set $username var
  61.         $userid = $_POST['user_id'];
  62.         $newLevel = $_POST['user_level'];
  63.  
  64.         // update user in that row to level 1 in database
  65.         $updateLevel = dbConnect()->prepare("UPDATE users SET level = :level WHERE id = :id");
  66.         $updateLevel->bindParam(':id', $userid);
  67.         $updateLevel->bindParam(':level', $newLevel);
  68.         $updateLevel->execute();
  69.  
  70.         // echo success message and redirect
  71.         echo '<p class="success">' .$username. ' has been updated to level ' .$newLevel. '!</p>';
  72.         header('refresh:3;url=index.php');
  73.  
  74.         }
  75.  
  76.         /*
  77.         // if user hits Change to level 2 button;
  78.         if(isset($_POST['changeLevel_2'])) {
  79.  
  80.         // set $username var
  81.         $username = $row['username'];
  82.  
  83.         // update user in that row to level 2 in database
  84.         $updateLevel_2 = dbConnect()->prepare("UPDATE users SET level = '2' WHERE username = $username");
  85.         $updateLevel_2->execute();
  86.  
  87.         // echo success message and redirect
  88.         echo '<p class="success">' .$username. ' has been updated to level 2!</p>';
  89.         header('refresh:3;url=index.php');
  90.  
  91.         }
  92.         */
  93.  
  94.         echo '
  95.          </table>
  96.        </div>
  97.        ';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement