/** * Created by PhpStorm. * User: Andrew Tait (150463) * Date: 13/12/2015 * Time: 22:10 * Delete function for Permissions,Groups and Users */ $getid = htmlentities($_GET['id']); $type = htmlentities($_GET['type']); echo $type; $msg = ""; if (isset($type)) { //echo "IT works here!"; switch ($type) { case "group": $group_check = groupInUse($db, $getid, "Check"); echo $group_check; if ($group_check) { $delete_exercises = mysqli_query($db, "DELETE FROM `group` WHERE groupID = '{$getid}'"); if ($delete_exercises) { $msg = "Delete group successful"; echo "<script> alert('Group Deleted Successfully');</script>"; $page = "./?page=admin"; header("Refresh: 2; URL=\"" . $page . "\""); } } else { echo "<script> alert('Delete Group Failed');</script>"; $page = "./?page=admin"; header("Refresh: 2; URL=\"" . $page . "\""); } break;
//No users? Register then! echo "<p>No users registered on the system, please <a href='./?page=register'>Register</a></p>"; } ?> <?php if (mysqli_num_rows($permissions) > 0) { echo "<h2>Group Management</h2>"; if (mysqli_num_rows($groups) > 0) { print "\n <table border=\"1\">\n <tr>\n <td>Group ID</td>\n <td>Group Name</td>\n <td>Permission Name</td>\n <td>Edit</td>\n <td>Delete</td>\n </tr>"; while ($info = mysqli_fetch_array($groups)) { echo "<trstyle='background-color:#000000;'>"; echo "<td>" . $info['groupID'] . "</td>"; echo "<td>" . $info['groupName'] . "</td>"; echo groupName($db, $info['permissionID']); echo '<td><a href="./?page=edit_group&id=' . $info['groupID'] . '">Edit</a></td>'; echo groupInUse($db, $info['groupID'], "Row"); echo "</tr>"; } echo "</table>"; } else { echo "<p>No groups registered add one below:</p>"; } echo "<h2>Add Group</h2>"; include "includes/group/add_group.php"; } ?> <h2>Permissions Management</h2> <?php if (mysqli_num_rows($permissions) > 0) { print "\n <table border=\"1\">\n <tr>\n <td>Permission ID</td>\n <td>Permission Name</td>\n <td>Create Content</td>\n <td>Create Comments</td>\n <td>Vote</td>\n <td>Edit Vote (Admin)</td>\n <td>Edit Content</td>\n <td>Edit Comments</td>\n <td>View Content</td>\n <td>View Comments</td>\n <td>Edit</td>\n <td>Delete</td>\n </tr>";