Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // if user is level 2 or greater
- if($adminLevel > 1) {
- // start query to fetch all users that aren't admins
- $fetchNonAdmins = dbConnect()->prepare("SELECT * FROM users WHERE level < 1");
- $fetchNonAdmins->execute();
- $nonAdmins = $fetchNonAdmins->fetchAll();
- // echo users in table that are not admins
- echo '
- <div class="col-md-4 admin_module">
- <table class="nonAdmins" border="1">
- <tr>
- <td class="table_header">ID</td>
- <td class="table_header">Register Date</td>
- <td class="table_header">Username</td>
- <td class="table_header">Level 1</td>
- <td class="table_header">Level 2</td>
- </tr>
- ';
- // start to fetch users that aren't admins
- foreach($nonAdmins as $row) {
- echo '
- <tr>
- <td class="table_content">' .$row['id']. '</td>
- <td class="table_content">' .$row['register_date']. '</td>
- <td class="table_content">' .$row['username']. '</td>
- <td class="table_content">
- <form method="post" class="table_content_form">
- <button class="btn btn-default" type="submit" name="changeLevel">Change to level 1</button>
- <input type="hidden" name="user_id" value="' .$row['id']. '"/>
- <input type="hidden" name="user_level" value="1"/>
- </form>
- </td>
- <td class="table_content">
- <form method="post" class="table_content_form">
- <button class="btn btn-default" type="submit" name="changeLevel">Change to level 2</button>
- <input type="hidden" name="user_id" value="' .$row['id']. '"/>
- <input type="hidden" name="user_level" value="2"/>
- </form>
- </td>
- </tr>
- ';
- }
- var_dump($_POST['changeLevel_1']);
- var_dump($_POST);
- // if users hits a change level 1/2 button;
- if(isset($_POST['changeLevel'])) {
- // set $username var
- $userid = $_POST['user_id'];
- $newLevel = $_POST['user_level'];
- // update user in that row to level 1 in database
- $updateLevel = dbConnect()->prepare("UPDATE users SET level = :level WHERE id = :id");
- $updateLevel->bindParam(':id', $userid);
- $updateLevel->bindParam(':level', $newLevel);
- $updateLevel->execute();
- // echo success message and redirect
- echo '<p class="success">' .$username. ' has been updated to level ' .$newLevel. '!</p>';
- header('refresh:3;url=index.php');
- }
- /*
- // if user hits Change to level 2 button;
- if(isset($_POST['changeLevel_2'])) {
- // set $username var
- $username = $row['username'];
- // update user in that row to level 2 in database
- $updateLevel_2 = dbConnect()->prepare("UPDATE users SET level = '2' WHERE username = $username");
- $updateLevel_2->execute();
- // echo success message and redirect
- echo '<p class="success">' .$username. ' has been updated to level 2!</p>';
- header('refresh:3;url=index.php');
- }
- */
- echo '
- </table>
- </div>
- ';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement